Re: [libreoffice-users] Re: Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
On 2/26/2014 10:00 AM, Pedro pedl...@gmail.com wrote: Tanstaafl wrote In Calc it takes 6: 1. Right-click a row/column header, 2. Click CUT, 3. Right-click the row/column header above/to-the-right-of the row/column you want the one you CUT to go, 4. Click 'Paste Special', 5. Change 'Shift cells' to either 'Right' (for columns) or 'Down' (for rows), and last 6. Click 'OK' No, it takes eight, which is twice the number of actions for the same result... Heh, right you are (forgot about that, and every time I had to do it it always irritated the heck out of me). But now, after Brian's painfully obvious (in retrospect) answer, this is no longer an issue... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
Re: [libreoffice-users] Re: Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
On 2/26/2014 2:05 PM, Mark Bourne libreoffice-ml.mbou...@spamgourmet.com wrote: Although not particularly obvious, all these options are documented in the help - from the index, look up moving cells by drag-and-drop. It is, and I even found that once, but it doesn't mention rows or columns, and again, for some bizarre reason, it never even occurred to me to try clicking down inside the selected CONTENT. Thanks again to Brian (and Nino, although I already knew about the CTRL and ALT modifiers and how they work)! -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
[libreoffice-users] Re: Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Am 26.02.2014 15:28, schrieb Tanstaafl: Ok, Ive messed with this in the past, never been able to figure it out, but something always stopped me from pursuing it until now. I'm just looking for the quickest/easiest way to MOVE rows/columns. Is this even possible? I've NEVER been able to get it to work, even in Excel... For me it's just 1. (Left-) Click a row/column header to mark it, 2. Click just somewhere inside the marked column (into the data area, not the header) and hold/drag it to the desired destination 3. Release it. What happens when you try this? Nino -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
[libreoffice-users] Re: Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Tanstaafl wrote In Calc it takes 6: 1. Right-click a row/column header, 2. Click CUT, 3. Right-click the row/column header above/to-the-right-of the row/column you want the one you CUT to go, 4. Click 'Paste Special', 5. Change 'Shift cells' to either 'Right' (for columns) or 'Down' (for rows), and last 6. Click 'OK' No, it takes eight, which is twice the number of actions for the same result... You forgot to mention that cutting a column fails to remove it so in order to get the same result as in Excel you also need to 7. Right click again on the (now empty) original column 8. Choose Delete Column On the other hand, thank you for the Paste Special tip. I didn't know LO could do that (it's not intuitive to choose Paste Special) so in step 3 I would Insert Column and then Paste (and then Delete the original column...) One day LO will be as efficient/intuitive as Excel :) Looking forward to read other solutions :) -- View this message in context: http://nabble.documentfoundation.org/Calc-how-to-move-drag-n-drop-using-mouse-or-cut-insert-rows-columns-tp4099125p4099141.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
[libreoffice-users] Re: Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Nino wrote For me it's just 1. (Left-) Click a row/column header to mark it, 2. Click just somewhere inside the marked column (into the data area, not the header) and hold/drag it to the desired destination 3. Release it. What happens when you try this? That would be lovely but it doesn't work. It works for moving to empty cells. Otherwise it will replace contents, not move the contents... -- View this message in context: http://nabble.documentfoundation.org/Calc-how-to-move-drag-n-drop-using-mouse-or-cut-insert-rows-columns-tp4099125p4099142.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
[libreoffice-users] Re: Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Hi Brian Brian Barker wrote What happens if you: o Select the row or column. o Drag it to the new position. o Hold down the Alt key whilst you drop? Yes! That works! I'm glad there is an easy way to do it! Thanks!!! Unfortunately (for LO) it is not obvious even for advanced users... Which means that for the average user the conclusion is that LO can't do that... Thanks! Pedro -- View this message in context: http://nabble.documentfoundation.org/Calc-how-to-move-drag-n-drop-using-mouse-or-cut-insert-rows-columns-tp4099125p4099146.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
Re: [libreoffice-users] Re: Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
At 07:11 26/02/2014 -0800, Pedro wrote: Unfortunately (for LO) it is not obvious even for advanced users... Which means that for the average user the conclusion is that LO can't do that... I have to admit that I'd always assumed there was no easy way. But seeing the question made me experiment - so I've learned this useful technique too. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
[libreoffice-users] Re: Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Brian Barker wrote At 07:11 26/02/2014 -0800, Pedro wrote: Unfortunately (for LO) it is not obvious even for advanced users... Which means that for the average user the conclusion is that LO can't do that... I have to admit that I'd always assumed there was no easy way. But seeing the question made me experiment - so I've learned this useful technique too. That just proves my point, unfortunately. Experiment and use of key modifiers or shortcut keys is *not* for the average user... I'm glad you found a solution and shared it, though :) -- View this message in context: http://nabble.documentfoundation.org/Calc-how-to-move-drag-n-drop-using-mouse-or-cut-insert-rows-columns-tp4099125p4099153.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
Re: [libreoffice-users] Re: Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Hi :) That is brilliant!! So far i have been doing an insane method of inserting an empty column and then pasting the copied one into it and deleting the old one. Excel seemed much easier as it's easy to just drag the column to a new position. However now Calc seems even easier. I had to combine Brian's and Nino's answer. Brian's didn't seem to work for me until i saw Nino's saying to move the mouse arrow down into the data part rather than trying to use the header part. So it's not completely intuitive to Excel users but it's not far off Regards from Tom :) On 26 February 2014 15:29, Pedro pedl...@gmail.com wrote: Brian Barker wrote At 07:11 26/02/2014 -0800, Pedro wrote: Unfortunately (for LO) it is not obvious even for advanced users... Which means that for the average user the conclusion is that LO can't do that... I have to admit that I'd always assumed there was no easy way. But seeing the question made me experiment - so I've learned this useful technique too. That just proves my point, unfortunately. Experiment and use of key modifiers or shortcut keys is *not* for the average user... I'm glad you found a solution and shared it, though :) -- View this message in context: http://nabble.documentfoundation.org/Calc-how-to-move-drag-n-drop-using-mouse-or-cut-insert-rows-columns-tp4099125p4099153.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
[libreoffice-users] Re: Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Hi Tom, all TomD wrote That is brilliant!! So far i have been doing an insane method of inserting an empty column and then pasting the copied one into it and deleting the old one. Excel seemed much easier as it's easy to just drag the column to a new position. However now Calc seems even easier. I had to combine Brian's and Nino's answer. Brian's didn't seem to work for me until i saw Nino's saying to move the mouse arrow down into the data part rather than trying to use the header part. So it's not completely intuitive to Excel users but it's not far off I have been using the same insane 8 step method... Indeed Calc's hidden feature is better than Excel, but few users will find it... You are right about combining the instructions. The proper way to do it is: 1 - Left click a row/column header to mark it, 2 - Left click somewhere inside the marked row/column (into the data area, not the header) 3 - Drag it to the new position 4 - Hold down the Alt key and release the left mouse button (you can release the Alt button now :) ) Thanks to all that contributed! -- View this message in context: http://nabble.documentfoundation.org/Calc-how-to-move-drag-n-drop-using-mouse-or-cut-insert-rows-columns-tp4099125p4099166.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
Re: [libreoffice-users] Re: Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Pedro wrote: Hi Brian Brian Barker wrote What happens if you: o Select the row or column. o Drag it to the new position. o Hold down the Alt key whilst you drop? Yes! That works! I'm glad there is an easy way to do it! Thanks!!! Unfortunately (for LO) it is not obvious even for advanced users... Which means that for the average user the conclusion is that LO can't do that... There are also the following alternatives: - Hold down Ctrl whilst dropping, to copy a column overwriting any content already in the column you're dropping onto - Hold down Ctrl and Alt whilst dropping, to copy to a new column inserted in between two existing columns Although not particularly obvious, all these options are documented in the help - from the index, look up moving cells by drag-and-drop. Holding Ctrl while dragging to copy is quite common in other applications too. Not so common, but I have seen holding Alt while dragging to move things in other applications where copying in the default (i.e. with no key held down) action. So now you know about them, it might be worth trying Ctrl+drag and Alt+drag in applications other than LibreOffice too ;o) Mark. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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