Description: 1) Copy of ONE LINE of unformatted text understand " \t" as <space><new_column>. 2) Copy of MULTIPLE LINES of unformatted text understand " \t" as <new_column><new_column>. It understood as <space><new_column> in both cases in version 24.2. Steps to Reproduce: Case a: 1. Copy text "a1 b1" (ie. "a1 \tb1") as unformatted text (Ctrl + Shift + V) in cell A1. 2. Result: "a1 " in A1 cell, "b1" in B1 cell. It WORKS as expected (and as 24.2 version). ------------------------ Case b: 1. Copy text "a2 b2 a3 b3" (ie. "a2 \tb2\r\la3 \tb3") as unformatted text (Ctrl + Shift + V) in cell A2. 2. Result: "a2" in A2 cell, cell B2 empty, "b2" in C2 cell, "a3" in A3 cell, cell B3 empty, "b3" in C3 cell. It IS WRONG (and different than in 24.2 version). Actual Results: Interpretation " \t" as <new_column><new_column>. Expected Results: Interpretation " \t" as <space><new_column>. Reproducible: Always User Profile Reset: No Additional Info: Version: 25.2.0.3 (X86_64) / LibreOffice Community Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: cs-CZ (cs_CZ); UI: cs-CZ Calc: threaded
Please attach a sample source file to make the copy. It seems that the separators were not set correctly in the box.
Created attachment 199308 [details] Text file described in bug description
Test file is a1<space><tab>b1<new_line> a2<space><tab>b2<new_line> a3<space><tab>b3<new_line> I think that for test is sufficient any other text file, where are <space><tab> and multiple lines.
I was wrong. -------------------------- Copy of text a2<space><tab>b2<new_line> a3<tab>b3<new_line> (as unformatted text) is interpreted cell A2: "a2<space>", cell B2: "b2", cell A3: "a3", cell B3: "b3". -------------------------- But copy of text a2<space><tab>b2<new_line> a3<space><tab>b3<new_line> (as unformatted text) is interpreted cell A2: "a2", cell C2: "b2", cell A3: "a3", cell C3: "b3". -------------------------- And copy of text a2<tab>b2<new_line> a3<space><tab>b3<new_line> (as unformatted text) is interpreted cell A2: "a2", cell B2: "b2", cell A3: "a3<space>", cell B3: "b3". -------------------------- It seems like <space><tab> must be in all rows...
Created attachment 199332 [details] Screenshsot Please take a look at the screenshot.
Created attachment 199344 [details] Copy of one file. File you can see in hex.
Created attachment 199345 [details] Result of copy of one line. You can see. It is OK.
Created attachment 199346 [details] Copy of two lines.
Created attachment 199347 [details] Import window when inserting two lines (autodect).
Created attachment 199348 [details] Result of copy of two lines.
Created attachment 199349 [details] about
Created attachment 199350 [details] When you choose tab as separator manualy, it works
Created attachment 199353 [details] I downgraded to version 24.2.3.2. There is no autodetect option, but default values are OK.
Maybe it could be an enhancement request, with Autodetect not being a default option, but like any other option, if it was selected last time. Let's ask the UX team.
But there is inconsistency between one line copy ("<space><tab>" is interpreted as "<space><new_column>") and multi line copy ("<space><tab>" is interpreted "<new_column><new_column>"). I think that default column break SHOULD be <tab> or <space> (according to autodetect) but not both. In all cases. (Do you think that you will ever import text where you need that both <tab> and <space> is interpreted as column break? If so it is very very rare case. And you can choose it manually anyway.) And it is inconsistent with previous versions... Yah, workaround is easy: manually select only <tab> as column break. But it is annoying repeating it every copy.
Created attachment 199363 [details] Comma and tab are both interpreted as column break. 1,2<tab>3,4 5,6<tab>7,8 is interpreted as 1<new_column>2<new_column>3<new_column>4 5<new_column>6<new_column>7<new_column>8 (comma is decimal point in Czech language)
I understand that it means you need hierarchy of separators. For example "1,2<tab>3,4" should be interpreted "1,2<new_column>3,4", not "1<new_column>2<tab>3<new_column>4" (ie. <tab> has higher priority than comma). But one line copy works so. And I think that copy of one line of text and copy of multiple lines of text should be consistent.
(In reply to Martin Krsek from comment #0) > Case a: > 1. Copy text "a1 b1" (ie. "a1 \tb1") as unformatted text (Ctrl + Shift + V) > in cell A1. > 2. Result: "a1 " in A1 cell, "b1" in B1 cell. It WORKS as expected (and as > 24.2 version). > ------------------------ > Case b: > 1. Copy text "a2 b2 > a3 b3" (ie. "a2 \tb2\r\la3 \tb3") as unformatted text (Ctrl + Shift + V) in > cell A2. > 2. Result: "a2" in A2 cell, cell B2 empty, "b2" in C2 cell, "a3" in A3 cell, > cell B3 empty, "b3" in C3 cell. It IS WRONG (and different than in 24.2 > version). I can confirm the issue. And at least it is inconsistent. Regression?
I did the bibisecting with the win64-25.2 repository and got the commit 565b619d57a3b98b0826c4b49dee6606f9ae70e0. https://bugs.documentfoundation.org/show_bug.cgi?id=160582