[
https://issues.apache.org/jira/browse/DRILL-8417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17712254#comment-17712254
]
ASF GitHub Bot commented on DRILL-8417:
---------------------------------------
jnturton commented on PR #2783:
URL: https://github.com/apache/drill/pull/2783#issuecomment-1508106845
Reviewer's note: all format-excel tests do pass, the CI test failures here
are a result of as yet unfixed breakage brought in by Calcite 1.35-SNAPSHOT.
> Allow Excel Reader to Ignore Formula Errors
> -------------------------------------------
>
> Key: DRILL-8417
> URL: https://issues.apache.org/jira/browse/DRILL-8417
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - Excel
> Affects Versions: 1.21.0
> Reporter: Charles Givre
> Assignee: Charles Givre
> Priority: Major
> Fix For: 1.21.1
>
>
> If Drill encounters an Excel formula which is invalid somehow, such as a
> DIV/0, Drill is unable to proceed and throws a number format exception.
> This PR adds a config parameter called ignoreErrors which allows Drill to
> skip such records and returns null for that cell. Drill will also output a
> log warning. When set to false, original behavior is retained.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
