Error loading a spreadsheet with a table

[Gabriel Axel]

Greetings,

Here is how to reproduce:

1. Start with an empty spreadsheet.
2. When focused on cell A0 , go to "Insert" ribbon tab, click "Table", click "OK" button.
3. Save the spreadsheet content with saveAsJSON. My output attached below.
4. Load the spreadsheet JSON we just exported using loadFromJSON (either in the same instance or after full page refresh)
5. 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.

[Silambarasan I]

Hi Gabriel, 

 

Thank you for contacting Syncfusion support. 

 

We have checked the reported issue and we are able to reproduce it in our end.   We considered this as a defect and a new support incident has been created under your account to track the status of this requirement.  Please log on to our support website to check for further updates.  

 

https://www.syncfusion.com/account/login?ReturnUrl=/support/directtrac/incidents 

 

 

Regards, 

Silambarasan I