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.
Unfortunately, activation email could not send to your email. Please try again.

Problem with numerical cells

Thread ID:

Created:

Updated:

Platform:

Replies:

73151 Apr 22,2008 12:54 PM Apr 23,2008 01:47 AM Windows Forms 3
loading
Tags: XlsIO
Vadim
Asked On April 22, 2008 12:54 PM

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 01:01 PM

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


Vadim
Replied On April 22, 2008 03:24 PM

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


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

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.

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.

;