Can calculateFormula do this?


#1

Hi All,

I’m reviewing this product to see if it will meet our needs. Basically, I need to access a spreadsheet using a .NET web form, I need to insert some values to a few cells and then tell the spreadsheet to re-calculate and pull out some values.

It looks like this is possible with the excel.calculateFormula function.

I just read something in the documentation that says only certain operators and functions are available. Does this mean that the pre-existing formulas (i.e. - those in the spreadsheet before I open it) will only re-calculate if they are in the set of functions and operators supported by .CalculateFormula?

If the spreadsheet is using VBA to calculate some values (when the workbook is open in Excel, for instance), is there any way for aspose.excel to trigger that same VBA functionality and produce the same values?

Thanks in advance!

Chris


#2

Hi Chris,

1.Does this mean that the pre-existing formulas (i.e. - those in the spreadsheet before I open it) will only re-calculate if they are in the set of functions and operators supported by .CalculateFormula?

Yes. We are working to enhance the set of functions to extend the list.

2. If the spreadsheet is using VBA to calculate some values (when the workbook is open in Excel, for instance), is there any way for aspose.excel to trigger that same VBA functionality and produce the same values?

No. Aspose.Excel can only load and save VBA in Excel files. It cannot trigger those VBA.