Page breaks are not exported to excel if workbook is created without host

Page breaks are not exported to excel if workbook is created without host

Posted by: pavloboiko on 3 June 2024, 7:45 am EST

• 

  pavloboiko

  • Post Options:
  • Link
    Copy

  Posted 3 June 2024, 7:45 am EST

  If we create a workbook without host element, then add a page break to some row - resulting spread JSON will not have one property, that for some reason will prevent page breaks from being exported to Excel via ExcelIO.
  
  Example of the workbook creation:

  new Spread.Sheets.Workbook(undefined);

  Missing lines from json:

        "printInfo": {
          "paperSize": {
            "width": 850,
            "height": 1100,
            "kind": 1
          }
        },

  There’s a workaround for this issue. If we call a

  .printInfo()

  for a sheet - it will automatically decorate the JSON of that sheet with missing fields.
  
  Perhaps there’s a way how to do it properly without workarounds?

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 4 June 2024, 4:54 am EST

  Hi,

  I was able to replicate the behavior with the latest version of SpreadJS V17.0.10. I have escalated it to the dev team for further investigation.

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

  Regards,

  Ankit

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 11 July 2024, 10:13 am EST

  Hi,

  The mentioned issue with internal tracking id SJS-24643 has been fixed in the SpreadJS v17.1.0. Kindly upgrade to the latest version and let us know if you still face the same issue.

  Regards,

  Ankit