incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject [Bug 121151] Uppercase MM in number format from Excel is not recognized
Date Sat, 06 Oct 2012 20:54:35 GMT

Andrea Pescetti <> changed:

           What    |Removed                     |Added
             Status|UNCONFIRMED                 |CONFIRMED
            Summary|Date cell doesn't show      |Uppercase MM in number
                   |month                       |format from Excel is not
                   |                            |recognized
     Ever confirmed|0                           |1

--- Comment #5 from Andrea Pescetti <> ---
So the issue here is that the number format
is not recognized completely.

Its meaning is:
- "[$-410]": (irrelevant in our case) interpret according to the Italian
"culture", see
- "dd": show the day as 01-31, see
- "MM": not standard, it should be "mm" (lowercase) according to the same link
and it would mean month as 01-12
- "yyyy": year, 4 digits (same link)

So it seems that the report generation is indeed producing something that does
not adhere to the Microsoft specification, since it produces "MM" instead of
"mm". If you open your file in Notepad (yes, it's a normal text file) and
then OpenOffice will display it correctly. Otherwise, it will ignore the
uppercase "MM" since it's invalid, and it will display day and year only.

And now the problem is: do we want to relax the OpenOffice parser so that "MM"
and "mm" are considered equivalent like apparently Excel and Gnumeric do? This
usually requires discussion and valid arguments, unless you manage to find some
Microsoft specification saying explicitly that we should be case-insensitive

You are receiving this mail because:
You are the assignee for the bug.

View raw message