ReportSheet Collapse/Expand All

Posted by: Jean.s on 10 May 2024, 4:22 am EST

    • Post Options:
    • Link

    Posted 10 May 2024, 4:22 am EST

    Hi,

    It would be very helpful to enable users to expand/collapse all nodes in a ReportSheet.

    Additionally, having a property or formula to specify the initial state of the expansion would be greatly appreciated.

    Best Regards

  • Posted 13 May 2024, 2:55 am EST

    Hi,

    I couldn’t understand your use case and what nodes you want to expand/collapse.

    Could you kindly share your use case and the sample with the nodes that you want to expand/collapse in the Report Sheet? Also, a screenshot/video/gif of the requirement would be appreciated.

    Regards,

    Ankit

  • Posted 13 May 2024, 6:50 am EST - Updated 13 May 2024, 6:55 am EST

    Starting from your demo at https://developer.mescius.com/spreadjs/demos/features/report-sheet/showcase/grouped-report/v-tree-sales-report/purejs, it would be highly beneficial to implement an API along with a Context Menu feature that enables users to expand/collapse nodes (possibly recursively) beneath the mouse position, such as each node rooted under ‘John’…

    Additionally, the ability to set the initial expansion state for each node would be greatly appreciated.

  • Posted 13 May 2024, 7:53 am EST

    Hi,

    Thanks for sharing the demo link and the screenshot. I understand your requirement clearly. I have escalated your requirements to the dev team to add these features as an enhancement.

    The internal tracking id for the same is: SJS-24206. I will let you know when there is more info on this from the dev team.

    Regards,

    Ankit

  • Posted 14 May 2024, 12:36 am EST

    Hi,

    The devs have added the requested feature to the product backlog with internal tracking id: SJS-24209.

    Currently, there is no ETA on this feature. I will let you know when there is more info on this from the dev team or when the feature will be available.

    Regards,

    Ankit

  • Posted 20 December 2024, 7:16 am EST

    Hi,

    The requested feature has been added to the new release of SpreadJS V18. You could refer to the following demo: https://developer.mescius.com/spreadjs/demos/features/report-sheet/layout-settings/initial-expansion-state/purejs

    The following API can be used to toggle the collapse state: https://developer.mescius.com/spreadjs/api/classes/GC.Spread.Report.ReportSheet#togglecollapsestate

    Regards,

    Ankit

  • Posted 20 December 2024, 8:18 am EST

    Hi Ankit,

    Thanks for the update.

    I have tried the demo but it doesn’t seem to be working properly.

    I was expecting all rows to be collapsed/expanded when I select the corresponding context menu, instead it seems to only work on the current row.

    Kind regards

  • Posted 23 December 2024, 6:11 am EST - Updated 23 December 2024, 6:16 am EST

    Hi,

    I have reviewed the functionality, and it is working as expected. When clicking “Collapse All,” all nodes under “John” collapse, and when clicking “Expand All,” all nodes expand. Refer to the attached GIF “Steps.gif” and the demo link below:

    https://developer.mescius.com/spreadjs/demos/features/report-sheet/showcase/grouped-report/v-tree-sales-report/purejs

    Gif:

    Could you kindly share a sample with detailed steps to replicate the behavior? Additionally, providing a video or GIF illustrating the issue would help us understand and assist you better.

    Regards,

    Priyam

  • Posted 24 December 2024, 4:38 am EST

    Hi Priyam,

    you are right, I understood the misunderstanding.

    Although it was not clear, I meant that the functionality acted on all rows, not just the one under the cursor. You correctly implemented the ‘Collapse/Expand All’ functionality for all layers under a single row but not for all rows in the grid.

    This second functionality would be even more useful.

    Kind Regards

  • Posted 24 December 2024, 8:34 am EST

    Hi,

    We are currently discussing this with the development team. The internal tracking ID for this issue is “SJS-27876”. I will keep you updated as soon as I receive any information.

    Regards,

    Priyam

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels