default type and setting for pasting

users
#21

Well, I just used CTRL+ALT+Shift+V and that pasted what was on my clipboard into a
document I had open. And when I open the Undo function it says "Paste clipboard". So,
I would say no, that will not work for anything within the control of the items of
the Paste Special window.
Roxy

Yeah, Tom. I think it would depend both on the OS, and the mouse capabilities. But
the problem, even with this, is that, as far as I know there isn't any KEY
COMBINATION for the various OPTIONS WITHIN PASTE SPECIAL.

Did you try CTRL+ALT+Shift+V, which was suggested in another post?

Larry

#22

Dear Lee

I thought I would give this a go.

I seems that "Paste" pastes everything

and "Past Special" just what's on the tick list

so ctrl +v (up comes the list - delete all the ticks but leave text and numbers)

Now from copy

ctrl + V gives formatted

ctrl + v +ok gives unformatted

regards

John B
LO 3.3.3

#23

According to what I just did, Ctrl+Alt+Shift+V pasted what was on the clipboard to my
document. If I copied something with html in it, like from a web page, it copied
everything into my document. Just like using plain old paste???
Since I know very little about macros, I don't know about #2, but would like to know
just exactly how you would use all that in a key combination???
Oh, yes, I see. That calls the Paste Special command, which opens the selection
window; then U selects unformatted text from the window, and Enter does it. Now if
Lee knows how to write that Macro, it should be good to go. Excellent!!!
I would like to have a copy of that Macro!!! I use that all the time.
Roxy

Hi,

[...] But
the problem, even with this, is that, as far as I know there isn't any KEY
COMBINATION for the various OPTIONS WITHIN PASTE SPECIAL. There is the key
combination that will "bring up" Paste Special, but once that window is open YOU

HAVE

TO MANUALLY SELECT WHICH OF THOSE OPTIONS YOU WANT. There is no KEY COMBINATION FOR
EACH OF THOSE OPTIONS. So how would you set anything - a mouse movement, a macro,

etc

- to choose each one of those options???

You can use the following key combinations for 'Paste unformatted text':

(1) Default: Ctrl+Alt+Shift+V

(2) Ctrl+Shift+V, U, Enter

(3) Record (2) as macro, and a assign a user-defined shortcut key
[my shortcut key: Ctrl+U]

mjk

#24

Hi,

According to what I just did, Ctrl+Alt+Shift+V pasted what was on the clipboard to my
document. If I copied something with html in it, like from a web page, it copied
everything into my document. Just like using plain old paste???
Since I know very little about macros, I don't know about #2, but would like to know
just exactly how you would use all that in a key combination???
Oh, yes, I see. That calls the Paste Special command, which opens the selection
window; then U selects unformatted text from the window, and Enter does it. Now if
Lee knows how to write that Macro, it should be good to go. Excellent!!!
I would like to have a copy of that Macro!!! I use that all the time.
Roxy

Addendum (macro):
[OOo community forum –
User community support forum for OpenOffice.org, LibreOffice,
StarOffice, and NeoOffice]
Re: [Solved] How to paste unformatted by default?
http://user.services.openoffice.org/en/forum/viewtopic.php?f=7&t=16978&p=113679#p113679

#25

John, what OS are you using?
For me, Ctrl+V is "Paste" only, and does not bring up any list and pastes everything.
In Windows, no "list" is brought up where you can delete any ticks and just leave
what you want. By using Ctrl+SHIFT+V I get Paste Special, and that brings up a WINDOW
where you HAVE TO highlight what you want to paste. You cannot delete any of the
items in the window!!!
In Windows, you would have to use the Macro, just previously mentioned to accomplish
what Lee wants to do.
Roxy

Dear Lee

I thought I would give this a go.

I seems that "Paste" pastes everything

and "Past Special" just what's on the tick list

so ctrl +v (up comes the list - delete all the ticks but leave text and
numbers)

Now from copy

ctrl + V gives formatted

ctrl + v +ok gives unformatted

regards

John B
LO 3.3.3

#26

Roxy Robinson <rocmar62@ranchwireless.com> writes:

Again, I don't have, nor never had the problem you talk about of where
your copied material gets pasted.

Then how did you make it so that it´s pasted at the cursor rather then
at the mouse pointer?

If I am copying, say, an address from a web page to a spreadsheet, I
select and copy the material from the web page. Usually, I have
already selected the cell in the spreadsheet where I want it to go and
this has "highlighted" that cell - bolded its outline. When I "move"
to the spreadsheet that cell is still selected.

