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

Slope function and blank cells

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?

2 Replies

AV Abirami Varadharajan Syncfusion Team 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.  


PG Pon Geetha A J Syncfusion Team 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! 

To post a reply.
Live Chat Icon For mobile
Up arrow icon