Bug 151443

Summary: In Calc, inside a cell, during editing, cutting a section of text and pasting it into another cell removes the "line returns"
Product: LibreOffice Reporter: TomS <info>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: minor CC: buzea.bogdan, miguelangelrv
Priority: medium    
Version: 7.3.1.3 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108660    

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