Bug 50923 - FILESAVE as .ods changes user defined time format HH:MMa/p to H:MMAM/PM
Summary: FILESAVE as .ods changes user defined time format HH:MMa/p to H:MMAM/PM
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: odf
Keywords:
Depends on:
Blocks:
 
Reported: 2012-06-09 15:21 UTC by rhubarbpieguy
Modified: 2013-06-28 00:46 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Test Kit (8.33 KB, application/zip)
2012-06-10 00:27 UTC, Rainer Bielefeld Retired
Details

Note You need to log in before you can comment on or make changes to this bug.
Description rhubarbpieguy 2012-06-09 15:21:23 UTC
User-defined date format does not save.  I can create and display H:MMa/p (example: 1:11p).  However, the format doesn't save.  If I reopen the spreadsheet I must rebuild the format.  It does save with the XML file format, but I prefer ods.
Comment 1 Rainer Bielefeld Retired 2012-06-09 23:32:10 UTC
Already visible with "LibreOffice 3.3.3  German UI/Locale [OOO330m19 (Build:301) tag libreoffice-3.3.3.1] on German WIN7 Home Premium (64bit) 
Still visible with Server Installation of  "LibreOffice 3.6. 0beta1  English UI/Locale [Build-ID: 1f1cdd8] on German WIN7 Home Premium (64bit) 

Seems inherited from OOo, already in OOo 1.1.4

When you open attached "sample.xls" in LibO and save it as .ods, close and reopen, you will see that number format in B2 will have changed from  "H:MMa/p" to "H:MMAM/PM"

@reporter:
May be for further reports you can test <https://www.libreoffice.org/get-help/bug/> for submitting bug reports? You reach that Bug Submission Assistant via LibO menu 'Help -> Feedback / Bug Report'

@David:
It's more or less all the same with Gnumeric. So I wonder whether that might be  ODF limitation?
Comment 2 Rainer Bielefeld Retired 2012-06-10 00:27:39 UTC
Created attachment 62853 [details]
Test Kit

See Comment 1
Comment 3 David Tardon 2012-06-12 01:00:32 UTC
> It's more or less all the same with Gnumeric. So I wonder whether that might be
>  ODF limitation?

Yes, AFAIK there is currently no way to express this in ODF. C.f. xmloff/source/style/xmlnumfe.cxx:1563 , where both NF_KEY_AMPM and NF_KEY_AP are written using the same XML element, number:am-pm .
Comment 4 Rainer Bielefeld Retired 2013-04-08 06:17:25 UTC
No further info by reporter required.

Looks like WONTFIX or NOTOURBUG?
Comment 5 Joel Madero 2013-06-28 00:46:14 UTC
NOTOURBUG - this is a limitation of ODF standards which is unfortunate but NOTOURBUG.