#VALUE! showed in copied cells

Hi,

Cell’s formula return #VALUE! after copied from others. Any idea?


Workbook workbook = new Workbook();

workbook.open("C:\\Excels\\book1.xls");

Worksheet sheet = book.getWorksheets().getSheet("Sheet4");

sheet.calculateFormula(true, true);

Cells cell = sheet.getCells();

cell.copyCellRange(cell, 6, 1, 12, 1, 1, 4);

workbook.save("C:\\Excels\\book2.xls");
---------------------------------------------------------------------------------------------------------------------------

Cell formula : =SUMPRODUCT(((Sheet5!$B$6:$B$11)=Sheet4!B12)*1,((Sheet5!$C$6:$C$11)="2A")*1)

Fyi, i’m using Aspose version v2.1.0.14.

Here i attached the 2 sample files(before and after). Thanks.

Regards.

Hi,

Thanks for your sample code and template files.

We found the issue after an initial test, we will figure it out soon.

Thank you.

Hi,

Thank you for considering Aspose.

Please try the attached latest fix of Aspose.Cells for Java. We have fixed your mentioned issue.

Thank You & Best Regards,

Hi,

It's working fine now. Thanks.

Regards.