Ask Your Question

How to turn off paste popup for calc? [closed]

asked 2017-02-21 01:38:04 +0200

nopes gravatar image

updated 2020-08-05 11:01:25 +0200

Alex Kemp gravatar image

I have tried to be rid of this nuisance for years. Created macros, remapped keys, scoured the internet for solutions, and done everything under the sun to try to excise this cancer.

There will never be a moment when I or any other person needs to save the formatting for a paste in calc. No one will ever need or make use of that popup.

Just simply paste. I dont care any longer if you paste in plaintext or formatted text. SIMPLY PASTE THE TEXT.

Each cut and paste from craigslist results in an extra break in my rhythm and unnecessary keypress. Additionally, another final reformatting because Libre somehow has a problem with plaintext. Its like Libre hates plantext and will punish you for trying to use it or work with it.




edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-05 11:01:45.292214

1 Answer

Sort by » oldest newest most voted

answered 2017-02-21 06:45:49 +0200

This question is a bright example of how to not ask questions from fellow users that compose this community-driven project. Anyone would easily see frustration, anger etc, but will have hard time understanding what exactly the asker actually wants. And if that is some psychological help that is required, then this is a wrong forum to get it.

If, however, a solution of use issue is wanted, then the best is to strip emotions from your words, and give clear information to readers: what you are trying to do (I assume, this will be "I'm trying to paste plain text from clipboard"), what problem do you see (maybe it's "I can't find a way to do it without additional step - either two clicks with mouse to choose from drop-down menu, or selecting from Paste Special dialog"), and what you've tried so far ("I tried to customize keyboard shortcuts, but didn't find "Paste as Plain Text" action; I tried to write a macro, but this is what doesn't work for me: it gives .... <here is="" my="" macro="">") etc.

Trying to answer your question, I recorded a macro, and it seems to just do the job:

sub PasteText
rem ----------------------------------------------------------------------
rem define variables
dim document   as object
dim dispatcher as object
rem ----------------------------------------------------------------------
rem get access to the document
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("")

rem ----------------------------------------------------------------------
dim args1(0) as new
args1(0).Name = "Format"
args1(0).Value = 1

dispatcher.executeDispatch(document, ".uno:PasteSpecial", "", 0, args1())

end sub

I don't know it you tried this, and if it somehow doesn't suite your needs. But I would save this macro to "My Macros"->"Standard", and assign a keyboard shortcut to it to give a try.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-02-21 01:38:04 +0200

Seen: 598 times

Last updated: Feb 21 '17