[Libreoffice-bugs] [Bug 45133] EDITING: Entering value Jan 2012 into cell produces 40909 instead of typed in text

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=45133

grofaty <grofaty at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|INVALID                     |

--- Comment #7 from grofaty <grofaty at hotmail.com> 2012-01-30 04:23:08 UTC ---
1. Open new LibreOffice Calc document
2. In cell A1 type in: Jan 2012
3. Press Enter.

In LibreOffice v3.4.5 in A1 cell is displayed: 40.909
In LibreOffice v3.5.0 RC2 in A1 cell is displayed: 01. 01. 12
In Microsoft Office 2007 in A1 cell is displayed: jan.12
See attached ods file.

If I understand correctly, when numbers (or text) is inserted into cell and
pressed Enter according to inserted numbers/text some pattern is checked and
according to pattern formatting to the cell is applied.

I think LibreOffice Calc does not apply correct formatting if "Jan 2012" is
typed into cell. It is obvious it is month data, but Calc formats it as it
would be a date data.

If right click on A1 and select Format Cells and:
In LibreOffice v3.4.5 is displayed: Format code: #.##0
In LibreOffice v3.5.0 RC2 is displayed: Format code: DD.MM.YY
But correct display format should be: Format code: MMM.YY

Because LibreOffice is unable to automatically correctly set the formatting, I
can do a work-around:
1. Right-click on A1 cell.
2. Select Format Cell.
3. Format code: MMM.YY and press OK button.
4. LibreOffice now displays: jan.12 which is correct display (just like
Microsoft Office 2007).
See attached print-screens.

P.S. I don't have any reference in LibreOffice Calc documentation, I am
referencing Microsoft Office display if the same data is typed in spreadsheet
cell. It is quite logical that if entering month data into cell it should
appear correctly formatted as month and not display date.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.