Posted 3 November 2017, 7:10 am EST
Hi!
I’ve been testing a bit more the Spread.Services with the hack that @deepak sent me on the post https://www.grapecity.com/en/forums/spread-services/exception-create-workbook- and I found some differences that I want to know how can I prevent those.
That are the steps that I’m doing to get that diferences:
1- I created a json content from the file Test-Apportionment (attached) using ExcelIO.Importer library and I stored it on my local db.
*I’m using spread.sheets to see that json content and all works as expected.
2- I take that json content and transform it (as @deepak said on the post that I refered before) to load a Spread.Services.Workbook from my json content and then take the json from the workbook to render it on spreadJS.sheets.
*I attached images with the result.
The differences that i found are:
- I lost all styles that I had applied over that file.
- I lost cells format (like dates and numeric values).
- I have a new blank column to the end of the document.
- The column’s widht is different now.
I attached images about the result of the spreadjs viewer, excel file that i’m talking about and both json files.
Thanks in advance.
Diego.