Created attachment 205058 [details] demonstrating the bug See attachment. This can't be intentional. The string to insert via the csv-dialogue was taken from the included shape. For a second experiment the string was taken from a Writer file. Same result. In both cases it was inserted from the clipboard, of course. For a third experiment the same string was saved to a plain-text file with extension .csv Opening this file with LibO 25.8.4.2 I got the same dialogue box with different defaults. After adjustment I now got the expected results in ISO 8601 date format. The locale set fo LibO was also English(Canada) BTW: Legacy V 3.3 didn't offer to use the dialogue when the string came from the clipboard. Can LibO fix the bad clipboard result?
Copy the text from the shape into the clipboard. Then set cursor into a cell and press Ctrl+Shift+V. From the 'Paste Special' dialog chose item "Use text import dialog". In the 'Text Import' dialog make sure 'Character set' is "Unicode (UTF-16)" and in the 'Separator Options' the option 'Semicolon' is selected. Do not use option 'Detected', because the detection considers the slash as separator in addition to the semicolon. In 'Fields' click on 'Standard 'and then select the desired date type from the 'Column type' drop-down. I see no problem. Tested with Version: 26.8.0.0.alpha0+ (X86_64) Build ID: 680(Build:0) CPU threads: 32; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: de-DE (de_DE); UI: en-US Calc: threaded
(In reply to Regina Henschel from comment #1) > Copy the text from the shape into the clipboard. > Then set cursor into a cell and press Ctrl+Shift+V. > From the 'Paste Special' dialog chose item "Use text import dialog". > In the 'Text Import' dialog make sure 'Character set' is "Unicode (UTF-16)" > and in the 'Separator Options' the option 'Semicolon' is selected. Do not > use option 'Detected', because the detection considers the slash as > separator in addition to the semicolon. > In 'Fields' click on 'Standard 'and then select the desired date type from > the 'Column type' drop-down. That's exactly what I did. This wasn't meant as a displaced question in ask.libreoffice, but seriously as a bug report. > I see no problem. > > Tested with Version: 26.8.0.0.alpha0+ (X86_64) > Build ID: 680(Build:0) > CPU threads: 32; OS: Windows 11 X86_64 (build 26100); UI render: > Skia/Vulkan; VCL: win > Locale: de-DE (de_DE); UI: en-US > Calc: threaded I used 25.8.4.2(installed) and 7.5.4.2(Potableapps). Very strange. I actually got the described different results depending on whether the string came from a "csv" file creating a new sheet, or from the clipboard. I'm afraid there was a misunderstanding. Did I describe my actions badly?