[TIKA-922] iWork number cell formats which are being modified in parsing

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

Environment

Windows 7, 64 bit

• Assignee: Unassigned
• Reporter: Erik Peterson
• Created: 15/May/12 19:45
• Updated: 16/May/12 02:18

Description

iWork Number cell formats which Tika parser is parsing but in a modified form.

Percentage turns into a decimal. ie 90% becomes .9000000002
Accounting appends a $, but the $ is missing from parsed data
Fraction is turned into a decimal
Number System (ie Binary) translated to decimal. Ie '11001000' becomes '200'
Scientific Numbers translated to decimal. ie 9.0000E-03 becomes 9000
Drop down menu parses all the menu items, but not what's selected.
Currency & Number aren't displayed properly ie. $0.60 becomes .59999