https://bugs.documentfoundation.org/show_bug.cgi?id=150062
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from Mike Kaganski <[email protected]> --- (In reply to Nicolas R from comment #0) > From version 7.3.x ( tested with 7.3.4 French), for a field formatted as > YYYY-MM-DD , even if you specify "date YMD", the import is made as text > column. The sample you provided imports as dates using Version: 7.4.0.1 (x64) / LibreOffice Community Build ID: 43e5fcfbbadd18fccee5a6f42ddd533e40151bcf CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (ru_RU); UI: en-US Calc: CL > Actual Results: > 2022-06-11 > > Expected Results: > 11/06/2022 ( french date format, 'cause french version of Libreoffice. But I can see it importing as 2022-06-11, *just the same way as it did in 7.2* - because 2022-06-11 is *not* a text, but a *very special*, ISO-standardized, date format - so LibreOffice implicitly recognizes it, even when it's not in the date acceptance patterns, and importing it, LibreOffice *takes care to keep the ISO format* (just because it's the only universally recognizable, unambiguous, date representation). Can you check if it is really a text for you - such as, when you select a cell with the "2022-06-11", the status bar displays empty "sum" and "average" - or does it display also "2022-06-11", indicating that the data is recognized as a date? Or you may use View->Value Highlighting (Ctrl+F8), and check if the cells are colored blue (indicating the numeric/date content), or black (which stands for text)? -- You are receiving this mail because: You are the assignee for the bug.
