Author: fanningpj
Date: Mon Nov 28 14:14:09 2022
New Revision: 1905572
URL: http://svn.apache.org/viewvc?rev=1905572&view=rev
Log:
[bug-66365] update XSSFExcelExtractor to better handle formula cells with
cached results of string type
Modified:
poi/trunk/poi-ooxml/src/main/java/org/apache/poi/xssf/extractor/XSSFExcelExtractor.java
Modified:
poi/trunk/poi-ooxml/src/main/java/org/apache/poi/xssf/extractor/XSSFExcelExtractor.java
URL:
http://svn.apache.org/viewvc/poi/trunk/poi-ooxml/src/main/java/org/apache/poi/xssf/extractor/XSSFExcelExtractor.java?rev=1905572&r1=1905571&r2=1905572&view=diff
==============================================================================
---
poi/trunk/poi-ooxml/src/main/java/org/apache/poi/xssf/extractor/XSSFExcelExtractor.java
(original)
+++
poi/trunk/poi-ooxml/src/main/java/org/apache/poi/xssf/extractor/XSSFExcelExtractor.java
Mon Nov 28 14:14:09 2022
@@ -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) {
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
