We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

Error loading a spreadsheet with a table

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.

1 Reply

SI Silambarasan I Syncfusion Team September 26, 2016 11:56 AM UTC

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.  
 
 
 
Regards, 
Silambarasan I 


Loader.
Live Chat Icon For mobile
Up arrow icon