https://bugs.documentfoundation.org/show_bug.cgi?id=150288
--- Comment #11 from Joao Carvalho <joaol...@gmail.com> --- (In reply to m.a.riosv from comment #10) > What do you see formatting those results as ISO format yyyy-mm-dd Ok, so this is what I tried and this is what I found. Again, let me first define three different Language settings that I tried: Language settings 1: User interface: Default - English (USA) Locale setting: Default - English (USA) Date acceptance patterns: M/D/Y;M/D Language settings 2: User interface: Default - English (USA) Locale setting: Default - English (USA) Date acceptance patterns: D/M/Y;D/M Language settings 3: User interface: Default - English (USA) Locale setting: Portuguese (Brazil) Date acceptance patterns: D/M/Y;D/M Steps: 1. On menu: File/New/Spreadsheet 2. On menu: Tools/Options/Language Settings/Language 3. Set one of the three "Language Settings" I defined above. 4. Left-click on "A" to select the entire column A. 5. Right-click on "A" to open the pop-up menu, and select "Format Cells". 6. Select Category "Date", Language "Portuguese (Brazil)", and Format "1999-12-31". Click "Ok". This will apply the YYYY-MM-DD format Code (ISO 8601). 7. Type 31/8/22 in cell A1. 8. Type 1/8/22 in cell A2. Results: - Language settings 1 and 2: Typing 31/8/22 automatically formats to 2022-08-31, but typing 1/8/22 automatically formats to 2022-01-08. Aug. 1st becomes Jan. 8th. Language settings 3: Typing 31/8/22 automatically formats to 2022-08-31, and typing 1/8/22 automatically formats to 2022-08-01, as I expected. -- You are receiving this mail because: You are the assignee for the bug.
