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

Free Support Forum - aspose.com

Problem with excel tables (listobject)- array formulas and auto fill

Hi,


We have an issue with aspose.cells for java version 8.6.2 and excel tables.
When the table contains an array formula, the autofill feature re-produces the formula as a ‘normal’ formula instead of keeping the array characteristic.

I have attached a small class and excel file that demonstrates the issue.
We currently have to post-process the filled in tables to reset the array formulas as a workaround. I hope this can be resolved in the library soon, so we can drop the workaround.

regards,
Wouter

Hi Wouter,

Thanks for demonstrating the issue with your sample code and sample excel file and using Aspose.Cells.

We were able to replicate this issue and logged it our database for a fix. We will look into it and resolve this issue. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSJAVA-41634 - Autofill feature re-produces the formula as a ‘normal’ formula instead of keeping the array characteristic

The code also causes the following exception.

Exception:
Exception in thread “main” java.lang.RuntimeException: array characteristic of column formula lost after insert rows
at clsAsposeCells.f1(clsAsposeCells.java:44)
at clsAsposeCells.main(clsAsposeCells.java:11)

Hi,

This is to inform you that we have fixed your issue “CELLSJAVA-41634” now. We will soon provide the fix after performing QA and including other enhancements and fixes.


Thank you.

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


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