You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Philipp Korniets (Jira)" <ji...@apache.org> on 2026/10/05 17:16:00 UTC

[jira] [Created] (NIFI-16429) ExcelReader - "Use Starting Row" strategy doesn't evaluate formulas for Header Row

Philipp Korniets created NIFI-16429:
---------------------------------------

             Summary: ExcelReader - "Use Starting Row" strategy doesn't evaluate formulas for Header Row
                 Key: NIFI-16429
                 URL: https://issues.apache.org/jira/browse/NIFI-16429
             Project: Apache NiFi
          Issue Type: Bug
            Reporter: Philipp Korniets
         Attachments: test_book.xlsx

When processing this workbook, header in Second Sheet contains formula.

="value_in_"&'First Sheet'!B1

Previously, ConvertExcelToCSV was returning last cached value. However in new ExcelReader value comes from DataFormatter and not from getCellValue() for strategy  *Use Starting Row*
So the result looks wrong i think


{code:java}
test_col1,"\"value_in_\"&'First Sheet'!B1",test_col3{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)