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

Free Support Forum - aspose.com

Dynamic formula use {-1} {-2} return Invalid formula error

I use aspose.cells for .net to develop a .net application,but when I want to use aspose.cells for java to convert the code to java ,I meet an error ,

when I use dynamic formula to get offset to current row ,it has follow error:

com.aspose.cells.CellsException: Error in Cell: A5-Invalid formula:"=sum(A1:A{-1})".
when i use the formular "&=&=sum(A1:A{-1} )"

but the same formular process ok in aspose.cell for .net.and I found java help document means to suport the format of the dynamic formula.


try {
WorkbookDesigner designer = new WorkbookDesigner();
designer.setWorkbook(new Workbook(“E:\TEST\dynamictest.xlsx”));
designer.setDataSource(“AAA”, “ABCDEF”);
designer.process();
designer.getWorkbook().save(“E:\TEST\dynamictest_OUT.xlsx”,SaveFormat.XLSX);
}
catch (Exception e) {
e.printStackTrace();
}

I want to know what what’s wrong with my code.
my version of cells is 8.9.2





Hi Kui,


Thank you for contacting Aspose support.

I have managed to reproduce the said problem while using Aspose.Cells for Java 8.9.2.7 whereas same test against .NET API passes. I have logged an investigative ticket with Id CELLSJAVA-41984 for product team’s review. Please spare us little time to properly analyze the scenario and revert back with updates in this regard.

We are sorry for the inconvenience caused to you.

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


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