This project has moved and is read-only. For the latest updates, please go here.

Reading Cell with a Formula

Sep 5, 2012 at 3: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'

Sep 5, 2012 at 7:35 PM

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