Differences between Spread.Sheets and Spread.Services

Posted by: diegoar27 on 3 November 2017, 7:10 am EST

  • 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.

    Files.zip
  • Replied 6 November 2017, 2:44 am EST

    Hi Diego,

    Thank you for providing me the files. I am able to replicate the issue as described by you. I will report it to the development team for further investigation and let you know the tracking id.

    Thanks,
    Deepak Sharma
  • Replied 7 November 2017, 12:42 am EST

    Hello,

    Tracking id for this issue is 249254. I will let you know as soon as I hear anything from the development team.

    Thanks,
    Deepak Sharma
  • Replied 22 May 2018, 12:32 am EST

    Thank you for an valuable information. I will soon try to implement it

    Regards,
    Adrian Gates
    System Admin - https://www.apps4rent.com
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels