CalculateFormula support + licence "upgrade"

Aspose.Cells Product Family
1

Hi,

I would like to know if CalculateFormula routine makes me able to retrieve the result value of cells containing MID and FIND formulas for an existing Excel file.
If not, is it possible for you to add them to the set of existing formulas?

Also, I would like to know if it is possible to “upgrade” an existing licence from Professional to Enterprise by paying only the difference.

Thanks

Luigi



2

Hi Luigi,

Now MID and FIND functions are not supported. We will add them in the future release.

About upgrade policy, please check

3

Hello Laurence,

just to know if you planned a date for the future release.

Thank you for the excellent support.

Luigi

4

Hi Luigi,

You are welcome.

It will be available before the end of next month. Now we are adding many new functions to the calculation engine.

5

Hello,

I have an Excel file produced with Aspose.Excel that contains some formulas.
If I try to read the cells containing formulas through Aspose.Excel library (Professional Edition, no .calculateFormula() routine…), I cannot get the results of the formula.

On the other hand, if I open the file with Microsoft Excel application and then save it, I am eventually able to read the values through Aspose.Excel library, as if Microsoft Excel application calculates formulas when requested to save.

I need to know if my understading is correct.

Thank you for help

Luigi



6

Hi Luigi,

Your understanding is correct. While saving file in MS Excel, Excel will calculate formulas and save the result to file. Aspose.Excel can read those values.

However, if you use Aspose.Excel to set formula to an Excel file, it won’t calculate the result. So you cannot get those result in Professional edition.

7

@luigi_salvini,

We recommend you to upgrade to latest Aspose.Cells version as Aspose.Cells (Aspose.Excel was obsoleted sometimes ago) now provides robust formula calculation engine. It makes it quite easier to perform complex calculations on the data effectively and efficiently. Aspose.Cells’ Formula Calculation Engine allows you to set, read and calculate the results of your desired formulas and functions at runtime. You can either download or install the API here. See the documents in the section on managing formulas in the spreadsheets for your complete reference.

See the ready to use examples for your reference