Cell cell; cell.setCellValue(true); DataFormatter formatter = new DataFormatter(); assertEquals("TRUE", formatter.formatCellValue(cell, null)); For HSSFWorkbook: Expected "TRUE", got "true".
Created attachment 34165 [details] Unit test and DataFormatter fix From https://mail-archives.apache.org/mod_mbox/poi-user/201608.mbox/%3CCAM%2BTppKh7NJap883d%2BoWAY0SNXJL-WGO9OStEGXoRqVxSgJ%2BEQ%40mail.gmail.com%3E Attached unit test and fix to DataFormatter. Waiting for trunk to be unfrozen before committing.
Applied in r1760219. This will likely be included in POI 3.15 final.