Spreadsheet ToJSON breaks external references

2 posts, 1 answers
  1. MikeWiese
    MikeWiese avatar
    41 posts
    Member since:
    Apr 2007

    Posted 18 Aug Link to this post

    All of our spreadsheets contain external references. That is, cells that retrieve values from other worksheets in the same workbook using formulae similar to =SomeOtherWorksheet!B13. 

    Our application workflow is pretty basic. We load a customer spreadsheet into the client-side kendoSpreadsheet control using the native "Load" button in the toolbar. We then save a representation of that workbook (from the toJSON() method) back to the server.

    Later on, in server-side code, we Load() that json string into a Telerik.Web.Spreadsheet.Workbook and convert it to a Telerik.Windows.Documents.Spreadsheet.Model.Workbook. We then retrieve the value of certain cells with CellSelection.GetValue();

    Unfortunately, when a cell formula refers to a cell on another worksheet, it fails. To be precise, cell.GetValue().Value.GetResultValueAsString(new CellValueFormat("")) comes back as "#REF!"

    This only happens after the spreadsheet has been serialised/deserialised via JSON. If we load the exact same spreadsheet via 
         new XlsxFormatProvider().Import(myExcelFileStream)
    then those external references work just fine. 

    Am I doing something wrong? I could not find anything in this forum or User Voice that relate to this bug. Is there a workaround?


  2. Answer
    T. Tsonev
    Admin
    T. Tsonev avatar
    2770 posts

    Posted 22 Aug Link to this post

    Hello,

    Thanks for the bug report. I've opened an issue on our GitHub. We'll keep it up-to-date and close it once resolved.
    I couldn't find a workaround at the moment.

    I've updated our Telerik points as a token of gratitude for your involvement.

    Regards,
    T. Tsonev
    Telerik by Progress
     
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
     
  3. Kendo UI is VS 2017 Ready
Back to Top