#NAME error with formulas

[dmt0]

Hi Paul,

I'm having an issue with formulas. Basic formulas like SUM would display #NAME. It happens intermittently and I can't repro it outside of my dev setup. But I also have no Idea how to debug it.

Here are some details:

Stack trace:

index.js:546 Error: #NAME?
    at eval (index.js:475:139)
    at eval (index.js:548:376)
    at eval (index.js:548:396)
    at eval (index.js:5:71)
    at eval (index.js:5:155)

"jspreadsheet": "10.7.1",
"@jspreadsheet/copypaste_advanced": "3.3.1",
"@jspreadsheet/formula-pro": "4.2.0",
"@jspreadsheet/parser": "4.0.5",
"@jspreadsheet/render": "4.0.0",
"@jspreadsheet/search": "3.0.1",
"@jspreadsheet/statusbar": "2.7.1",

[paulorodalves]

One possible explanation could be that setExtensions is being called after the spreadsheet creation. At the moment you create the formula, the extension might not yet have a formula associated with it. The occurrence of this issue could be related to other asynchronous operations, such as useEffect, but pinpointing the exact cause is challenging without more context. Could you share any additional information? It would be helpful to find the problem

[dmt0]

Hi @paulorodalves setExtension is definitely called before anything. It's in the root, while actual creation is in the React components. I also narrowed down the jspreadsheet version when this started to happen. So when I downgrade to 10.4.1, things work fine. When I upgrade to 10.5.0, it breaks.

More on the behaviour:

• We can reproduce it only on one of our dev's workstations consistently and not anybody else's. Latest Chrome, private mode, no extensions, Windows 10.
• The issue is triggered specifically when we create a formula from @progidev/jss-formulas-statistics like TTEST.TWOSAMPPLE.F.
• We create a sheet with a few numbers, create a formula, save, reload it (so create jspreadsheet with config.worksheet.data set to whatever), and then we see that behavior.
• Exactly same actions with same code done on another workstation work fine consistently.
• If I create a worksheet on my workstation, save reload - it's fine. If that dev with a faulty workstation opens my sheet, it's also fine.

[hodeware]

Since "The issue is triggered specifically when we create a formula from @progidev/jss-formulas-statistics like TTEST.TWOSAMPPLE.F", you will need to contact the third party developer. In this particular instance he needs to upgrade both JSS and Formula Pro. It is probably some version incompatibility or something he need to update on his plugin. He can contact our support directly by email, so we can try to help him.

[hodeware]

If you still need help on this, please contact: support@jspreadsheet.com