I have a formula in the cell, for example: =10 + 1 But when I set a new cell value like: cell.setCellValue("foo") POI doesn't remove the formula from the cell and cell type is still CellType.FORMULA. When I open the file in the Excel, cell value hasn't been changed. Previosly I used Cell#setCellType(CellType) before updating cell value and it was working. But now, Cell#setCellType(CellType) is deprecated and I don't get the desired result by just using Cell#setCellValue(...). Is it a bug? If so, could you fix it?
This is likely the same as bug #63845, please try with a recent nightly build and reopen this bug with more information if the problem still happens with that version. *** This bug has been marked as a duplicate of bug 63845 ***