A custom function does not recalculate in Excel Online if the "at" (@) symbol has been used with the IF function #4398
Labels
Area: Excel
Issue related to Excel add-ins
Needs: attention 👋
Waiting on Microsoft to provide feedback
Provide required information needed to triage your issue
Your Environment
Expected behavior
All functions recalculate
Current behavior
In Velixo sometimes we have to recalculate programmatically the sheet to make all values actual.
Custom function, for example
=@IF($B27 = ""; "";SI.WRITEBACKBUDGET($C$5;$F$12;$F$13;FALSE;$H$12:$I$13;$B27;;$D$6:$E$7;;$I$4:$T$4;$I27:$T27))
does not recalculate when we call
context.workbook.worksheets.getActiveWorksheet().calculate(true);
.It means Excel even does not start to execute the function. If we remove the @ before IF, functions become recalculating.
Steps to reproduce
Link to live example(s)
Provide additional details
I figured out that for the bug reproduction, the sheet has to contain spill range functions and in the buggy formula we have to use range references that contain IF in their formulas.
Context
In large sheets with complicated tables, it's important to use "@" and also have the ability to recalculate a sheet before, for example, uploading data to an external database.
Useful logs
The text was updated successfully, but these errors were encountered: