Spreadsheet ToJSON breaks external references

2 posts, 1 answers
  1. MikeWiese
    MikeWiese avatar
    38 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
    T. Tsonev avatar
    2760 posts

    Posted 22 Aug Link to this post


    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.

    T. Tsonev
    Telerik by Progress
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
Back to Top