diff options
| -rw-r--r-- | poi-ooxml/src/main/java/org/apache/poi/xssf/extractor/XSSFExportToXml.java | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/poi-ooxml/src/main/java/org/apache/poi/xssf/extractor/XSSFExportToXml.java b/poi-ooxml/src/main/java/org/apache/poi/xssf/extractor/XSSFExportToXml.java index c6afb66558..f893c8b61a 100644 --- a/poi-ooxml/src/main/java/org/apache/poi/xssf/extractor/XSSFExportToXml.java +++ b/poi-ooxml/src/main/java/org/apache/poi/xssf/extractor/XSSFExportToXml.java @@ -277,7 +277,11 @@ public class XSSFExportToXml implements Comparator<String>{ case FORMULA: if (cell.getCachedFormulaResultType() == CellType.STRING) { value = cell.getStringCellValue(); - } else { + } else if (cell.getCachedFormulaResultType() == CellType.BOOLEAN) { + value += cell.getBooleanCellValue(); + } else if (cell.getCachedFormulaResultType() == CellType.ERROR) { + value = cell.getErrorCellString(); + } else if (cell.getCachedFormulaResultType() == CellType.NUMERIC) { if (DateUtil.isCellDateFormatted(cell)) { value = getFormattedDate(cell); } else { |