[Libreoffice-bugs] [Bug 127530] New: Calc does not reapply DD-MMM-YY date formatting when modifying date values in certain instances

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 127530
           Summary: Calc does not reapply DD-MMM-YY date formatting when
                    modifying date values in certain instances
           Product: LibreOffice
           Version: 6.2.7.1 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jmliles4290 at gmail.com

Description:
This problem began around Calc version 6.2.7. Using cell date format DD-MMM-YY,
you can type "12 sep 19" and Calc will correctly recognize the date and display
it as "12-Sep-19" with the underlying date data of 09/12/2019, but this fails
in some instances. Specifically, if the cell already contains a date in this
format and you attempt to type over it, Calc will remove the date formatting
and not reapply it unless the date is typed exactly (including the dashes). In
order to modify a date in a cell with this formatting, you either have to
delete the cell contents first, or type the new date twice (typing it the first
time removes the formatting, and typing it a second time recognizes the date
correctly).

Steps to Reproduce:
1. Select a cell and change the formatting to Date, DD-MMM-YY
2. In that cell, type "12 sep 19". The cell should display a date value of
"12-Sep-19".
3. Type over the existing text with "12 sep 19". The date formatting will be
removed and the cell value will change to '12 sep 19 (this is the bug)
4. Type over the text again with "12 sep 19". The date formatting will be
correctly reapplied and the cell should again correctly display a date value of
"12-Sep-19".

Actual Results:
In step 3, the date formatting will be removed and the cell value will change
to '12 sep 19 (this is the bug)

Expected Results:
Step 3 should perform the same as step 4.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no

-- 
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/20190913/9d90d565/attachment.html>