GetPrecedents Behavior change

We were using Aspose.Cells ( 22.4 ) and reported a bug regarding Object Ref exception which was fixed in 22.6. The problem is with new package, the behavior of Cell.GetPrecedents() is changed. For a formula like =IF(ISBLANK(@INDEX(A1,0,COLUMN())),0,IF(OR(B2=D2,B2=C2),“CHECK”,0))
we expected to get 4 precedents as it’s showed in Excel too ( A1, B2, D2, C2), but now we get 1 which is Referring to A1 !


My Code and Test Workbook are attached (624 Bytes)

test.7z (6.3 KB)


Thank your for reporting the issue with details. We have reproduced it with the provided resources and created one ticket for it(CELLSNET-51297). We will look into it and try to fix it soon.


This is to inform you that your issue has been resolved. The fix will be included in the next release (Aspose.Cells for .NET v22.7) which is scheduled in the second week of July 2022. You will also be notified when the next version is released.

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

1 Like