You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by fa...@apache.org on 2022/11/28 14:14:09 UTC
svn commit: r1905572 - /poi/trunk/poi-ooxml/src/main/java/org/apache/poi/xssf/extractor/XSSFExcelExtractor.java
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: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org