https://bugs.freedesktop.org/show_bug.cgi?id=88137
Bug ID: 88137
Summary: Spaces before cell values are not preserved when save
as XLSX and reopen with MSO
Product: LibreOffice
Version: 4.3.5.2 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Steps to reproduce:
1. Type in " abc" in A1 (there are three spaces before the letters).
2. Save as xlsx;
3. Reopen with MSO.
--> It shows "abc" when open with MSO, the spaces are not preserved.
4. Reopen the xlsx with LibreOffice
--> It shows " abc" in A1 as expected.
More info:
Unzip the xlsx file, you will find in \xl\sharedStrings.xml:
<t> abc</t>
When you create a same xlsx file using MSO 2010, you will find in
\xl\sharedStrings.xml:
<t xml:space="preserve"> abc</t>
Aparently the attibute xml:space="preserve" matters.
Version: 4.4.0.1
Build ID: 1ba9640ddd424f1f535c75bf2b86703770b8cf6f
Locale: zh_CN
Win 7 X86
--
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
