https://bugs.freedesktop.org/show_bug.cgi?id=55875
Priority: medium
Bug ID: 55875
Assignee: [email protected]
Summary: XLSX import loose data with >15 char. numbers in text
type cells
Severity: blocker
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 3.6.2.1 rc
Component: filters and storage
Product: LibreOffice
With Excel 2007 (tested with 2007 but maybe 2010 too?), create a new
spreadsheet doc.
- select a cell and set number type as Text
- Enter a long number as 1234567890123456789
- save as XLSX (not tested with XLS)
- Open the file with LibreOffice
- The number in the cell is now 1234567890123450000
-> The numbers after the 15th are replaced with 0... the same beavior as typing
this number in a standard number cell format, and changing it after this in
text cell format ...
example file from Excel 2007 Vista 32bits :
http://cyrille.grosdemange.free.fr/libo/test-cellules.xlsx
In this file, the A2 cell shows the bug. The others are for reference.
This file displays well in GoogleDocs :
https://docs.google.com/open?id=0ByjMh5M85asZaWhCeHhEbnZFWHM
--
My alternative method to open correctly this file in LibO is :
- import in GoogleDocs (works)
- export from GoogleDocs in ODS
- Open the exported Google Docs ODS with LibO
So ... I think the problem is in the import filter who should set the cell
number type BEFORE inserting values into it (Don't know the code but seems like
that)
Thanks.
Set this bug to blocker because long numbers are sometime serial numbers etc.
and NEEDS to be correct.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
