Bug 151443 - In Calc, inside a cell, during editing, cutting a section of text and pasting it into another cell removes the "line returns"
Summary: In Calc, inside a cell, during editing, cutting a section of text and pasting...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.1.3 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Formula-Bar
  Show dependency treegraph
 
Reported: 2022-10-10 00:55 UTC by TomS
Modified: 2023-05-13 11:52 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description TomS 2022-10-10 00:55:29 UTC
Description:
In Calc, I often use text in cells, with "line returns" (Shift + Return).
I can copy and paste a whole cell, and nothing changes, it's all good.
Within a cell, when I highlight a portion of text that contains a Line Return, and paste that into another cell, the line return disappears, and I end up with just one big line. So I have to insert all the Line Returns again...
(sorry, no idea about what Hardware it is)

Steps to Reproduce:
1.In a cell, type words in the input line, Press Shift + Return, type more words. 
You should end up with two lines of text.

2. In the input line, Highlight and Copy the following: highlight some words (or everything) in the first line,continue through the Shift + Return, and include some words (or everything) in the 2nd line. And Copy.

3. Choose another cell, click on the input line, and Paste.






Actual Results:
You should see that the two lines have pasted as one whole line. 


Expected Results:
This is not what I want to see, I want to see the two lines pasted as per the original copied section with the line return intact.


Reproducible: Always


User Profile Reset: No



Additional Info:
I can copy a whole cell, and paste it into another cell, and it works fine.
This only happens when I copy within the input line above the spreadsheet.
Comment 1 m_a_riosv 2022-10-10 13:09:34 UTC
It happens on the input bar.
But if you do it, editing on the destination cell (no in the input bar) it works fine for me.

I'm not sure if it is really a bug, but pasting on input bar always past without format. What does editing in the cell does.
Comment 2 eisa01 2023-03-18 10:26:59 UTC
I can confirm

Selecting text from the formular bar, copying, clicking another cell, clicking the formular bar, pasting -> Line breaks removed, space inserted instead

Setting OS to all in case this is not macOS limited

Version: 7.5.1.2 (AARCH64) / LibreOffice Community
Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129
CPU threads: 10; OS: Mac OS X 13.2.1; UI render: default; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded