Error after loading column group

Error after loading column group

Posted by: david.paradis on 25 January 2022, 4:17 pm EST

• 

  david.paradis

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 25 January 2022, 4:17 pm EST

  Hello,

  Check this excel sample, if i load the file on excel, the group show properly.
  
  If i load on spreadjs, tested on https://www.grapecity.com/spreadjs/designer/index.html too, the group load with a plus icon (+) instead of a minus icon (-).

  Thanks!

• 

  david.paradis

  • Post Options:
  • Link
    Copy

  Posted 25 January 2022, 4:18 pm EST

  demoGroup.zip

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 27 January 2022, 6:20 am EST

  Hi,

  Upon investigation, we found that the problem is with the Excel file. The file might have stored the state of row outline group as collapsed and therefore SpreadJS is showing +(Expand Sign) instead of -(Collapsed Sign).
  
  We would like to know how you generated the Excel file. If the excel file is generated using any of our products, we would like you to mention the steps that you have followed, so that we can investigate the issue further at our end. There is a simple fix available to this issue.
  
  Things we did to fix the issue:

  Open the file in Excel.

  Save the file without making any other changes.

  Load the file in SpreadJS and it seems to be working fine. Upon saving the file in Excel, it saves the correct state of the collapsed row outline group.

  Regards.

• 

  david.paradis

  • Post Options:
  • Link
    Copy

  Posted 27 January 2022, 10:42 am EST

  Hello, the file was generated with aspose, we will check with them.

  Thank you for your support!

• 

  sebastien.vincent

  • Post Options:
  • Link
    Copy

  Posted 27 January 2022, 11:52 am EST

  Here is a bug that I reproduced in the demo of spreadJS on the notion of Group. Maybe that could help you locate the problem.2022-01-27 10-44-21.zip

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 28 January 2022, 2:20 am EST - Updated 3 October 2022, 9:27 am EST

  Hi,

  We were unable to replicate the issue at our end with the latest version V15.0.0. Please have a look at the attached gif in which we have followed the steps you have mentioned and let us know if we are missing any step(s).
  
  If the issue still persists for you, please let us know the environment details such as OS, the browser version you are using so that we may test on a similar environment once. I have tested with Chrome Version 97.0.4692.99
  
  and Microsoft Edge Version 97.0.1072.69.

  Regards,