Incorrect lookup of cells in case of named row

Aspose.Cells Product Family
1

Hello,

Problem with lookup of cells in named row when they it is accessed via fully qualified name (with worksheet prefix in case of worksheet scope or workbook prefix in case of workbook scope). Second row in the attached xls has values 2,5 in all cells after calculation.

InputStream inStream = new FileInputStream(“E:\Test_namedrow.xls”);
Workbook workbook = new Workbook(inStream);
inStream.close();

workbook.calculateFormula();

OutputStream outStream = new FileOutputStream(“E:\Test_namedrow_out.xls”);
workbook.getSettings().setCalcMode(CalcModeType.MANUAL);
workbook.save(outStream, FileFormatType.EXCEL_97_TO_2003);
outStream.flush();
outStream.close();

Best regards, Evgeniy

2

Hi,

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

I have tested your file with your code using the latest version:
Aspose.Cells
for Java v7.2.2.4
and found the issue does exist.

We have logged this issue in our database. We will look into this issue and once the problem is fixed or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSJAVA-40242.

Please see the output xls file generated by the following code.

I have also attached the screenshot for your reference.

Java


String filePath = “F:\Shak-Data-RW\Downloads\Test_namedrow.xls”;


FileInputStream inStream = new FileInputStream(filePath);

Workbook workbook = new Workbook(inStream);

inStream.close();


workbook.calculateFormula();


FileOutputStream outStream = new FileOutputStream(filePath + “.out.xls”);

workbook.getSettings().setCalcMode(CalcModeType.MANUAL);

workbook.save(outStream, FileFormatType.EXCEL_97_TO_2003);

outStream.flush();

outStream.close();



Screenshot:
3

Hi,

We have fixed the issue of formula calculations.

Please download and try this fix: Aspose.Cells for Java v7.2.2.6

4

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

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