Bug 118610 - Text is wrapped when pasting text from another source into a Calc sheet with wrap text disabled.
Summary: Text is wrapped when pasting text from another source into a Calc sheet with ...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-07-07 14:27 UTC by Shawnix
Modified: 2018-07-07 17:02 UTC (History)
1 user (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 Shawnix 2018-07-07 14:27:05 UTC
Description:
Select the entire document, then remove the check next to wrap text.
Copy text from a browser or from a text editor that is wider than the cell.
Notice that the pasted text is wrapped.

EDITING FORMATTING

Steps to Reproduce:
1. Select the entire document, then remove the check next to wrap text.
2. Copy text from a browser or from a text editor that is wider than the cell.
3. Notice that the pasted text is wrapped.

Actual Results:
The text that I pasted was wrapped, despite having deselected wrap text prior to pasting the text.

Expected Results:
The text should have been pasted without wrapping the text.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.0.3.2
Build ID: 1:6.0.3-0ubuntu1
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); Calc: group
Comment 1 V Stuart Foote 2018-07-07 15:32:44 UTC
(In reply to Shawnix from comment #0)
> Description:
> Select the entire document, then remove the check next to wrap text.

We'll assume you do mean on the Calc sheet and Format -> Cells -> Alignment

> Copy text from a browser or from a text editor that is wider than the cell.
> Notice that the pasted text is wrapped.
> ...

No, when you paste you must Paste Special -> Unformatted text to allow the cell format to assert.  The default Paste intentionally picks up formatting (if any) from the clipboard held item, and ignores formatting applied to the sheet/cell.
Comment 2 Shawnix 2018-07-07 17:02:31 UTC
(In reply to V Stuart Foote from comment #1)
> 
> We'll assume you do mean on the Calc sheet and Format -> Cells -> Alignment
> 

I meant on the Properties sidebar, but I assume that they do the same thing.

> No, when you paste you must Paste Special -> Unformatted text to allow the
> cell format to assert.  The default Paste intentionally picks up formatting
> (if any) from the clipboard held item, and ignores formatting applied to the
> sheet/cell.

Although I may have no choice but to (begrudgingly) accept your response, it still doesn't make any sense that copying text from a text editor would produce this action.  After all, it is plain ASCII text without any formatting.

Replacing the formatting when pasting makes it necessary to perform additional steps to make that cell conform with the rest of the page.  These additional steps don't really make sense.  It's bad enough that pasting is plagued by the requirement to address the dreaded "Import Options" dialog that should have been eliminated when it was reported as Bug 65872 over 5 years ago.  Pasting should be as simple as pasting.