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.

Slope function and blank cells

Thread ID:

Created:

Updated:

Platform:

Replies:

131259 Jul 1,2017 03:25 AM Jul 5,2017 02:46 AM Windows Forms 2
loading
Tags: XlsIO
Louis Nel
Asked On July 1, 2017 03:25 AM

I believe I may have found a bug in the SLOPE function...

For example, using XlsIO I am setting the formula of a cell as follows:

=SLOPE(C2:S2, $C$1:$S$1)

If any of the cells between C2 and S2 are blank, then it results in #N/A.

However the same formula in Excel produces a valid number. It seems that Excel is handling the blank cells, but XlsIO is not.

This is absolutely crucial for me, is there any way around it?

Abirami Varadharajan [Syncfusion]
Replied On July 4, 2017 01:45 AM

Hi Louis, 
 
Thank you for contacting Syncfusion support. 
 

We are able to reproduce the issue. A support incident to track the status of this defect has been created under your account. Please log on to our support website to check for further updates.  

   

https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents   

   

Please let me know if you have any concerns.  

 
Regards, 
Abirami. 


Pon Geetha A J [Syncfusion]
Replied On July 5, 2017 02:46 AM

Updated on 7/5/2017, 12:19 AM by Pon Geetha A J. 
From: Louis Nel  
Sent: Tuesday, July 4, 2017 5:39 AM
To: Syncfusion Support
Subject: Re: Syncfusion support community forum 131259, Slope function and blank cells, has been updated.
 

Thank you, very much appreciated! 


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.

;