Evaluate a formula

Dear sir,

I have a cell with a formula like this :

=A1+A15+A22

I need to read the value not the formula to made other calculate.
How can I do ?
I have tried with cell.FormulaNumberValue,cella.DisplayText...but nothing to do.

Thanks.

1 Reply

AJ Ajish Syncfusion Team July 5, 2007 10:12 PM UTC

Hi,

Thank you for your interest in Essential XlsIO.

Use the following code to read computed Formula Value.

sheet.Range["C1"].FormulaNumberValue

Here is a sample for your reference

Sample: http://websamples.syncfusion.com/samples/XlsIO.Windows/F63587/main.htm

Kindly take a look and let us know if this helps.

Regards,
Ajish.

Loader.
Up arrow icon