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 [email protected] > In case of problems unsubscribing, write to [email protected] > 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 [email protected] In case of problems unsubscribing, write to [email protected] 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 [email protected] In case of problems unsubscribing, write to [email protected] 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
