Description: I had to override the default ctrl+v action to "paste unformatted," because the keyboard shortcut is a 4-finger nerve pinch that is impossible to alternate with ctrl+shift+c (copy from terminal). Steps to Reproduce: 1. Copy single number from web browser, terminal, etc. 2. Paste into calc spreadsheet. Actual Results: Cell format gets clobbered by random font, background color, whoever knows what else from source application. Expected Results: The number, and *just* the number, appears in the spreadsheet cell, in the same font as if it were typed there by a human person, and takes on whatever format already exists for that cell, such as conditional color scales. There is basically only one use case for rich paste from an external application into a spreadsheet, which is pasting an entire HTML table from a web browser. Fortunately, that situation is one you should be able to detect and handle accordingly. Reproducible: Always User Profile Reset: No Additional Info: Version: 24.8.4.2 (X86_64) Build ID: 480(Build:2) CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: kf6 (cairo+wayland) Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
So, keyboard launch the context menu? E.g. <Shfit>+<F10> on Windows Then the accelerators (as localized) in sequence? an <s> for Paste _Special a <t> for Text Watch the <u> (unformatted text) rather than the <t> (text), as that pops-up the full text import dialog. Likewise for a second <s> (paste special) as that pops-up the paste special dialog that requires a mouse click to click one of the presets, checkboxes, or radiobuttons.
If I'm reading you correctly, you're talking about a 3-shortcut command sequence that begins with shift+F10? That's even worse than ctrl+alt+shift+v. What I am suggesting is that "paste unformatted" should be the DEFAULT ACTION for ctrl+v IF the clipboard source is an external app. Ain't nobody copy-pasting text out of a web browser for the purpose of getting it in the font from the website instead of the font their document is already in.
[Automated Action] NeedInfo-To-Unconfirmed
The "simple" default .uno:Paste assigned to <Ctrl>+V is overloaded with good actions for import depending already on source. So alternatively, just customize the Calc instance of <Ctrl>+V yourself? It then is persistent across sessions and would not upset work flows of others. The default global for <Ctrl>+V is "Paste" (.uno:Paste) across modules, with the contorted "Paste Unformatted Text" (.uno:PasteUnformatted) assigned just to the Calc module's <Ctrl><Alt><Shift>+V But as folks understand they can customize, equally viable defaults could be assigned to the <Ctrl>+V in Calc. So depending on a users workflow needs, each of: .uno:PasteAsLink, .uno:PasteOnlyFormula, .uno:PasteOnlyValue, .uno:PasteOnlyText, .uno:InsertContents (Paste Special-Insert), .uno:PasteSpecial (def Ctrl-Shift-V), .uno:PasteTransposed, or .uno:PasteUnformatted are equally viable customizations to assign to <Ctrl>+V in the Calc module. Those UNO are to basis of the button/check-box actions on the pop-up paste special dialog. Sustaining the global default assignment of.uno:Paste, and *NOT* assigning a default alternative to Calc's use of the <Ctrl>+V Paste still makes more sense for the majority of users, leaving customization up to each. -1 and => WF
Why not provide an option what to do on ctrl+v? Defaults to Paste but could become Paste Unformatted. Drawback is clearly that we spoil our own customization.
We discussed the topic in the design meeting. There are plenty of UNO commands to customize, adding an option to either paste or paste special via ctrl+V sounds like over-engineering, and would break the user customization anyway. So we decided to not recommend this proposal.