Posted 26 May 2019, 9:26 pm EST
Hi,
I’m having a problem loading custom functions in the spread since the migration from version 10 to version 12.
Our custom Formulas are no longer recognized when opening files in the spread. The formulas must be modified to be considered. Before that recalculations always returns the value “#Name?” indicating that the entered formula is not recognized.
You will see that in the attached project, cells C4 and C5 referencing the formula FORM_AC are not recognized at the opening.
You have to change the formula so that they are.
Scenario:
Change the Formula of cell C5 to “FORMAC()”, then change back to FORM_AC(), the formula is then recognized.
With Version 10 of Spread
With version 10 of Spread, we did not have this concern and the formulas were well recognized during the first recalculation following the opening of the file without any modification on the cells are necessary.
I tried to program a formula overload of each cell referencing a custom formula but this has no effect. The modification must be done by the user interface for the formula to be recognized.
I noticed the same problem with the namespace function Grapecity (preferred since version 11.40)
I do not know how fixed this problem that will force me to stay in version 10 …
So I hope you can help me.
Thanks in advance.
Best regards.