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.
Already visible with "LibreOffice 3.3.3 German UI/Locale [OOO330m19 (Build:301) tag libreoffice-18.104.22.168] 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"
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'
It's more or less all the same with Gnumeric. So I wonder whether that might be ODF limitation?
Created attachment 62853 [details]
See Comment 1
> 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 .
No further info by reporter required.
Looks like WONTFIX or NOTOURBUG?
NOTOURBUG - this is a limitation of ODF standards which is unfortunate but NOTOURBUG.