https://bugs.documentfoundation.org/show_bug.cgi?id=102075
Bug ID: 102075
Summary: FILEOPEN: XLSX file: Date shown as "[$-F400]H:MM:SS
AM/PM" instead of according to locale
Product: LibreOffice
Version: 5.2.1.2 rc
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 127275
--> https://bugs.documentfoundation.org/attachment.cgi?id=127275&action=edit
Excel XLSM file (XLS with macros)
Opens the file, goes to worksheet "Zeiten" (should be shown by default)
Result with LO 5.2.1.2:
* For the time values, "####" is shown; making the cell wider, it shows, e.g.,
"2:12:09 nachm." - The locale field shows "[$-F400]H:MM:SS AM/PM"
Expected as with MSO Excel 2007 on the same system:
* The time is shown as "14:12:09" as in Excel
[Default time value; the Excel "Format cell" dialog shows the note: "Time
formats that begin with an asterisk (*) resopnd to changes in regional date and
time settings that are specified for the operating system" where Type is
"*13:30:55" - and in this dialog the default: "Locale (location): English
(United States)" [cf. below.])
That's under Window 7 with the English version of MSO, the English interface of
LO and Windows locale settings:
| Format: English (United States)
| Short time: H:mm (! - note: default for the US is: H:mm tt)
| Long time: H:mm:ss (!)
The document's language is (effectively at least, I don't know what MSO wrote
to the file) German.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
