Description: Typing the number 11 in a cell should result in the number 11 being in that cell. Instead it always changes to "00-01-10", which is incredibly anti-helpful when I'm trying to type in list of numbers. It seems like everyone on the planet hates the auto-date "feature", but no one will actually do anything about it. I have been using LO since it was called StarOffice 5, and in all these years auto-dates have NEVER been helpful, but frequently hinder me significantly because of my mental and physical disabilities. Forcing users to deal with workarounds instead of just putting a toggle in the settings is asinine in the extreme. I wish I had the necessary skills to fix it. Instead LO repeatedly chooses to remain yet another program whose developers don't care about people with disabilities. I should learn to assume that by now. Steps to Reproduce: 1.Type a number into a cell 2. 3. Actual Results: It turns into a freaking-useless date. Even more useless because I have to tell it I'm Canadian in order to make it use non-middle-endian-dates. Expected Results: The number I typed. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.5.4.2 (X86_64) / LibreOffice Community Build ID: 36ccfdc35048b057fd9854c757a8b67ec53977b6 CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-CA (en_US); UI: en-US Calc: threaded
This would *only* happen, if your cells were *pre-formatted* as date (specifically, using 'YY-MM-DD' format). It is *not* something that you call a strange term "auto-dates" (whatever you mean), but explicitly following the *user's* decision - expressed in the cell's format that user applied. Entering 11 to a cell *not* formatted in that way would not interpret this as a date. If it happens to you regularly, please check if you use some user template, which has this cell formatting (which would be something that its creator did, and maybe then forgot - but that doesn't mean that the program should guess that, and ignore). Closing NOTABUG.