https://bugs.freedesktop.org/show_bug.cgi?id=54806
Bug #: 54806
Summary: Saving to .xlsx format truncates two leading zeros of
value dispite "text" cell format
Classification: Unclassified
Product: LibreOffice
Version: 3.6.1.2 release
Platform: x86 (IA32)
OS/Version: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 67025
--> https://bugs.freedesktop.org/attachment.cgi?id=67025
files in different formats and only .xlsx format truncates leading zeros
We have a new speadsheet
Cell A1 has "text" format
We put any value in cell A1, for example, 10001643 and save document in
Microsoft Excel 2007/2010 .xlsx file format (test 1.xlsx)
In second step we add two leading zeros to value in cell A1. Now we have value
0010001643 in cell A1.
If we save document in Microsoft Excel 2007/2010 .xlsx file format, then after
closing file and opening it again, we can see that value in A1 cell is 10001643
without the two leading zeros, despite that it must be 0010001643 (test 2.xlsx)
If we save document in any other format (Microsoft Excel 97/2000/XP/2003 .xls
or .ods format - test 3.xls and test 4.ods), then after closing file and
opening it again in cell A1 we can see correct value 0010001643.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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
