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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Slope function and blank cells

Thread ID:





131259 Jul 1,2017 07:25 AM UTC Jul 5,2017 06:46 AM UTC WinForms 2
Tags: XlsIO
Louis Nel
Asked On July 1, 2017 07:25 AM UTC

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 05:45 AM UTC

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.  




Please let me know if you have any concerns.  


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

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! 


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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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