We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

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

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

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.

Hi,

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

Thank you

Thank you very much. This works fine.


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.