XlsIo tends to add a space to the value of some numberical cells. For example, instead of "15,67" it puts "15,67 ". Therefore it refuses to identify it as a number and returns NaN if any attempts of accessing the Number property of IRange.
Is it normal? ;)
Thanks
VA
Vadim
April 22, 2008 05:01 PM UTC
Forgot to mention, that the value is the result of formula.
VA
Vadim
April 22, 2008 07:24 PM UTC
Sorry for the flooding. Got to the answer by employing the FormulaNumberValue property.
BP
Bhuvaneswari P
Syncfusion Team
April 23, 2008 05:47 AM UTC
Hi Vadim,
Thanks for the update.
Regards,
Bhuvana