[DRILL-7813] Excel Reader Crashes on Formulae Which Return Strings

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Done
• Affects Version/s: 1.17.0
• Fix Version/s: 1.19.0
• Component/s: Storage - Text & CSV
• Assignee: Charles Givre
• Reporter: Charles Givre
• Created: 01/Dec/20 13:49
• Updated: 16/Dec/20 14:29
• Resolved: 16/Dec/20 14:29

Description

The Excel Reader will crash with a NumberFormatException if there is data where a column has a formula and that formula returns text.  

This minor bug fix checks to see whether the output can be read as a number, and if so read the column as numeric.  If not, read the column as text.