https://bugs.documentfoundation.org/show_bug.cgi?id=164355
--- Comment #2 from Mike Kaganski <[email protected]> --- (In reply to gplhust955 from comment #0) > using a period (.) as a separator is problematic because: > 1. The period is widely used as a decimal separator in many locales How can this be of a concern here, where the entered string discussed here can't be confused with a number (it contains the month name)? > 2. It doesn't conform to any common international date format standard Why do we need to discuss an *international* date format here, when a national standard (or even just a widely used convention) is enough to justify it? > Steps to Reproduce: > 1. Enter "Jun-15.2023" in any cell > > Actual Results: > Date(2023, 1, 15) > > Expected Results: > Text Why? The description doesn't show a *problem*, just "I expect something else for no specific reason". Note that even if this is changed as you suggest, a single character changed in the input (as in your #1) would still make the number-formatted cell to recognize the input as a date. So it seems like a methodology problem: Calc, as an application created specifically for number processing, *by default* tries hard to recognize any user input as a number of some kind. Thus, there are very many input patterns, like currencies, fractions, percents, scientific notation, negatives written as number in parentheses or with trailing minus, etc., that may be unexpectedly recognized as numbers - when the intent is text. Thus, to input text, the *correct* methodology is either pre-format the cell (column) as text - or prepend the input with apostrophe for a one-shot input. -- You are receiving this mail because: You are the assignee for the bug.
