Free Support Forum - aspose.com

Macro4 and userdefined functions

#1

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

#2

@tbjeanie,

Thanks for sharing some details.

Aspose.Cells does not support to execute/run vba codes or macro functions although we have supported to create, manipulate or embed VBA codes/ macros in MS Excel files. I think currently, you may try to use/set Custom Functions (if in those macros you manipulate some custom oriented formulas/functions) to support your requirements by Aspose.Cells APIs if it could suit your needs, see the documents for your reference here:
https://docs.aspose.com/display/cellsnet/using+icustomfunction+feature
https://docs.aspose.com/display/cellsnet/Implement+Custom+Calculation+Engine+to+extend+the+Default+Calculation+Engine+of+Aspose.Cells

If you still find any issue, kindly do provide us sample code (runnable) and attach your template file(s) to show the issue, we will check it soon.