+++ This bug was initially created as a clone of Bug #47747 +++ since nobody in the community will respond to my comments in bug 47747, perhaps a new bug entry will warrant a reply? Created an attachment (id=24176) This zip contains the original and processed spreadsheets. I have tried version 3.5, 3.6 and 3.7. When trying to run the following code to go through a spreadsheet and update the formula values, I get several errors (java.lang.RuntimeException: Shared Formula Conversion: Coding Error). When I open the newly created spreadsheet, several cells have #REF issues. I will attach the original and processed spreadsheets. public static void RecalculateFormulas(String filename) throws FileNotFoundException, IOException { try{ FileInputStream fis = new FileInputStream(filename); FileOutputStream out = new FileOutputStream(filename.replaceAll(".xls","temp.xls")); HSSFWorkbook wb = new HSSFWorkbook(fis); //or new XSSFWorkbook("/somepath/test.xls") FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator(); for(int sheetNum = 0; sheetNum < wb.getNumberOfSheets(); sheetNum++) { org.apache.poi.ss.usermodel.Sheet sheet = wb.getSheetAt(sheetNum); for(org.apache.poi.ss.usermodel.Row r : sheet) { for(org.apache.poi.ss.usermodel.Cell c : r) { if(c.getCellType() == org.apache.poi.ss.usermodel.Cell.CELL_TYPE_FORMULA) { try{evaluator.evaluateFormulaCell(c);} catch(Exception e) {System.out.println(e.toString());} } } } } wb.write(out); out.close(); } catch(Exception e) {System.out.println(e.toString()); } }
I don't think you will help your cause by duplicating an issue. The original issue and offered patch was less than three weeks ago. You might have noticed if you are subscribed to the dev list that core developers are applying patches in the last week. I think you would do better by asking a question as an email on the dev list. Regards, Dave *** This bug has been marked as a duplicate of bug 47747 ***