How to do grouping on a flex sheet

How to do grouping on a flex sheet

Posted by: ambarish.banerjee12 on 4 June 2020, 7:43 am EST

• 

  ambarish.banerjee12

  • Post Options:
  • Link
    Copy

  Posted 4 June 2020, 7:43 am EST

  I want to do grouping on the flex sheet similar to what exists on the flex grid . How to do that?

• 

  ambarish.banerjee12

  • Post Options:
  • Link
    Copy

  Posted 4 June 2020, 10:46 pm EST

  http://jsfiddle.net/fwprgjn6/66/
  
  As you can see , writing just the group descriptions groups the data together. But the name US comes all the time, even the product names are repeated . I want them to come only once. Is there any method to do that. Or i have to go through the cells and manually change.

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 5 June 2020, 4:59 am EST

  Hi,

  In FlexGrid or FlexSheet, the grouped column is not hidden automatically. You need to manually update the visibility of the columns on with the grouping is applied. Please refer to the sample link below for reference:

  https://stackblitz.com/edit/js-1kdxvd

  Regards,
  
  Ashwin