Build 3.0.0.83 introduces more consistency when retrieving cell values.

Beginning with this build, whenever a cell is governed by a formula, and the value of the cell is being retrieved, xlsgen will automatically compute the formula before giving the value of the cell if the formula has not been calculated yet, therefore avoiding to return a dummy value, and avoiding that the client application makes an explicit CalculateFormula(row, col) before retrieving the value in the cell.

Alternatively, a client application may use the new IsFormulaCalculated(row, col) property exposed at the worksheet level in order to know beforehand if the formula stored in a cell is already calculated or not.

Therefore, if you write a formula such as,

worksheet.Formula[1][1] = "=5+3";

you can obtain the resulting value by a simple :

int n = worksheet.Number[1][1]; // returns 8