[ https://issues.apache.org/jira/browse/DRILL-8417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713393#comment-17713393 ]
ASF GitHub Bot commented on DRILL-8417: --------------------------------------- jnturton merged PR #2783: URL: https://github.com/apache/drill/pull/2783 > 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)