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