| Summary: | Calc Csv import unable to import as date a column with dash separator , ok with slash | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Nicolas R <fran2012> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | erack, fran2012 |
| Priority: | medium | ||
| Version: | 7.3.4.2 release | ||
| Hardware: | All | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Example file | ||
|
Description
Nicolas R
2022-07-19 13:04:52 UTC
Created attachment 181332 [details]
Example file
Oups, it seems to be more subtle. Actually 'YYYY-MM-DD' formatted field is directly imported as a date cell even without specifying "date YMD' in import dialog.... but the resulting date cell is formatted yyyy-mm-dd which is one of the proposed date format. Then you can change the cell format to any date format. Other format 'yyyy/mm/dd' or 'yyyy.mm.dd' must be specified as date ymd during import and the resulting column/cell is formatted as dd/mm/yy ( default date format for french LibO version). So , not really a bug but a new behavior during text import process. (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)? (In reply to Nicolas R from comment #2) Aha. In fact, as I wrote, I doubt it's new in 7.3 - because it worked that way also before. But maybe it differed in some specific cases (like some specific locales or specific settings selected in import dialogs ...) (In reply to Mike Kaganski from comment #4) > (In reply to Nicolas R from comment #2) > > Aha. In fact, as I wrote, I doubt it's new in 7.3 - because it worked that > way also before. But maybe it differed in some specific cases (like some > specific locales or specific settings selected in import dialogs ...) I confirm that for me, it's new in 7.3. In 7.2.7 (exact version with locales below) , "2022-06-11" was imported as text ... if you don't specify date YMD during import (confirm with sum/avg or Ctrl-F8). And when you specify "date ymd" during import there is an "auto-format" in imported cells with "dd/mm/yy" => 11/06/22. As in 7.3 this auto-format also happens for 2022/06/11 or 2022.06.11 ( with "date ymd" during import), but not for "2022-06-11" ... at first sight, I thought it was imported as text .... So this auto-recognized date during import is rather an enhancement than a bug. Sorry for this (no) bug entry. I think you can close it ! Version: 7.2.7.2 (x64) / LibreOffice Community Build ID: 8d71d29d553c0f7dcbfa38fbfda25ee34cce99a2 CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win Locale: fr-FR (fr_FR); UI: fr-FR Calc: CL |