Greetings,
Here is how to reproduce:
- Start with an empty spreadsheet.
- When focused on cell A0 , go to "Insert" ribbon tab, click "Table", click "OK" button.
- Save the spreadsheet content with saveAsJSON. My output attached below.
- Load the spreadsheet JSON we just exported using loadFromJSON (either in the same instance or after full page refresh)
- Spreadsheet doesn't load, error in console
I tried with several sizes, positions and contents of tables, all failed when attempting to reload.
Here is my exported JSON:
{"dataContainer":{"sheets":{"1":{"0":{"0":{"type":10,"value":0,"value2":0,"align":"left","format":20}},"1":{"0":{"format":21}}}},"sheetCellType":{},"hashCode":["e-format6N6N2N111N1N1N1N1N","e-formatFFC7CE82012A71N111N1N1N1N1N","e-formatC6EED20A704371N111N1N1N1N1N","e-formatFEEC9B82671771N111N1N1N1N1N","e-format6N6N71N111N1N1N1N2N","e-format6N6N71N181N1N1N1N1N","e-formatDDE5F66N71N111N1N1N1N1N","e-formatFDE0D26N71N111N1N1N1N1N","e-formatEEEEEC6N71N111N1N1N1N1N","e-formatFEF4CD6N71N111N1N1N1N1N","e-format9CC0E76N71N111N1N1N1N1N","e-formatF9AD7B6N71N111N1N1N1N1N","e-formatC9C9C96N71N111N1N1N1N1N","e-formatFED9656N71N111N1N1N1N1N","e-format559AD9FFFFFF71N111N1N1N1N1N","e-formatEB7E2FFFFFFF71N111N1N1N1N1N","e-formatA5A5A5FFFFFF71N111N1N1N1N1N","e-formatFDBF01FFFFFF71N111N1N1N1N1N","e-border1N1N6N1N1N6N110000001N1N6N","e-border1N1N6N11000000110000001N1N6N","e-format6N0000002N2N1N1N1N1N2N","e-formatD9D9D90000002N2N1N1N1N1N1N","e-border1N1N6N110000001N1N6N1N1N6N"],"sharedData":["Column1"],"cellType":["string","number","custom","formula","time","longdate","shortdate","scientific","fraction","text","general","accounting","currency","percentage","date","datetime"],"valData":[],"cFormatData":["clear_1_A1:A1"]},"model":{"allowFormulaBar":false,"sheets":[{},{"colCount":21,"rowCount":51,"columnsWidthCollection":[64,64,64,64,64,64,64,64,64,64,64,64,64,64,64,64,64,64,64,64,64],"rowsHeightCollection":[20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20],"tableManager":{"1":{"name":"Table1","range":[0,0,1,0],"isFilter":true,"format":{"headerLayout":{"font-weight":"bold","color":"#000000","border":{"top":"1px solid #000000","bottom":"1px solid #000000"}},"contentLayout":[{"background-color":"#D9D9D9","color":"#000000"},{"color":"#000000"}],"contentBorder":{"border":{"bottom":"1px solid #000000"}}},"formatName":"TableStyleLight1"}},"_endCell":{"rowIndex":1},"_activeCell":{"rowIndex":1},"sheetInfo":{"text":"Sheet1"},"usedRange":{"rowIndex":1},"shapeMngr":{"picture":{},"chart":{},"sharedPics":[]},"pivotMngr":{"pivot":{}}}],"nameManager":[{"name":"Table1","refersto":"Sheet1!$A$1:$A$2","comment":"","scope":"WorkBook","sheetIndex":1}],"loadComplete":"loadComplete","openFailure":"openfailure"}}
Thanks.