I'd like to use the Spire Free Java Package to convert an excel sheet to pdf.
The Problem is, that a cell with the content "=SUM(K5+K7+K9+K11)" does contain a wrong value in the exported file.
My Java code is as follows:
- Code: Select all
Workbook workbook = new Workbook();
workbook.loadFromFile(fileName);
Worksheet sheet = null;
if(type == SheetType.DRIV) sheet = workbook.getWorksheets().get("Spesenblatt DRIV");
if(type == SheetType.RIV_NRW) sheet = workbook.getWorksheets().get("Spesenblatt RIV NRW");
sheet.saveToPdf("file.pdf");
The expected value for the cell with sample data is 62 the actual value in the exported file is 620.
I guess its a bug where the actual value is added in front of the initial cell value of 0 but I dont know how to fix this.