Yes, the selected/highlighted cell would be the equivalent of the cursor
in writer.

I then use Paste Special > Unformatted Text and whatever I copied from
the web page falls right into the cell that I had previously
selected.

Having to go such a detour is exactly what makes pasting in LO so
troublesome that I rather type for copying over some short lines of text
than pasting them. It´s annoying that I have to type them, and it would
be even more annoying if I had to go through the lengthy, awful
procedure of going through the menu and through the pop-up window and
through selecting a way to paste and to click on ok to finally(!) get
the text pasted. I tried it, and it sucks, so I type instead.

Why can´t one just set a default way of pasting instead of having to
choose one each and every time just because the unchangeable default of
LO is 99.99999% of the time not what one wants?

I really don't know how you could make that any simpler.

See <87pqm87kth.fsf@yun.yagibdah.de>:

#27

Roxy Robinson <rocmar62@ranchwireless.com> writes:

Well, as far back as I can remember that is how Paste Special has
worked, and in whatever programs I have ever used. Its not a bug, its
the way it works.

It´s only getting in the way of copying and pasting. The problem could
very easily be solved by letting users set a default way to paste
instead of having to select one each and every time they want to paste.

In some cases you might want to bring all the "info" to be pasted and

Yes, and it is good that you can. It is bad that this is a default that
cannot be changed.

in others, as in your case, and in most of mine, you only want
unformatted text.

So if you could make it the default that unformatted text is pasted, you
would probably do that, wouldn´t you? :slight_smile: I would.

#28

Tom Davies <tomdavies04@yahoo.co.uk> writes:

Hi :slight_smile:
Gnome has some fairly sophisticated "clipboard managers". It might be worth
googling for "clipboard managers" to see if there is something suitable for your
OS. In gnu&linux just search in your package manager.

Good idea, thanks :slight_smile: Is there one you´d recommend for KDE?

#29

Dear Roxy

I am using "My Daughter rang for me to pick her up from the station" - OS. and I did not check it properly

