Slope function and blank cells

[Louis Nel]

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]

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.