Bug 123375 - Multi-line Calc cell split into one cell per original cell line when deleted and copied using Ctrl-X and Ctrl-V
Summary: Multi-line Calc cell split into one cell per original cell line when deleted ...
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.5.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Paste
  Show dependency treegraph
 
Reported: 2019-02-11 21:18 UTC by johlson
Modified: 2023-05-25 09:29 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
screenshot (89.01 KB, image/png)
2019-02-11 21:20 UTC, johlson
Details
screenshot (86.82 KB, image/png)
2019-02-11 21:20 UTC, johlson
Details

Note You need to log in before you can comment on or make changes to this bug.
Description johlson 2019-02-11 21:18:55 UTC
Description:
See summary and attached screenshots

Steps to Reproduce:
1.Create a multi-line cell in Calc.
2.Use Ctrl-X to copy and delete data created in Step 1.
3.Use Ctrl-V to place data in any cell other than original.

Actual Results:
Each line of the multi-line data is placed in a separate cell, beginning in the chosen cell and continued down.

Expected Results:
All data from original cell should be copied into the one chosen cell.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Comment 1 johlson 2019-02-11 21:20:14 UTC
Created attachment 149173 [details]
screenshot
Comment 2 johlson 2019-02-11 21:20:42 UTC
Created attachment 149174 [details]
screenshot
Comment 3 m_a_riosv 2019-02-11 22:05:09 UTC
I can't repro with
Version: 6.1.4.2 (x64)
Build ID: 9d0f32d1f0b509096fd65e0d4bec26ddd1938fd3
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: es-ES (es_ES); Calc: group
neither
Version: 6.2.1.0.0+ (x64)
Build ID: dfa1f1f872c418e89757a3985979b79e94c12fcc
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US
Calc: threaded
Comment 4 johlson 2019-02-12 00:38:10 UTC
Please refer to Bug 123374 for steps to create the original cell which was being deleted and copied.
Comment 5 Durgapriyanka 2019-02-14 17:53:36 UTC
Thank you for reporting the bug. I can reproduce the bug in

Version: 6.3.0.0.alpha0+
Build ID: b6b28931435e44aca92b8c0e1659f701e3ed1a87
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-01-30_06:57:04
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 6 Roman Kuznetsov 2019-02-17 06:14:58 UTC
don't repro in

Version: 6.3.0.0.alpha0+
Build ID: b45289e48e0f354b9996e2846dd041db4a9947ce
CPU threads: 4; OS: Linux 4.18; UI render: default; VCL: kde5; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-02-08_12:51:03
Locale: ru-RU (ru_RU.UTF-8); UI-Language: en-US
Calc: threaded

Durgapriyanka , are you sure in confirming of this report?
Comment 7 Buovjaga 2019-02-17 15:40:49 UTC
(In reply to johlson from comment #0)
> 2.Use Ctrl-X to copy and delete data created in Step 1.

Crucial to repro: select the text *while in editing mode* before copying/cutting and paste while not in editing mode. If pasting in editing mode, the text loses the line breaks.

Should we call this a bug, though? Having it this way gives us two (pretty logical) behaviours - pasting to one cell per multiple lines is surely useful sometimes. I guess it might not be trivial to change the behaviour.
Comment 8 m_a_riosv 2019-02-17 21:57:08 UTC
(In reply to Buovjaga from comment #7)
> (In reply to johlson from comment #0)
> > 2.Use Ctrl-X to copy and delete data created in Step 1.
> 
> Crucial to repro: select the text *while in editing mode* before
> copying/cutting and paste while not in editing mode. If pasting in editing
> mode, the text loses the line breaks.
> 
> Should we call this a bug, though? Having it this way gives us two (pretty
> logical) behaviours - pasting to one cell per multiple lines is surely
> useful sometimes. I guess it might not be trivial to change the behaviour.

+1
Comment 9 johlson 2019-05-22 17:41:29 UTC
I am not clear as to the status of this report. I would like to reiterate that there is a bug. 

I don't understand what the *while in editing mode* comment is about. What I am try to do is edit the sheet, a logical impossibility in read-only mode. further don't understand what the two behaviours might be.

From my perspective, it is a virtually universal rule in Windows that copy and paste means taking text or whatever from one place and duplicating it in another without alteration. Surely taking text from one cell and splitting it into multiple cells does not meet that standard.  

Finally, whether killing the bug takes a flyswatter or an atomic bomb is not the issue. What matters is getting the bug killed.
Comment 10 Buovjaga 2019-05-22 18:23:42 UTC
(In reply to johlson from comment #9)
> I am not clear as to the status of this report. I would like to reiterate
> that there is a bug. 
> 
> I don't understand what the *while in editing mode* comment is about. What I
> am try to do is edit the sheet, a logical impossibility in read-only mode.
> further don't understand what the two behaviours might be.

Edit mode is when you either double-click a cell or press F2, so you see the text cursor blinking.
Comment 11 QA Administrators 2021-05-22 04:23:18 UTC Comment hidden (obsolete)
Comment 12 Sophie Sipasseuth 2023-05-22 08:21:54 UTC Comment hidden (obsolete)
Comment 13 Buovjaga 2023-05-25 09:18:28 UTC
(In reply to Buovjaga from comment #7)
> (In reply to johlson from comment #0)
> > 2.Use Ctrl-X to copy and delete data created in Step 1.
> 
> Crucial to repro: select the text *while in editing mode* before
> copying/cutting and paste while not in editing mode. If pasting in editing
> mode, the text loses the line breaks.

Pasting in editing mode no longer makes the text lose the line breaks, so now all behaviours seem acceptable. I still don't think this is a bug.

Arch Linux 64-bit, X11
Version: 7.5.3.2 (X86_64) / LibreOffice Community
Build ID: 50(Build:2)
CPU threads: 8; OS: Linux 6.3; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
7.5.3-1
Calc: CL threaded
Comment 14 Eike Rathke 2023-05-25 09:29:09 UTC
There's no bug. If you cut content while the cell is in edit mode you end up with several lines of text in the clipboard. If you paste that onto a cell that is not in edit mode you paste the multi-line clipboard content like other multi-line text that is distributed over several cells.
So either cut and paste while not in edit mode, or cut and paste while in edit mode for both to get an identical result.