https://bz.apache.org/bugzilla/show_bug.cgi?id=55747
Andrew <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from Andrew <[email protected]> --- Have same problem with MID and REPLACE funciton (maybe all text)? public static void main(String[] args) throws IOException { Workbook wb = new HSSFWorkbook(); FormulaEvaluator ev = wb.getCreationHelper().createFormulaEvaluator(); Sheet ws = wb.createSheet(); Row row = ws.createRow(0); Cell cell; cell = row.createCell(0); cell.setCellValue("abc"); cell = row.createCell(1); cell.setCellFormula("IF(A1<>\"\",MID(A1,1,2),\" \")"); ev.evaluateAll(); OutputStream os = new FileOutputStream("xx.xls"); wb.write(os); } Some analysis shows, that problem occurs on Windows using 2003 or 2010 excel (cannot test 2007 or 2013) but does not occurs on mac with 2013 excel or windows with open office 4.1.1. Problem found in POI 3.8, 3.10, 3.12, 3.13dev and is not produced for XSSFWorkbook. -- 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]
