Problem with numerical cells

[Vadim]

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

[Vadim]

Forgot to mention, that the value is the result of formula.

[Vadim]

Sorry for the flooding. Got to the answer by employing the FormulaNumberValue property.

[Bhuvaneswari P]

Hi Vadim,

Thanks for the update.

Regards,
Bhuvana