The following code and attached CopyDown3.xls will create a corrupted CopyDown3_Result.xls file.
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");
}
}