Description: If you insert a single value, everything is fine, but the range is not. 08:35:37 07:47:58 08:08:51 It inserts as text. If you force the cell type to time, but force ' is added and nothing changes. If you set the date column format when inserting, some cells are reformatted to look like xx.xx.xx from xx:xx:xx Steps to Reproduce: 1.Select: 08:35:37 07:47:58 08:08:51 2. Insert into calc Actual Results: Insert as time Expected Results: Insert as text or transform some lines in wrong format Reproducible: Always User Profile Reset: No Additional Info: Version: 25.8.4.2 (X86_64) / LibreOffice Community Build ID: 580(Build:2) CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) Locale: be-BY (be_BY.UTF-8@latin); UI: be-BY Ubuntu package version: 4:25.8.4~rc2-0ubuntu0.24.04.1~lo1 Calc: threaded
If you want text, use the right arrow of the paste icon, or Menu>Edit>Paste special, past as unformatted text, marking the column as text. But I'm unsure to understand the question.
Menu>Edit > Paste special > Hypertext markup Language (HTML) > check "Detect special numbers" Is it what you want?
Raal this method works. Not obvious but working. Thank you.
(In reply to m_a_riosv from comment #1) > If you want text, use the right arrow of the paste icon, or Menu>Edit>Paste > special, past as unformatted text, marking the column as text. > > But I'm unsure to understand the question. If you insert a single value, it is inserted as time. If you insert a range, it is inserted as text. And I would like it to be the same as for a single value - time. Your method does not work
(In reply to raal from comment #2) > Menu>Edit > Paste special > Hypertext markup Language (HTML) > check "Detect > special numbers" > Is it what you want? Hypertext markup Language (HTML) Unfortunately, it is only available if you copy from HTML.
IIUC, you are trying to copy several lines of the form "hh:mm:ss" from a text, and paste them on a Calc spreadsheet at once. Whichever the result you get in Calc, it depends on the way the original data is being pasted in Calc. When you attempt to paste the data, do you see the "Text Import" dialog? Or, is the data being pasted directly without any dialog of any sort? If you do see the Import Text dialog, which settings / options are you selecting? The reason for these questions is because, for anyone to be able to replicate the issue, we need those details. Please try to clarify the procedure and which options are you selecting – perhaps with a clear screenshot of the Import Text dialog, if that is what you are using. ATM, this sounds more an issue for <https://ask.libreoffice.org> rather than a bug report.
I think you're right - thanks to Raal, the insertion method has been found and it doesn't look like a bug, despite the fact that when inserting one value everything is fine, but when inserting several you have to use the import dialog with personal settings. My report is not entirely appropriate and may be deleted.
(In reply to levanchuk@gmail.com from comment #7) > the insertion method has been found FWIW, using a plain text editor as source of the data, I can copy several lines of text in the format of "hh:mm:ss" and paste (simple ctrl+v) that into Calc (LO Dev 26.8a) correctly, and the resulting cells are automatically formatted by Calc as time values. The result does depend on the options I select in the Text Import dialog. IOW, you are not restricted to having the data in html; simple text should be fine too.