I’d like to know if it is possible to create a Excel workbook from a template that has charts and formulas.
I’ll fill the tables of this template and then generate a PDF of it.
As there was no Excel involved, I’d like to know if Aspose will update the formulas and charts.
I read that its engine can update Word fields, but what about Excel formulas and charts?
Thanks
Thanks for considering Aspose.Cells.
Once, you have added or updated all the cells data that is relating to your formulas, then you will have to calculate the workbook using Workbook.CalculateFormula() method.
Charts will also be updated if you will change the data inside the chart range. For example, your chart range is like A1:A20, so if you will change data inside this range like you change the cell value of cell A4, then charts will also be updated automatically.
Wow, that’s unbelievable. You guys managed to build and independent formula engine.
I’d like to know the limitations: is there a link? Did you implement all Excel formulas? Can they use named dynamic named ranges =SUM((OFFSET(Sheet1!A1,0,0,COUNT(Sheet1!A:A))) to perform calculation? What about the INDIRECT formula?
Thanks!
Yes, Aspose.Cells has its own and independent formula calculation engine that can evaluate and calculate formulas/functions in the spreadsheet. Aspose.Cells mostly supports MS Excel (97-2013) built-in formulas/functions. See the document here to know what formulas are supported (your desired formulas are already mentioned there):
https://docs.aspose.com/display/cellsnet/Supported+Formula+Functions
(The list might not be final as we enhance/support more and more formulas with every release of the product).
Moreover, if a formula can be calculated fine when using it in MS Excel manually, Aspose.Cells will equally calculate it fine same as MS Excel.
Let us know if we can be of any further help.
Thank you.