https://bugs.documentfoundation.org/show_bug.cgi?id=167486
Bug ID: 167486
Summary: Paste into formula bar should keep newlines
Product: LibreOffice
Version: 25.2.4.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
This concerns what happens when newlines are pasted into Calc's Formula Bar.
I have seen pasting into the ***formula bar*** recommended somewhere as a way
to Paste (Ctrl+V) unformatted without the contortions of pressing
Ctrl+Alt+Shift. This technique has the Paste Unformatted effect in both Calc
and Excel, but unfortunately is problematic in Calc when the text contains
newlines.
I contend the result should basically be equivalent to entering Cell Edit Mode
followed by Paste Unformatted, in regards to how any CR/LF/or any other
expression of newline in the data is handled.
Steps to Reproduce:
1. Copy these three lines to the clipboard:
a
b
c
2. In Calc, click on the formula bar.
3. Paste (Ctrl+V)
Actual Results:
The data is pasted all on one line, with newlines replaced by single spaces.
Expected Results:
Match Excel behavior: The newlines are pasted.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 25.2.4.3 (X86_64) / LibreOffice Community
Build ID: 33e196637044ead23f5c3226cde09b47731f7e27
CPU threads: 12; OS: Windows 10 X86_64 (10.0 build 19045); UI render:
Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
