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
-------------------------------------------------------------------------------------
--------------------------------------------------
On 20/06/2011 20:12, Roxy Robinson wrote:
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
--------------------------------------------------------------------
On 20/06/2011 01:06, lee wrote:
Hi,
how do I set a default pasting type so that when pasting, only the text
itself is pasted and not the formatting with it?
How do I make it so that text, when pasted with the mouse, is inserted
at the position of the text cursor where it´s supposed to be inserted,
rather than where the mouse pointer happens to be?
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.901 / Virus Database: 271.1.1/3702 - Release Date: 06/13/11 19:34:00
--
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.901 / Virus Database: 271.1.1/3714 - Release Date: 06/19/11 19:33:00
--
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.