Please allow me 1 mistake per year :-[ .

The sequence of my events are and my interpretation of Lees request is:

1st, to Copy, highlight the text from anywhere or Cell (or cells) with the mouse (right click, copy) or ctrl+c

My shortened version of this was "from copy"

You then click on the cell on the spread sheet you want it to go in (the mouse can go anywhere after that). - which I forgot to mention

Then its:- ctrl+shift+V, (or paste special) then ok (you are so right)

on my 3.3.3 the paste special brings up a window with a tick list and as long as only the text & numbers are ticked, it pastes in the default format. Sorry I said delete the ticks- maybe I should have said "untick " all the other ticked boxes

I know nothing about macros. I thought it was some way of programming a key to type "yours faithfully" at the bottom of letters for slow typists - obviously not!

So:-

from copy

ctrl + V>> gives formatted

ctrl+shift+v, then ok>> gives unformatted with only text& numbers ticked

regards

John B

#30

Tom Davies <tomdavies04@yahoo.co.uk> writes:

Hi :slight_smile:
Gnome has some fairly sophisticated "clipboard managers". It might be worth
googling for "clipboard managers" to see if there is something suitable for your
OS. In gnu&linux just search in your package manager.

Ok, klipper can do stuff with the contents of the clipboard, like run a
program. Do you have any idea what I should have it do so that pasting
text into LO pastes unformatted text?

There don´t seem to be a lot of clipboard managers in Debian testing ...

#31

Tom Davies <tomdavies04@yahoo.co.uk> writes:

Anyway, how do I make it so that unformatted text is pasted with the
middle mouse button?

Hi :slight_smile:
It might be possible to do that at the OS level. Which OS are you using; a
Windows, Ubuntu, another gnu&linux, Bsd or Mac? Usually the middle button or
clicking on the scroll wheel, is called the 3rd mouse button.

Usually, the middle mouse button pastes. I´ve changed this default[1],
but that isn´t relevant here.

Pasting with the mouse button designated for pasting[2] works just
fine. Only LO screws it up because you cannot change its default way of
pasting. Or can you?

[1]: If you care (for a Logitech Trackman Marble FX):

,---- [ /etc/X11/xorg.conf ]

[...]
Section "InputDevice"
    Identifier "Mouse0"
    Driver "mouse"
    Option "Protocol" "auto"
    Option "Device" "/dev/input/mice"
    Option "Emulate3Buttons" "no"
    Option "ZAxisMapping" "4 5"
    Option "11"
    Option "EmulateWheel" "True"
    Option "EmulateWheelButton" "8"
    Option "EmulateWheelClickToo" "0"
EndSection
[...]

`----

,---- [ and in a script: ]

xinput set-button-map "PS2++ Logitech TrackMan" 1 2 8 4 5 6 7 3 9 10 1 2 8 4 5 6 7 3 9 10
xinput -set-prop "PS2++ Logitech TrackMan" "Evdev Wheel Emulation Button" 3
xinput -set-prop "PS2++ Logitech TrackMan" "Evdev Wheel Emulation" 1

`----

[2]: Afair it´s button 8, but it´s been a while since I set it up, so
     I´m not sure which one it was. --- Hmm, looking at it, I probably
     don´t need to change the button map when I change it in xorg.conf
     to button 3 ...

#32

To copy and paste some text, I move the mouse pointer over the text
while pressing the left button. To paste, I move the mouse pointer over
the window I want to paste into and press the middle button to have the
text inserted where the cursor is.

It is as simple and efficient as that. It doesn´t work with LO (and some
other misdesigned applications) because the text isn´t inserted where
the cursor is but, illogically, where the mouse pointer happens to
be.

[...]

Having to go through menus and pop-up windows and having to select some
options is way too much fuss and horribly inefficient. Switching back

[...]

I
really don't know how you could make that any simpler. I have been doing this type
thing over and over and over for well over 10 years and have never had the problem
you state - and that goes all the way back to Win98 and before. You could use just
Paste, but you have the possibility off bringing along web formatting that you are
not aware of and could become quite a hassle down the road in your spreadsheet. As
you can see when you use Paste Special there can be up to 3 or 4 different ways to
paste. To do this in one step they would have to add a "button" for each of those
ways of pasting.

This is not about "Paste" buttons. From your reference to Windows 98,
and from your message headers (which tell me you're using Pocomail, a
mail client which (according to wikipedia) is windows only), you're
using Windows.

The way to copy and paste lee described (and that I'm also used to)
doesn't exist in Windows. I've only seen it in X, a UNIX graphical
interface, commonly used with GNU/Linux and other unices.

It does not involve right-clicks to get a context menu to copy, nor
clicking into copy buttons, nor having to switch between keyboard and
mouse just to copy and paste.

It's just like lee described it, you select the text you want to copy,
and then you click with your mouse middle button in the application you
want to copy the text to.

The problem here is that, unlike other applications where the middle
click pastes the text where the text cursor is, LibO pastes it where the
mouse pointer is (or as nearest as possible, if there's no text where
the pointer is), making it harder to predict where the text will go and
even if you try to point at the right place it might go wrong.

I hope this helps you understand what exactly is this about. I usually
call this "selection copy-paste", I don't know what other people call
it.

Also, there's something else that is annoying: LibO does *not* merge
these two sources of data to paste. Selection and clipboard are kept
apart.

This means you *can't* use Paste special to paste stuff as unformatted
text -- that will use what's in the clipboard, and that's something
different.

#33

I don't know what is so difficult or time consuming. And I certainly don't agree with
typing it in versus copying and pasting. IMHO, you would have to be an extremely fast
typist to accomplish what I just finished by typing everything in. I had 10 separate,
old spreadsheets from 10 graduating classes from my high school. I copied and pasted
that information - names, spouses names, full mailing addresses, landline phone, cell
phone and email addresses. Actually, most of these were not in spreadsheet form. Most
were in Word form, some in Word tables, some were hard copies I scanned in, etc.
I entered all of those into one large spreadsheet, exactly 500 names long, by copying
and pasting - unformatted text. Now, there is a little easier, quicker way to do the
paste - rather than using the key commands or the Edit Menu. If you use the standard
Toolbar there is an icon for cut, copy, & paste. Beside the Paste icon is a down
arrow. Click the down arrow and select "unformatted text", and it pastes unformatted
text. That's the way I do it and I think that's pretty dang simple, and I know it was
faster than I could have typed all that info in. I know I wouldn't win any typing
speed contests, but then I'm not a slouch either.
You could use the Macro by assigning it to something like Ctrl+U, as suggested
elsewhere, but since I would already be using my mouse to select the text, I think
clicking the Paste Icon Down Arrow on the toolbar would be just as easy and just as
fast as letting go of the mouse and hitting Ctrl+U. Hmmmmmmm.
Roxy

Roxy Robinson <rocmar62@ranchwireless.com> writes:

Again, I don't have, nor never had the problem you talk about of where
your copied material gets pasted.

Then how did you make it so that it´s pasted at the cursor rather then
at the mouse pointer?

If I am copying, say, an address from a web page to a spreadsheet, I
select and copy the material from the web page. Usually, I have
already selected the cell in the spreadsheet where I want it to go and
this has "highlighted" that cell - bolded its outline. When I "move"
to the spreadsheet that cell is still selected.

Yes, the selected/highlighted cell would be the equivalent of the cursor
in writer.

I then use Paste Special > Unformatted Text and whatever I copied from
the web page falls right into the cell that I had previously
selected.

Having to go such a detour is exactly what makes pasting in LO so
troublesome that I rather type for copying over some short lines of text
than pasting them. It´s annoying that I have to type them, and it would
be even more annoying if I had to go through the lengthy, awful
procedure of going through the menu and through the pop-up window and
through selecting a way to paste and to click on ok to finally(!) get
the text pasted. I tried it, and it sucks, so I type instead.

Why can´t one just set a default way of pasting instead of having to
choose one each and every time just because the unchangeable default of
LO is 99.99999% of the time not what one wants?

I really don't know how you could make that any simpler.

See <87pqm87kth.fsf@yun.yagibdah.de>:

#34

See my later post on how I do it using the toolbar Paste Drop Down Arrow.
Pretty simple, pretty easy, pretty quick. Don't how you could get much better with
all 3 of those - simple, easy, quick.
Roxy

Roxy Robinson <rocmar62@ranchwireless.com> writes:

Well, as far back as I can remember that is how Paste Special has
worked, and in whatever programs I have ever used. Its not a bug, its
the way it works.

It´s only getting in the way of copying and pasting. The problem could
very easily be solved by letting users set a default way to paste
instead of having to select one each and every time they want to paste.

In some cases you might want to bring all the "info" to be pasted and

Yes, and it is good that you can. It is bad that this is a default that
cannot be changed.

in others, as in your case, and in most of mine, you only want
unformatted text.

So if you could make it the default that unformatted text is pasted, you
would probably do that, wouldn´t you? :slight_smile: I would.

#35

Roxy Robinson <rocmar62@ranchwireless.com> writes:

Tom,
I could be wrong here - am just going by what I seem to remember. It seems that the
options available depend upon what is selected. I say that because I think I remember
that the same options are not always there.

Yes, I think you´re right. It´s another thing making pasting very
difficult. When I still tried, I think I was confused all the time
because the option for "unformatted text" kept changing its position in
the pop-up window so that many times, I clicked on an option I didn´t
want and hit enter and then had to undo and start over.

In other words, if there is absolutely no html within the selection,
that option may not be in the popup window.

Then two options may be needed:

1.) default pasting type

2.) warn or ask or silently fall back to another option in case there´s
    nothing to paste which is of the default type

