[
https://issues.apache.org/jira/browse/NIFI-13922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17893657#comment-17893657
]
ASF subversion and git services commented on NIFI-13922:
--------------------------------------------------------
Commit aacbd514ce4af7e41f54fc2418394c563395c9bd in nifi's branch
refs/heads/main from dan-s1
[ https://gitbox.apache.org/repos/asf?p=nifi.git;h=aacbd514ce ]
NIFI-13922 Fixed SplitExcel to use the evaluated formula value for cells (#9466)
Corrected the copy configuration in SplitExcel to ensure the evaluated value of
formulas are copied and not the actual formula.
Signed-off-by: David Handermann <[email protected]>
> SplitExcel appears to drop the values of a column which are from a calculated
> formula
> --------------------------------------------------------------------------------------
>
> Key: NIFI-13922
> URL: https://issues.apache.org/jira/browse/NIFI-13922
> Project: Apache NiFi
> Issue Type: Bug
> Affects Versions: 1.27.0, 2.0.0-M4
> Reporter: Daniel Stieglitz
> Assignee: Daniel Stieglitz
> Priority: Major
> Time Spent: 20m
> Remaining Estimate: 0h
>
> When reading the SalesData.xlsx referred to in NIFI-13418 with a flow which
> consists of
> GetFile -> SplitExcel -> ConvertRecord where the ConvertRecord is configured
> with an ExcelReader and a CsvrecordSetWriter it appears the values for column
> 'Sale_amt' which is a formula (column F * column G) is completely dropped as
> seen in the sample below with column headers and the first row
> {code:java}
> OrderDate,Region,Manager,SalesMan,Item,Units,Unit_price,Sale_amt
> 43106,East,Martha,Alexander,Television,95,1198,
> {code}
> Although when reading one of the tabs with a flow which consists of GetFile
> -> ConvertRecord the column is not dropped e.g. of the column names and the
> first row
> {code:java}
> OrderDate,Region,Manager,SalesMan,Item,Units,Unit_price,Sale_amt
> 1515196800000,East,Martha,Alexander,Television,95,1198,113810.0
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
