Error Exp_FormulaInvalid in languagePackages

Posted by: khauam.cardoso on 28 January 2025, 1:16 pm EST

  • Posted 28 January 2025, 1:16 pm EST

    When I try to open or import a file that contains a specific style in the cell, I am receiving the following error Exp_FormulaInvalid, this only happens for the Spanish language

    the spread cannot complete the opening

      GC.Spread.CalcEngine.LanguagePackages.idiomaPackages('es');
  • Posted 28 January 2025, 2:20 pm EST

  • Posted 29 January 2025, 3:00 am EST - Updated 29 January 2025, 3:05 am EST

    Hi,

    As per my understanding, you are encountering an error while importing an Excel file when the language is set to Spanish.

    I attempted to replicate the issue on my end using the provided information but was unable to do so. The file imports successfully in the Spanish language without any issues. Refer to the attached GIF “Steps.gif” and sample “Sample.zip”: Sample.zip

    Gif:

    To better assist you, could you share a minimal working sample along with the steps to replicate the behavior you have observed, or modify the existing sample to replicate the behavior? This will enable me to investigate the problem more thoroughly. Additionally, It would be helpful if you could provide a GIF or video illustrating the issue.

    Regards,

    Priyam

  • Posted 29 January 2025, 6:38 am EST

    I’ll try to replicate it in a demo, I’m currently using spread 17.0.4 in angular 16

  • Posted 30 January 2025, 2:59 am EST

    Hi,

    We have successfully reproduced the reported issue in SpreadJS version 17.0.4.

    Root Cause Analysis:

    The issue arises due to how formulas are applied to shapes in SpreadJS. Currently, SpreadJS does not support applying reference formulas directly to shapes, and this feature request is present in our product backlog with internal tracking id SJS-26669.

    In Excel, when a formula is applied to a shape, the formula is bound to the shape itself.

    However, in SpreadJS, applying a formula while a shape is selected results in the formula being assigned to the cell beneath the shape, rather than the shape itself.

    Resolution:

    This bug has been fixed in latest version of SpreadJS V18.0.2 . We recommend updating to the latest version to ensure proper functionality and avoid this issue.

    We hope this information helps. Please let us know if you need any further clarification.

    Best Regards,

    Ankit

Need extra support?

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

Learn More

Forum Channels