Bug 147124 - [FILEOPEN] NUMBERS import incorrect numeric values
Summary: [FILEOPEN] NUMBERS import incorrect numeric values
Status: NEW
Alias: None
Product: Document Liberation Project
Classification: Unclassified
Component: libetonyek (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Apple-iWork
  Show dependency tree / graph
 
Reported: 2022-02-02 10:20 UTC by SheetJS
Modified: 2024-06-04 13:10 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
specimen (288.22 KB, application/zip)
2022-02-02 10:21 UTC, SheetJS 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description SheetJS 2022-02-02 10:20:06 UTC 
Description:
LO does not correctly read certain numbers from NUMBERS files.  See attached.

Steps to Reproduce:
Open Attached File

Actual Results:
B20 is 1048580

Expected Results:
B20 is 1048576


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Recalculation on File Load settings:

- Excel 2007 and newer: "Always recalculate"

- ODF spreadsheet (not saved by LibreOffice): Never recalculate
Comment 1 SheetJS 2022-02-02 10:21:09 UTC 
Created attachment 177983 [details]
specimen
Comment 2 Mike Kaganski 2022-02-02 12:10:21 UTC 
This is a bug in libetonyek. Code pointer: use of operator << to put double (readDouble) to string buffer in IWAParser::parseTile, which converts 1048576.0 into string like "1.04858e+06".