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?