Hidden groups with frozen panes

Hidden groups with frozen panes

Posted by: frederik.beaudry on 10 June 2022, 5:22 am EST

• 

  frederik.beaudry

  • Post Options:
  • Link
    Copy

  Posted 10 June 2022, 5:22 am EST - Updated 3 October 2022, 12:14 am EST

  Hello,

  I found a discrepancy between the way this is handled in Excel vs SpreadJs.

  See the Excel file in the attached zip.

  The Excel file has the following:

  • Group from A to D
  • Group from F to I
  • Group from K to O
  • Group from Q to V
  • Frozen Panes in AK4
  • All columns from A to Z are hidden

  This is what the file looks like when opened in Excel :

  

  As you can see, all the columns that are supposed to be hidden are hidden

  Here is the file opened in SpreadJs :

  

  1096×109 2.82 KB

  As you can see, all the group expand columns for the hidden columns are visible

  This problem doesn’t seem to happen when there are no frozen panes.

  Here is what happens when clicking on 2 (Expanding all groups) in Excel :

  

  1749×109 4.45 KB

  The group expand columns seem to have a width of 0

  Here is what happens when clicking on 2 (Expanding all groups) in SpreadJs :

  

  1355×104 2.37 KB

  The group expand columns are fully visible. So when pressing on 1 (collapse all groups), the group columns will remain visible.

  Are you aware of this? Are those bugs or will we have to handle these cases programatically on our end?

  Thanks!

  testspreadjs.zip

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 12 June 2022, 8:22 pm EST

  Hi,

  We are able to replicate the issue at our end hence we have escalated this issue to the concerned team for further investigation. The internal ID for this issue will be SJS-13377.

  Regards,
  
  Avinash