This project has moved. For the latest updates, please go here.

Reading Cell with a Formula

Sep 5, 2012 at 2:21 PM

This is the first time I am using ClosedXml so any help is much appreciated.

I have a range of cells with inbuilt formula's based on a value of specific cell.

But user can override by putting his own currency on any those fields which will in turn disable the formula.

Now when i am trying to read the cell using ValueCached I am not getting any value

but I see in the RichText field the data I entered.

BTW this is a currency cell.(All the other fields which i didnt tamper with are readable but only this one).

Could some one please point me in the right direction.

'improw.Cell(col.ColumnNumber()).Value' threw an exception of type 'System.FormatException'

Coordinator
Sep 5, 2012 at 6:35 PM

Create an issue and attach a file that can be used to reproduce the problem.