Hi,
I applied the formula =C21+D21 in E21 .
Both getEndCol() and getEndRow() on the referred area(C21) returns 0 .
But getStartCol() and getStartRow() works fine returning 2 and 20 respectively.
Can you explain me the above case ?
Hi,
I applied the formula =C21+D21 in E21 .
Both getEndCol() and getEndRow() on the referred area(C21) returns 0 .
But getStartCol() and getStartRow() works fine returning 2 and 20 respectively.
Can you explain me the above case ?
Hi,
Thanks for your posting and using Aspose.Cells.
Please explain your issue in more detail. Also let us know which version of Aspose.Cells you are using. Please illustrate your issue with some sample code and sample excel file.
We will look into your issue and help you asap. Thanks for your cooperation.
Hi,
Thanks for your posting and using Aspose.Cells.
We were able to observe this issue and found ReferredArea.getEndRow() and ReferredArea.getEndColumn() returns 0 and does not match the expected output as you have given it. However, the same thing works fine with the cell G4 inside the Table in second sheet.
We have logged this issue in our database for investigation. We will look into it and fix 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
Thanks for the reply. I am looking forward for the issue fix.
Hi,
Thanks for your posting and using Aspose.Cells
Hopefully, your issue will be fixed in a week or two. Once, the fix is available for you or we have some other update for you, we will let you know asap.
Hi,
Thanks for using Aspose.Cells.
We have looked into this issue further and found that it is a correct output. If ReferredArea.isArea() is false, EndColumn and EndRow are useless.