[Libreoffice-bugs] [Bug 139517] New: Calc: Date values toggle between date and text when changed

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139517
           Summary: Calc: Date values toggle between date and text when
                    changed
           Product: LibreOffice
           Version: 7.0.3.1 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: webmonk at usa.net

Description:
When a field, which is already defined as a date and has a date in it, is
changed to reflect a new date, the value is saved as a text value rather than
converting to a proper date format.  For example: 1 jan should become 01 Jan
21, but it simply becomes '1 jan (text string).  Typing 1 jan again will
convert properly to a date (01 Jan 21).  Alternating attempts result in a date,
string, date, string, etc.  See steps for exact details.

Steps to Reproduce:
1) New spreadsheet
2) Highlight column A
3) Press Ctrl-1
4) Numbers tab Format code = DD MMM YY
5) Press OK
6) Go to cell A1
7) Type 15 dec and press TAB
8) You should now see 15 Dec 20 (or 21 if we are in 2021)
9) Press the left arrow to go back to A1
10) Type 15 dec and press TAB
11) You will now see '15 dec (press F2 to see)
12) The field converted to text verses staying with the previous date format
and adding the year
13) Go to step 9 and repeat several more times and you will see that it keeps
cycling between the two formats


Actual Results:
Date is entered as a string rather than converting to a date format.

Expected Results:
Convert text to a defined date format.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: default; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

-- 
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/20210109/c3bef385/attachment.htm>