Address calculation problem

Aspose.Cells Product Family
1

I am having a problem with the address function in the Cells.GridDesktop product.

My grid uses address functions that contain calculations to determine the cell address. In the Aspose grid I am getting the error "#NAME?". I tried a basic address calculation "=address(5 - 1, 2)" and received the error.

The address function is working as long as there is not a calculation for the row or column. Can this be updated to allow calculations for the row and column values? I need to be able to use formulas such as "=address(row()-2, column()+3)".

2

Hi Curt,

Thanks for your posting and using Aspose.Cells for GridDesktop.

We were able to observe this issue. =ADDRESS(5 - 1, 2) results in “#NAME?” however =ADDRESS(5, 2) works fine and results $B$5. We have logged this issue in our database. We will look into it and resolve this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-42056.


3

The issues you have found earlier (filed as CELLSNET-42056) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.