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 <[email protected]> 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 <[email protected]>: ,---- | 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. `---- That´s how I paste all the time, LO being the exception. There aren´t any menus or pop-up windows to select different ways to paste from involved. It´s only two mouse clicks, and I don´t need to switch between trackball and keyboard. LO makes it difficult and very inefficient. If you just paste as always, you screw up your document. > 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 It´s probably because you don´t copy and paste with only two mouse clicks. If you could just set a default way to paste instead of having to select it each and every time you paste so that you could just mark and paste with two mouse clicks, wouldn´t that save you a lot of work? -- 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
