Rank formula showing #VALUE when a non-consecutive ref range is used

Aspose.Cells Product Family
1

Excel seems to handle a non-consecutive cell ref in the RANK formula as expected. However, Aspose shows a #VALUE error after the formulas are calculated. Please see the attached sample for a demonstration of the issue.

AsposeRankFormula.zip (81.2 KB)

2

@mhopkins
By testing with sample files and code we can reproduce the issue. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-57736

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

@mhopkins

We are pleased to inform you that the issue of calculating RANK function(Ticket ID: “CELLSNET-57736”) has been resolved. The fix will be included in our upcoming release (Aspose.Cells v25.2) that we plan to release in the first half of February 2025. You will be notified when the next version is released.

4

Thanks for fixing this so quickly. Appreciate it.

5

@mhopkins,

You are welcome. We will keep you posted with updates on new version once available.

6

The issues you have found earlier (filed as CELLSNET-57736) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi