Calc opens CSV with narrow column so cannot read the date. Users need to manually resize the Date column. the fields are correctly detected as dates, Calc should set appropriate column width
Created attachment 183607 [details] calc.csv example
Created attachment 183608 [details] Screenshot showing the issue when opening the CSV file
Note that whether that string 29/12/20 is recognized as date is locale dependent, in a locale where it is not recognized as date it is imported as text and the cell width is correctly adjusted. Use 2020-12-29 instead.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/8309f94001ec29faff288cb8f920ee00978bb85a Resolves: tdf#152053 GetOptimalColWidth() obtain number format from next row It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/c/core/+/142687 for 7-4
Amazing Eike!
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/6fb437e6cef4ca402e81ee8037f361a4de911549 Resolves: tdf#152053 GetOptimalColWidth() obtain number format from next row It will be available in 7.4.4. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Thanks Heike, verified as fixed in: Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 45d1fca81991f0d6837c98d6be6fe0d21d566fa5 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded
(Sorry for the misspelling!) Thanks Eike, verified as fixed in: Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 45d1fca81991f0d6837c98d6be6fe0d21d566fa5 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/9e4b47190eb762f3aea80920846fe5135b7d76fc tdf#152053: sc_subsequent_filters_test2: Add unittest It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.