https://bugs.freedesktop.org/show_bug.cgi?id=45133
grofaty <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|INVALID | --- Comment #7 from grofaty <[email protected]> 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. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
