https://bugs.documentfoundation.org/show_bug.cgi?id=155911
Bug ID: 155911 Summary: Importing and formatting dates! Product: LibreOffice Version: 7.3.3.2 release Hardware: Other OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: w...@nigelspages.me.uk Description: I wanted to import text from a "Dir" output, and manipulate the dates.. 1. The "import" dialog firstly split the text at every 'space', and won't allow multiple spaces to be 'concatenated', so it split the date & time, and it's not easy to recombine! 2. I copied the output into a text file and edited it to replace spaces with Tabs, and tried again. If I select "D?M?Y" for the first column, it doesn't work, so I chose "text". I checked that the dates HAD been interpreted OK, but trying to format them as "D8" (..HH:MM:SS) generates an error. But if I use a formula to 'copy' the cell, it works! See attached file. Steps to Reproduce: 1.import date/time ("09/06/2023 11:34"), or concatenate a date & time using a formula (=A2 & " " & B2) 2.use the "D/M/Y" option on the import or try 'format cells [D8]' (or "=TEXT(A2,"DD/MM/YYYY HH:mm:SS") 3.Format D6 (HH:MM") seems to work! Actual Results: ### Expected Results: 09/06/2023 11:34:00 Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-GB Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) - Win.11 OS is 64bit: no - YES! i3 CPU -- You are receiving this mail because: You are the assignee for the bug.