One thing we have noticed in our trial version testing. While reading excel worksheet as dataset if the worksheet has columns with formula then EasyXLS brings back #VALUE! into dataset.

I can see correct values appearing in the formula columns but still EasyXLS through “Error processing formula: any formula text, Unable to cast object of type System.String to type EasyXLS.Formulas.Util.FunctionDataObject”

This error occurs when following lines of code executes:



Please advice why do we get #VALUE !even though we have correct formula value e.g. value 12 appearing in the formula column.


Cheers
Bhavesh

Hi
I also have the same problem
I found that if one of the cell value is a number with some space character,it will return that error.
for example:
A1 = A2+A3+A4
if A3's real value is " 123"
when I ReadExcelWorksheet_AsDataSet
the A1 cell will be #VALUE !
but in Office2003 ,the A1 can still do the calculation correctly
it's not easy to find out.
I hope EasyXLS can fix this quickly