Skip to main content

Calculation engine - Community / GemBox.Spreadsheet Feature Request - GemBox Support Center

Request for adding a calculation engine.

 

GemBox.Spreadsheet can read the last calculated values from the input file and we can retrieve this value from the cell's Value property. But it cannot calculate formula results on its own and when we provide a formula to a cell, it will automatically set its value to default. In other words, when we set a Formula property of an ExcelCell object, the GemBox.Spreadsheet will set this cell's value to 0.

See Formula property remarks:

https://www.gemboxsoftware.com/spreadsheet/help/html/P_GemBox_Spreadsheet_CellRange_Formula.htm

Comments (2)

Gianni
This is a great problem when i convert an Excel file in PDF.
Many Excel files containing formulas and not recalculate them means they can not export files in PDF!
Mario - GemBox
Hi,

This feature request has been implemented and is available in latest versions of GemBox.Spreadsheet.


Regards,

Mario
GemBox d.o.o.