Hi,
Still evaluating Aspose.cells
First Problem:
German Excel -> You define a Name lets say “Calc” and assign:
=AUSWERTEN(Tabelle1!$F$2)
AUSWERTEN is EVALUATE in english.
in Excel Table Tabelle1 you asign 1+1 to F2 and in G2 = Calc the result is 2 in G2
Now Aspose.cells reads the Workbook, Change F2 to 1+1+1
After doing a Workbook.CalculateFormula the Value in G2 is #NAME?
Second Problem is similar:
Using userdefined Funktions will result in the same #Name Problem.
My question:
Are Macro4 Functions a Problem for Aspose.cells
Are Userdefinde Functions a Problem for Aspose.cells
Regards