[Libreoffice-bugs] [Bug 45133] New: 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

             Bug #: 45133
           Summary: EDITING: Entering value Jan 2012 into cell produces
                    40909 instead of typed in text
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.4.5 release
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: grofaty at hotmail.com


Problem description: 
In any cell type in "Jan 2012" (without double quotes) and press Enter. In
LibreOffice v3.4.5 the number 40909 is displayed instead of text. Similar "Feb
2012" and after pressing Enter 40940 is displayed. It looks like my text was
transformed into some number value. Maybe some date that is internally mapped
with integer value.

I have tested the same string in LibreOffice v3.5 RC1 and instead of number
date is displayed for "Jan 2011": 01.01.2012
and 01.02.2012 for "Feb 2012". Date is probably in my local date format
DD.MM.YYYY.

In both cases I don't want to have a date, I just want to have a month data in
each column. The work-around is to add single quote = ' character at the
beginning of the cell text.

Don't know why this text is being changed to date in v3.5 or number in v3.4,
but I see no reason to have this transformation at all. I think Calc in this
case should not do any transformation and so leaving the field just like it is,
text based string.

Steps to reproduce:
1. In any cell type in "Jan 2012" (without double quote).
2. Press Enter
3. Text get changed to number 40909.

Current behavior:
40909 is displayed

Expected behavior:
Jan 2012

Platform (if different from the browser): 

Browser: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.25)
Gecko/20111212 Firefox/3.6.25

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