[TIKA-2196] IllegalArgumentException on a valid Excel file

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.14
• Component/s: parser

Environment

Windows 7 x64, JVM 1.8.0_101

• Assignee: Unassigned
• Reporter: Seva Alekseyev
• Created: 13/Dec/16 17:19
• Updated: 09/Jan/18 19:37

Description

On the attached Excel file, which opens fine in Excel, Tika throws the following error:

java.lang.IllegalArgumentException: Cannot format given Object as a Number
at java.text.DecimalFormat.format:-1
at org.apache.poi.ss.usermodel.ExcelGeneralNumberFormat.format:67
at java.text.Format.format:-1
at org.apache.poi.ss.usermodel.DataFormatter.performDateFormatting:736
at org.apache.poi.ss.usermodel.DataFormatter.formatRawCellContents:804
at org.apache.poi.ss.usermodel.DataFormatter.formatRawCellContents:785
at org.apache.poi.hssf.eventusermodel.FormatTrackingHSSFListener.formatNumberDateCell:143
at org.apache.tika.parser.microsoft.ExcelExtractor$TikaHSSFListener$TikaFormatTrackingHSSFListener.formatNumberDateCell:633
at org.apache.tika.parser.microsoft.ExcelExtractor$TikaHSSFListener.internalProcessRecord:405
at org.apache.tika.parser.microsoft.ExcelExtractor$TikaHSSFListener.processRecord:336
at org.apache.poi.hssf.eventusermodel.FormatTrackingHSSFListener.processRecord:92
at org.apache.poi.hssf.eventusermodel.HSSFRequest.processRecord:109
at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents:179
at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents:136
at org.apache.tika.parser.microsoft.ExcelExtractor$TikaHSSFListener.processFile:312
at org.apache.tika.parser.microsoft.ExcelExtractor.parse:169
at org.apache.tika.parser.microsoft.OfficeParser.parse:177
at org.apache.tika.parser.microsoft.OfficeParser.parse:130

Issue Links

• is duplicated by: TIKA-2205 IllegalArgumentException on a valid Excel file