Olof Jonasson created TIKA-1054:
-----------------------------------
Summary: Problem with parsing excel date formats
Key: TIKA-1054
URL: https://issues.apache.org/jira/browse/TIKA-1054
Project: Tika
Issue Type: Bug
Affects Versions: 1.2
Reporter: Olof Jonasson
I'm using solr4.0 and tika1.2 and get some problems with indexing excel files
containing date formats. I've read TIKA-103 and TIKA-360 and there I get the
impression that the date formatting problem is solved (for some cases at least).
I've used testEXCEL-formats.xls from TIKA-103 and also resaved it as xlsx and
tested that as well. Default locale on my computer is swedish. This is what I
get (sorry for the occasional swedish):
Content of testEXCEL-formats.xlsx and testEXCEL-formats.xls
Number #,##0.00 1 599,99 -1 599,99
Currency $#,##0.00;[Red]($#,##0.00) $1 599,99 ($1 599,99)
Scientific 0.00E+00 1,98E+08 -1,98E+08
Percentage (0.025) 3% 2,50%
Fraction (2.5) 2 1/2
Time Format: h:mm AM/PM 6:15 AM 6:15 PM
Time Format: h:mm 06:15 18:15
Date Format: m/d/yy 2009-10-03
Date Format: d-mmm-yy 17-maj-07
Date/Time Format 2008-01-19 04:35
Custom Number: 19 dollars and ,99 cents
Custom Date: At 4:20 AM on torsdag maj 17, 2007
What the tika1.2 parser returns for the xlsx (and is indexed by solr)
Number #,##0.00 1 599,99 -1 599,99
Currency $#,##0.00;[Red]($#,##0.00) $1 599,99 ($1 599,99)
Scientific 0.00E+00 1,98E+08 -1,98E+08
Percentage (0.025) 3% 2,50%
Fraction (2.5) 2 1/2
Time Format: h:mm AM/PM 6:15 fm 6:15 em
Time Format: h:mm 6:15 18:15
Date Format: m/d/yy 2009/10/03
Date Format: d-mmm-yy 17-maj-07
Date/Time Format 1/19/08 4:35
Custom Number: 19,99 dollars and cents
Custom Date: 39219.18056369212
What the tika1.2 parser returns for the xls (and is indexed by solr)
Number #,##0.00 1 599,99 -1 599,99
Currency $#,##0.00;[Red]($#,##0.00) $1 599,99 ($1 599,99)
Scientific 0.00E+00 1,98E+08 -1,98E+08
Percentage (0.025) 3% 2,50%
Fraction (2.5) 2 1/2
Time Format: h:mm AM/PM 6:15 fm 6:15 em
Time Format: h:mm 6:15 18:15
Date Format: m/d/yy 10/3/09
Date Format: d-mmm-yy 17-maj-07
Date/Time Format 1/19/08 4:35
Custom Number: 19,99 dollars and cents
Custom Date: 39219.18056369212
---
Unexpected formats for:
Date Format: m/d/yy 2009-10-03
Date/Time Format 2008-01-19 04:35
Custom Date: At 4:20 AM on torsdag maj 17, 2007
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
