https://bz.apache.org/bugzilla/show_bug.cgi?id=65241
--- Comment #8 from Thad Welch <[email protected]> --- run test case public static void main(String[] args) { try { File excleFile = new File( "C:\\Users\\twelch\\eclipse-workspace\\Main\\test_excel\\test_slope_intercept_rsquare.xlsx"); InputStream is = new FileInputStream(excleFile); XSSFWorkbook workbook = new XSSFWorkbook(is); is.close(); // Excel formulas : D2 slope, D3 intercept, D4 RSquare // evaluate and save results in F2, F3 XSSFCell slopeCell = cellAtAddr(workbook, "Sheet1!D2"); XSSFCell interceptCell = cellAtAddr(workbook, "Sheet1!D3"); XSSFCell rSquareCell = cellAtAddr(workbook, "Sheet1!D4"); evalCellSaveAtAddr(workbook, slopeCell, "Sheet1!F2"); evalCellSaveAtAddr(workbook, interceptCell, "Sheet1!F3"); evalCellSaveAtAddr(workbook, rSquareCell, "Sheet1!F4"); workbook.setForceFormulaRecalculation(true); FileOutputStream os = new FileOutputStream(excleFile); workbook.write(os); os.close(); } catch (Exception e) { e.printStackTrace(); } } -- 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]
