Bug 154006 - Calc: Shift+Ctrl+Alt+V does not copy unformatted text in cell selected for typing
Summary: Calc: Shift+Ctrl+Alt+V does not copy unformatted text in cell selected for ty...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Shortcuts-Accelerators Paste-Special-Unformatted
  Show dependency treegraph
 
Reported: 2023-03-06 11:53 UTC by ThomasU
Modified: 2024-03-10 16:37 UTC (History)
3 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 ThomasU 2023-03-06 11:53:33 UTC
Description:
When a spreadsheet cell is selected for typing in, Shift+Ctrl+Alt+V does not work. This is a problem if one wants to paste text inside a cell that already contains text.
What only works but overwrites text already contained in a cell is to click only once on a cell and type Shift+Ctrl+Alt+V.


Steps to Reproduce:
1. Copy text from somewhere using ctrl+C
2. Go to Calc. Double click on cell to enable text entry with cursor blinking inside the cell
3. Type Shift+Ctrl+Alt+V
4. Notice that it types "V" inside the cell instead of copying text unformatted
5. Click once on another cell so that the cursor does not blink inside. Type Shift+Ctrl+Alt+V and notice that the text gets copied, but it will overwrite other text that may already be in the cell.

Actual Results:
Types "V" instead of copying text 

Expected Results:
Copies unformatted text according to Shift+Ctrl+Alt+V shortcut


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.4.4.2 / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 8; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: de-CH (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.4.4-0ubuntu0.22.10.2
Calc: threaded
Comment 1 Stéphane Guillou (stragu) 2023-03-20 17:33:15 UTC
I reproduce the issue, thank you for reporting.

Version: 7.4.6.2 / LibreOffice Community
Build ID: 5b1f5509c2decdade7fda905e3e1429a67acd63d
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-US (en_AU.UTF-8); UI: en-US
Calc: threaded

and also in a recent trunk build, and already in 6.0.0.3.

Noting that using the menu works: Edit > Paste Special > Paste Unformatted Text
Comment 2 ady 2023-03-20 19:19:36 UTC
Once you are in edit mode, you don't need [CTRL]+[ALT]+[SHIFT]+[V] in order to paste as Unformatted Text. In most (and possibly all) cases, once you are in edit mode, a simple [CTRL]+[V] would suffice and get you the same result.

This should be the same for any alternative method to get into edit mode: double click on the cell, or F2, or clicking on the formula bar’s inputwin.
Comment 3 Stéphane Guillou (stragu) 2023-03-20 21:05:59 UTC
(In reply to ady from comment #2)
> Once you are in edit mode, you don't need [CTRL]+[ALT]+[SHIFT]+[V] in order
> to paste as Unformatted Text. In most (and possibly all) cases, once you are
> in edit mode, a simple [CTRL]+[V] would suffice and get you the same result.
> 
> This should be the same for any alternative method to get into edit mode:
> double click on the cell, or F2, or clicking on the formula bar’s inputwin.

I also thought that, Ady, but try copying formatted text from LibreOffice itself (from Writer or even Calc): you'll see that even in edit mode inside the cell, the format comes across. So a definite bug, in my opinion. We need consistency here.