[Libreoffice-bugs] [Bug 142464] New: Date format from MS Word not imported correctly

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142464

            Bug ID: 142464
           Summary: Date format from MS Word not imported correctly
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: LibreOffice
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jack.osullivan at preservica.com

Created attachment 172294
  --> https://bugs.documentfoundation.org/attachment.cgi?id=172294&action=edit
docx with date fields

I have a date-time field in a docx (created in MS Word 365) which is formatted
with the string:

TIME \@ "M/d/yyyy h:mm am/pm" \* MERGEFORMAT

which displays correctly in Word as:

(e.g.) 5/24/2021 1:55 PM

When I open this document in LibreOffice (tested with 5.3.7.2 on Linux and
7.0.6.2 on Windows with the same outcome in each) the date-time displays as:

(e.g.) 5/24/2021 13:55 a5/p5

This suggests that the am/pm marker from the MS format isn't being recognized
as an instruction to use a 12hr clock and display the am/pm marker, but rather
than it should use a 24hr clock and display the a and p as literal strings and
interpret the "m" as a month marker.

This behavior is also observed when running a command line "convert-to" odt.

I have attached the original docx to enable re-production. This docx also
demonstrates related date-time bugs for tickets:

136347 - (See Last Print Time in attached docx)
65209 - (When converting to ODT, TZ info is lost)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210524/2e1b07da/attachment-0001.htm>