#36

"Manfred J. Krause" <courrier.oou.fr.mjk@googlemail.com> writes:

Hi,

Oh, yes, I see. That calls the Paste Special command, which opens the selection
window; then U selects unformatted text from the window, and Enter does it. Now if
Lee knows how to write that Macro, it should be good to go. Excellent!!!

The macro recorder is grayed out, is that normal?

Addendum (macro):
[OOo community forum –
User community support forum for OpenOffice.org, LibreOffice,
StarOffice, and NeoOffice]
Re: [Solved] How to paste unformatted by default?
http://user.services.openoffice.org/en/forum/viewtopic.php?f=7&t=16978&p=113679#p113679

Perhaps I can figure out tomorrow how to make use of it, thanks :slight_smile: How
would I bind it to the mouse button I use for pasting?

And once that works, how would I make it so that the pasted text is
inserted at the cursor position and not where the mouse pointer happens
to be?

#37

John,
I use Windows7-64. In my version of LO (3.3.3), and all previous versions of OO & LO
I have used thus far I also get a window popup when I select Paste Special (it
doesn't make any difference how you select it). In my window there is no option to
"tick" any boxes - there are no boxes next to whatever options are in the window. In
my window all available options are just listed and you have to select/highlight
which option you want. Then you hit OK.
But I recently found a much easier and quicker way of accomplishing the same thing. I
have used the paste button on the toolbar hundreds of times. While I was copying
address info into a spreadsheet recently I notice the drop down arrow next to the
Paste Icon on the toolbar. I clicked on the arrow and there are the same options as
in that popup window. So now when I want to paste anything as "unformatted", I click
that down arrow, click that option, and its done. Pretty easy and quick as far as I'm
concerned.
Roxy

Dear Roxy

I am using "My Daughter rang for me to pick her up from the station" -
OS. and I did not check it properly

Please allow me 1 mistake per year :-[ .

The sequence of my events are and my interpretation of Lees request is:

1st, to Copy, highlight the text from anywhere or Cell (or cells) with
the mouse (right click, copy) or ctrl+c

My shortened version of this was "from copy"

You then click on the cell on the spread sheet you want it to go in
(the mouse can go anywhere after that). - which I forgot to mention

Then its:- ctrl+shift+V, (or paste special) then ok (you are so right)

on my 3.3.3 the paste special brings up a window with a tick list and as
long as only the text & numbers are ticked, it pastes in the default
format. Sorry I said delete the ticks- maybe I should have said "untick
" all the other ticked boxes

I know nothing about macros. I thought it was some way of programming a
key to type "yours faithfully" at the bottom of letters for slow typists
- obviously not!

So:-

from copy

ctrl + V>> gives formatted

ctrl+shift+v, then ok>> gives unformatted with only text& numbers ticked

regards

John B

#38

Use the toolbar Paste "drop down arrow". Simple, quick, easy.
Roxy

Tom Davies <tomdavies04@yahoo.co.uk> writes:

Hi :slight_smile:
Gnome has some fairly sophisticated "clipboard managers". It might be worth
googling for "clipboard managers" to see if there is something suitable for your
OS. In gnu&linux just search in your package manager.

Ok, klipper can do stuff with the contents of the clipboard, like run a
program. Do you have any idea what I should have it do so that pasting
text into LO pastes unformatted text?

There don´t seem to be a lot of clipboard managers in Debian testing ...

#39

John B <johnb@email2.me> writes:

Now from copy

ctrl + V gives formatted

ctrl + v +ok gives unformatted

Hm, I just tried that, neither C-v nor C-V do anything. According to the
menu, something should be pasted when pressing these keys ... Perhaps
it´s messed up now from my trying to change the keybindings earlier?
Doesn´t matter, I never use that anyway and do it with Shift-Insert
instead when not using the mouse. Unfortunately, Shift-Insert doesn´t
paste unformatted text by default ...

#40

I have stated several times what OS I use. I have no idea what others are using
unless they say so. That goes back to my suggestions that there should be a separate
list for Windows, Mac, Linux-type users. Also, my suggestion that Lee use the toolbar
Paste button drop down arrow to do the pasting will certainly make the pasting part
simple, quick, and easy. I just found that little drop down button about 6 months ago
and it makes this process quite quick.
Roxy

To copy and paste some text, I move the mouse pointer over the text
while pressing the left button. To paste, I move the mouse pointer over
the window I want to paste into and press the middle button to have the
text inserted where the cursor is.

It is as simple and efficient as that. It doesn´t work with LO (and some
other misdesigned applications) because the text isn´t inserted where
the cursor is but, illogically, where the mouse pointer happens to
be.

[...]

Having to go through menus and pop-up windows and having to select some
options is way too much fuss and horribly inefficient. Switching back

[...]

I
really don't know how you could make that any simpler. I have been doing this type
thing over and over and over for well over 10 years and have never had the problem
you state - and that goes all the way back to Win98 and before. You could use just
Paste, but you have the possibility off bringing along web formatting that you are
not aware of and could become quite a hassle down the road in your spreadsheet. As
you can see when you use Paste Special there can be up to 3 or 4 different ways to
paste. To do this in one step they would have to add a "button" for each of those
ways of pasting.

This is not about "Paste" buttons. From your reference to Windows 98,
and from your message headers (which tell me you're using Pocomail, a
mail client which (according to wikipedia) is windows only), you're
using Windows.

The way to copy and paste lee described (and that I'm also used to)
doesn't exist in Windows. I've only seen it in X, a UNIX graphical
interface, commonly used with GNU/Linux and other unices.

It does not involve right-clicks to get a context menu to copy, nor
clicking into copy buttons, nor having to switch between keyboard and
mouse just to copy and paste.

It's just like lee described it, you select the text you want to copy,
and then you click with your mouse middle button in the application you
want to copy the text to.

The problem here is that, unlike other applications where the middle
click pastes the text where the text cursor is, LibO pastes it where the
mouse pointer is (or as nearest as possible, if there's no text where
the pointer is), making it harder to predict where the text will go and
even if you try to point at the right place it might go wrong.

I hope this helps you understand what exactly is this about. I usually
call this "selection copy-paste", I don't know what other people call
it.

Also, there's something else that is annoying: LibO does *not* merge
these two sources of data to paste. Selection and clipboard are kept
apart.

This means you *can't* use Paste special to paste stuff as unformatted
text -- that will use what's in the clipboard, and that's something
different.