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: [email protected]
Reporter: [email protected]
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.
