https://bz.apache.org/bugzilla/show_bug.cgi?id=57861
--- Comment #4 from [email protected] --- The use case is a basic xlsx file with two sheets, one for data the other for a graph. This xlsx file is used as a template, so everytime the app is asked to generate a new graph it reads the template, sets cell values and evaluates formula cells in order to generate the graph. Finally, the data sheet is hid and the graph sheet selected as active and thus the app is able to send it to printer and only get the generated graph. In the data sheet, we have a final column with formulae that sometimes we want to override with database-generated values and that's why we need to clear the formulae. Those values or formulae are being used in the graph sheet and there is where we're experiencing this bug. If we remove the graph sheet, Excel doesn't have the unreadable content problem otherwise has. Code used: XSSFCell cell; [...] cell.setCellFormula(null); cell.setCellValue(value); [...] XSSFFormulaEvaluator.evaluateAllFormulaCells(workbook); workbook.setSheetHidden(workbook.getSheetIndex(dataSheet), true); workbook.setActiveSheet(workbook.getSheetIndex(graphSheet)); -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
