Function getFormula() returns wrong value if several sheets contain the same names

Aspose.Cells Product Family
1

Hello,

I'm using Aspose.Cells for Java 2.2.1

The function cell. getFormula() has problem with the same names in several sheets.

I have two sheets "Sheet 1" and "Sheet 2". The both have the same name "Name2". Sheet 1 contains the following formula: =SUM (Name1;'Sheet 2'!Name2).

Function getFormula() returns: "=SUM(Name1,'Sheet 1'!Name2)". Probably function only searches by name and not by sheet name.


Code:

workbook.open("Template.xls");

Worksheets worksheets = workbook.getWorksheets();

Worksheet sheet = worksheets.getSheet("Sheet 1");

System.out.println("formula : " + sheet.getCells().getCell(4, 0).getFormula());

Output:

formula : =SUM(Name1,'Sheet 1'!Name2)

<span style=“font-size: 10pt; font-family: “Tahoma”,“sans-serif”;” lang=“EN-US”><o:p> </o:p>

Thanks,

<span style=“font-size: 10pt; line-height: 115%; font-family: “Tahoma”,“sans-serif”;” lang=“EN-US”>Inna

2

Hi Inna,

I can find the issue using your template file and code.

We will figure out your issue soon.

I have logged your issue into our issue tracking system with an issue id: CELLSJAVA-17174.
Once it is sorted out, we will update you.

Thank you.

3

Hi,

Please try the attached version. We have fixed your mentioned issue.

Thank you

4

Thank you very much. This works fine.


5

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.