We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

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.
Live Chat Icon For mobile
Up arrow icon