https://bugs.documentfoundation.org/show_bug.cgi?id=164239
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |ASSIGNED Version|24.8.3.2 release |3.6 all versions Assignee|[email protected] |[email protected] |desktop.org | Ever confirmed|0 |1 --- Comment #7 from Eike Rathke <[email protected]> --- Bug 164227 is unrelated, except that both are about date acceptance. 12-1-1 in a locale with MDY order like en-US is treated as slightly ambiguous if the date acceptance patterns were not matched, as the 12 could be a month number. Hence the result is text instead of date. In a locale with DMY order it could be day numbers 1..31. However, we maybe could tighten that condition and say that if the input does not match any date acceptance pattern then we can force an ISO date. > 1. The examples demonstrate that the preset cell format affects how entered > strings are interpreted into Calc's internal types and values. Is this > behavior intentional or is it a bug? Not a bug, it's intentional as users want to be able to input/overwrite a date in the same format it is displayed. > 2. When a cell's format is set to "General" and a string is entered, does > Calc: > - interpret it deterministically (always the same way), or > - interpret it conditionally based on the environment (e.g., the types of > surrounding cells)? Surrounding cells don't matter. -- You are receiving this mail because: You are the assignee for the bug.
