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

Free Support Forum - aspose.com

Inserting rows and copying cells does not work for array formulas

The following code and attached CopyDown3.xls will create a corrupted CopyDown3_Result.xls file. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

And the formulas in AF13:AW15 wil be corrupted.

The CopyDown3.xls is created in Excel 2007.

If the formula cells in CopyDown3.xls is edited in Excel 2010 (That is the cells themselves, not only open/save the spreadsheet), the result file will not be corrupted.

========================================

package com.ec.frmw.test.aspose;

import java.io.FileInputStream;

import java.io.IOException;

import com.aspose.cells.Cells;

import com.aspose.cells.CellsHelper;

import com.aspose.cells.License;

import com.aspose.cells.Workbook;

public class CopyDown3 {

public static void main(String[] args) throws IOException, Exception {

License lic = new License();

lic.setLicense(new FileInputStream("lib/Aspose.Cells.lic"));

System.out.println("Aspose version : " + CellsHelper.getVersion());

Workbook workbook = new Workbook("Excel/CopyDown3.xls");

Cells cells = workbook.getWorksheets().get("Sheet1").getCells();

cells.insertRows(14, 15, true);

cells.copyRow(cells, 13, 14);

workbook.calculateFormula();

workbook.save("Excel/CopyDown3_result.xls");

}

}

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue using your code and source file. We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is fixed or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSJAVA-40578.

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


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