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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Error loading a spreadsheet with a table

Thread ID:

Created:

Updated:

Platform:

Replies:

126121 Sep 25,2016 10:16 PM UTC Sep 26,2016 11:56 AM UTC JavaScript 1
loading
Tags: ejSpreadSheet
Gabriel Axel
Asked On September 25, 2016 10:16 PM UTC

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 [Syncfusion]
Replied On 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 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;