[libreoffice-users] default type and setting for pasting

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