[
https://issues.apache.org/jira/browse/NIFI-13418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Daniel Stieglitz updated NIFI-13418:
------------------------------------
Description:
Currently if an Excel spreadsheet has a shared formula, the ExcelReader throws
the following exception
{code:java}
java.lang.IllegalStateException: This cell has a shared formula and it seems
setReadSharedFormulas has been set to false or the formula can't be evaluated
{code}
NOTE: This issue was mentioned in NIFI-11167 but I could not find data which
exhibited this issue. I have now found data which exhibits the issue (see
attached).
was:
Currently if an Excel spreadsheet has a shared formula, the ExcelReader throws
the following exception
{code:java}
java.lang.IllegalStateException: This cell has a shared formula and it seems
setReadSharedFormulas has been set to false or the formula can't be evaluated
{code}
NOTE: This issue was mentioned in NIFI-11167 but I could not find data which
exhibited this issue. I have now found data which exhibits the issue.
> Add support to ExcelReader to handle Excel spreadsheets with shared formulas
> ----------------------------------------------------------------------------
>
> Key: NIFI-13418
> URL: https://issues.apache.org/jira/browse/NIFI-13418
> Project: Apache NiFi
> Issue Type: Bug
> Reporter: Daniel Stieglitz
> Assignee: Daniel Stieglitz
> Priority: Major
> Attachments: SaleData.xlsx
>
>
> Currently if an Excel spreadsheet has a shared formula, the ExcelReader
> throws the following exception
> {code:java}
> java.lang.IllegalStateException: This cell has a shared formula and it seems
> setReadSharedFormulas has been set to false or the formula can't be evaluated
> {code}
> NOTE: This issue was mentioned in NIFI-11167 but I could not find data which
> exhibited this issue. I have now found data which exhibits the issue (see
> attached).
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
