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

ady <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1
                 CC|                            |heiko.tietze@documentfounda
                   |                            |tion.org
           Keywords|                            |needsUXEval
           Severity|normal                      |enhancement

--- Comment #2 from ady <[email protected]> ---
(In reply to Eike Rathke from comment #1)
> You are confusing date acceptance patterns and date formats. For 06/17/23 I
> assume your locale is English (USA) as that matches its default date format
> MM/DD/YY. A date entered is displayed in the locale's default date format
> unless entered in the ISO 8601 YYYY-MM-DD date format. The input "Jun 17" is
> accepted as June 17, 2023 (current year). If you want the date to still be
> displayed as "Jun 17" then format the cell with the date number format MMM
> DD. If you want the input to stay text then precede it with an ' apostrophe,
> so 'Jun 17

The request starts by "Please allow me to turn off date acceptance patterns".

Whether there is some confusion between date format and date acceptance
pattern, I can still see a valid request.


At least 2 points to consider:

* Menu "Tools > Options > Language Settings > Languages > Date acceptance
patterns" does not accept an empty field (it is automatically set back to its
default after pressing "apply").

* Depending on Language(s), Menu "Tools > Options > LibreOffice Calc > Sort
Lists" includes items such as "Jun" (starting with "Jan", "Feb"...) which
_maybe_ influences the behavior too(?).

I am not sure (or don't recall ATM) which other settings or options can
influence the recognition of "Jun 17" as a date, but probably there are such
settings somewhere.

I am changing this to ENHANCEMENT request.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to