Problem with numerical cells

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


3 Replies

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


Loader.
Up arrow icon