[
https://issues.apache.org/jira/browse/TIKA-2025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15850067#comment-15850067
]
ASF GitHub Bot commented on TIKA-2025:
--------------------------------------
GitHub user vulpes8 opened a pull request:
https://github.com/apache/tika/pull/151
fix for TIKA-2025 contributed by vulpes8
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/vulpes8/tika fix/TIKA-2025
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tika/pull/151.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #151
----
commit 0c5d609e0175dffb93c1a325c9a872c5e6945eb0
Author: Cataldo Mazzilli <[email protected]>
Date: 2017-02-02T14:32:42Z
fix for TIKA-2025 contributed by vulpes8
----
> Extraction of long sequences of digits from Excel spreadsheets using Tika
> 1.13 doesn’t yield the expected results
> -----------------------------------------------------------------------------------------------------------------
>
> Key: TIKA-2025
> URL: https://issues.apache.org/jira/browse/TIKA-2025
> Project: Tika
> Issue Type: Bug
> Components: parser
> Affects Versions: 1.13
> Reporter: Aeham Abushwashi
> Assignee: Tim Allison
> Fix For: 2.0, 1.14
>
> Attachments: Credit Card Numbers.xlsx
>
>
> If an Excel spreadsheet contains a long sequence of digits, such as a credit
> card number, Tika 1.13 will emit the said sequence in scientific notation.
> For example, the credit card number “340229177292566” is extracted from the
> attached spreadsheet as 3.40229E+14, which clearly is not the desired output.
> This works as expected in 1.12 and earlier. I suspect POI’s recent use of
> org.apache.poi.ss.usermodel.ExcelGeneralNumberFormat is to blame.
> I think the impact of this issue is significant. There’s plenty of
> information that can no longer be reliably extracted from spreadsheets. Think
> credit card numbers, telephone numbers and product identifiers to name a few.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)