https://bugs.freedesktop.org/show_bug.cgi?id=88019
Bug ID: 88019
Summary: FILESAVE FORMATTING saving sheet as xml loses
user-defined date format
Product: LibreOffice
Version: 4.3.4.1 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Problem description:
FILESAVE FORMATTING saving sheet as xml loses user-defined date format.
Defining a user-defined format like DD-MMM-YYYY is not properly saved when the
sheet is saved using "as Microsoft XMl format (*.xml)"
Steps to reproduce:
1. create new sheet
2. set a cell with value 1-Apr-2015
3. right click > format cell > format code
4. enter "DD-MMM-YYYY"
spreadsheet shows 1-Apr-2015, as expected.
5. file > save "as Microsoft XML 2003 (*.xml)"
6. close sheet. open saved xml sheet
Current behavior:
Date appears formatted as 1-Apr-14.
User-defined format got lost while saving as *.xml
If you open the xml file you can confirm that is was saved as <NumberFormat
ss:Format="Medium Date">, hence losing the specific format.
Expected behavior:
xml file should be able to save ("remember") the user-defined format.
--
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
