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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Problem with numerical cells

Thread ID:

Created:

Updated:

Platform:

Replies:

73151 Apr 22,2008 04:54 PM UTC Apr 23,2008 05:47 AM UTC WinForms 3
loading
Tags: XlsIO
Vadim
Asked On April 22, 2008 04:54 PM UTC

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
Replied On April 22, 2008 05:01 PM UTC

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


Vadim
Replied On April 22, 2008 07:24 PM UTC

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


Bhuvaneswari P [Syncfusion]
Replied On April 23, 2008 05:47 AM UTC

Hi Vadim,

Thanks for the update.

Regards,
Bhuvana


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;