Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


Dear Roxy

How Strange. It must be a windows 7 thing (I hesitate to say bug)

I have just booted up my Home computer, which runs 3.4.0 (windows XP sp3)

I click on paste special and up comes the window with the tick boxes.

Both [3.3.3 & 3.4] has 4 sections in the window :- Selection, Options, Operations and Shift cells. Selection & Options have tick boxes, Operations & shift cells are radio buttons.

I have just tried your toolbar method pasting as unformatted text - excellent - that's the better way to go

I tested (just like me) both methods only work on a untouched cells, if the cells have been formatted previously (bold, font size etc), neither work on my system.

regards

John



-------------------------------------------------------------------------------------------------------

On 20/06/2011 22:38, Roxy Robinson wrote:
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



--
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

Context


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.