https://bugs.documentfoundation.org/show_bug.cgi?id=173159
Bug ID: 173159
Summary: EDITING: Separator detection when pasting plain text
in Calc randomly produces different results from the
same input
Product: LibreOffice
Version: 26.2.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 208120
--> https://bugs.documentfoundation.org/attachment.cgi?id=208120&action=edit
Text Import dialogs showing different results
When pasting text, Calc attempts to automatically deduce separators in the Text
Import dialog but seems to randomly produce inconsistent results.
I can sometimes get it into a state where it produces the same results 100% of
the time and sometimes it goes back and forth pretty reliably.
If it gets stuck acting consistently and not reproducing the problem, selecting
a different cell seems to usually make it go back to the buggy behavior.
Minimal example that reproduces it pretty reliably on Windows 11:
Create an empty document in Notepad or Notepad++.
Enter the following 2 lines with <tab> substituted with hard tabs:
a b<tab>1
c<tab>1
Select the text from before the "a" to the end of the second "1"
Copy it to clipboard with Ctrl-C
Create an empty spreadsheet in LibreOffice Calc
Select a cell and paste with Ctrl-V. Click Cancel in the Text Import window
and paste again. Repeat as necessary, and note that sometimes the separator
options will sometimes detect tab separators and sometimes won't detect any
separators.
--
You are receiving this mail because:
You are the assignee for the bug.
