#Value Errors in attached template

Posted by: dean.kinnear on 12 December 2024, 2:41 pm EST

  • Posted 12 December 2024, 2:41 pm EST

    Select “Income statement disclosures” worksheet and look at cells C7 and U7

    In spreadjs, #VALUE! errors are displayed, while not displayed in Excel.

    Thanks,

    Dean Kinnear

  • Posted 13 December 2024, 2:46 am EST

    Hi,

    It seems you may have missed attaching the file or sample. Could you kindly check and share the required file/sample?

    Regards,

    Priyam

  • Posted 13 December 2024, 8:32 am EST - Updated 13 December 2024, 9:16 am EST

    Keeps getting stripped out for some reason.

    test.zip

    If the upload doesn’t work, here is a link to the workbook on my onedrive:

    https://1drv.ms/x/c/c9ca54f2d212bf0a/EdfM4d9m1dNLhE6SOANdEasBCkpzp1YcaL9QXO16_ZEvHw?e=cfUBGs

    Thanks!

  • Posted 16 December 2024, 4:57 am EST - Updated 16 December 2024, 5:03 am EST

    Hi,

    Thank you for sharing the Excel file.

    I was able to replicate the behavior on my end. After investigating, it seems there may be an issue with the Excel file itself. Saving the file again in Excel resolves the issue, as well as exporting the file from Excel Online and reloading it. Please refer to the attached gif “Steps.gif” and the designer link below for more details:

    Gif:

    Designer: https://developer.mescius.com/spreadjs/designer/index.html

    SpreadJS does not support Excel files generated by third-party applications. If the file was created using such tools, the issue may stem from the third-party app. However, if the file was generated by Excel or our tools, such as DSExcel or SpreadJS, please provide the steps to reproduce this issue so we can investigate further. If the file was not created using third-party tools and you’re using an older version of SpreadJS, I recommend testing with the latest version (17.1.10) to see if the issue persists.

    Regarding the issue of “Keeps getting stripped out for some reason,” you mentioned that the file initially wasn’t uploading but eventually succeeded. Could you share the changes you made that allowed the upload? This will help us look into it.

    Regards,

    Priyam

Need extra support?

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

Learn More

Forum Channels