Get the actual number value of a formule cell

[Robert]

Hi

Is there a way to get the un rounded .Net double value of a formula cell?

Instead of using the GetResultValueAsString method used in the examples:

 

Workbook workbook = new Workbook(); 
Worksheet worksheet = workbook.Worksheets.Add(); 
worksheet.Cells[0, 0].SetValue("=SUM(A2, 3)"); 
worksheet.Cells[1, 0].SetValue(10); 
ICellValue cellValue = worksheet.Cells[0, 0].GetValue().Value; 
CellValueFormat format = worksheet.Cells[0, 0].GetFormat().Value; 
 
string valueAsString = cellValue.GetValueAsString(format); // =SUM(A2, 3) 
string resultValue = cellValue.GetResultValueAsString(format); // 13 

[Dimitar]

Hi Robert,

You can use the following approach to get the value:

var cellValue = worksheet.Cells[0, 0].GetValue().Value as FormulaCellValue;
var numberValue = cellValue.GetResultValueAsCellValue() as NumberCellValue;
double value = numberValue.Value;
Console.WriteLine(value);

I hope this helps. Should you have any other questions do not hesitate to ask.

Regards,
Dimitar
Progress Telerik