Skip to main content linkedinfacebooktwittermenuarrow-up
59

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/docs/GemBox.Spreadsheet.ExcelCell.html#GemBox_Spreadsheet_ExcelCell_Formula

Official response

Mario at GemBox

Hi,

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

Regards,
Mario

Comment (1)

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!