diff options
| author | PJ Fanning <fanningpj@apache.org> | 2022-11-28 14:14:09 +0000 |
|---|---|---|
| committer | PJ Fanning <fanningpj@apache.org> | 2022-11-28 14:14:09 +0000 |
| commit | c8f4cbd20b3d2670274a4d035a729c7fadf75837 (patch) | |
| tree | 744ead08a332a31943c6d8250bbd39992f3efcc7 | |
| parent | efc032babcad23fd84fc0ffce0560c86771a486f (diff) | |
| download | poi-c8f4cbd20b3d2670274a4d035a729c7fadf75837.tar.gz poi-c8f4cbd20b3d2670274a4d035a729c7fadf75837.zip | |
[bug-66365] update XSSFExcelExtractor to better handle formula cells with cached results of string type
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1905572 13f79535-47bb-0310-9956-ffa450edef68
| -rw-r--r-- | poi-ooxml/src/main/java/org/apache/poi/xssf/extractor/XSSFExcelExtractor.java | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/poi-ooxml/src/main/java/org/apache/poi/xssf/extractor/XSSFExcelExtractor.java b/poi-ooxml/src/main/java/org/apache/poi/xssf/extractor/XSSFExcelExtractor.java index a8bc2ca678..5524ded59b 100644 --- a/poi-ooxml/src/main/java/org/apache/poi/xssf/extractor/XSSFExcelExtractor.java +++ b/poi-ooxml/src/main/java/org/apache/poi/xssf/extractor/XSSFExcelExtractor.java @@ -224,6 +224,10 @@ public class XSSFExcelExtractor CellType type = cell.getCellType(); if (type == CellType.FORMULA) { type = cell.getCachedFormulaResultType(); + if (type == CellType.STRING) { + handleStringCell(text, cell); + return; + } } if (type == CellType.NUMERIC) { |