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'