(nifi) branch support/nifi-1.x updated: NIFI-13418 Updated ExcelReader to handle spreadsheets with shared formulas

[exceptionfactory]

This is an automated email from the ASF dual-hosted git repository.

exceptionfactory pushed a commit to branch support/nifi-1.x
in repository https://gitbox.apache.org/repos/asf/nifi.git


The following commit(s) were added to refs/heads/support/nifi-1.x by this push:
     new 3bdf32dd14 NIFI-13418 Updated ExcelReader to handle spreadsheets with 
shared formulas
3bdf32dd14 is described below

commit 3bdf32dd1405e68f5406582e338932a2db132368
Author: dan-s1 <dsti...@gmail.com>
AuthorDate: Mon Jul 8 18:48:36 2024 +0000

    NIFI-13418 Updated ExcelReader to handle spreadsheets with shared formulas
    
    This closes #9063
    
    Signed-off-by: David Handermann <exceptionfact...@apache.org>
    (cherry picked from commit 90c58a88a702db2b418e2bf6ebe7eb422a3c3b51)
---
 .../src/main/java/org/apache/nifi/excel/RowIterator.java                 | 1 +
 1 file changed, 1 insertion(+)

diff --git 
a/nifi-nar-bundles/nifi-poi-bundle/nifi-poi-services/src/main/java/org/apache/nifi/excel/RowIterator.java
 
b/nifi-nar-bundles/nifi-poi-bundle/nifi-poi-services/src/main/java/org/apache/nifi/excel/RowIterator.java
index 733697efd1..6d067a7c07 100644
--- 
a/nifi-nar-bundles/nifi-poi-bundle/nifi-poi-services/src/main/java/org/apache/nifi/excel/RowIterator.java
+++ 
b/nifi-nar-bundles/nifi-poi-bundle/nifi-poi-services/src/main/java/org/apache/nifi/excel/RowIterator.java
@@ -47,6 +47,7 @@ class RowIterator implements Iterator<Row>, Closeable {
                 .bufferSize(4096)
                 .password(configuration.getPassword())
                 .setAvoidTempFiles(configuration.isAvoidTempFiles())
+                .setReadSharedFormulas(true) // NOTE: If not set to true, then 
data with shared formulas fail.
                 .open(in);
 
         final List<String> requiredSheets = configuration.getRequiredSheets();