Re: [libreoffice-users] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Hi :) Ok, so moving the column in Excel is a little easier IF you have reasonably fine motor control of the mouse and understand about watching the way the cursor changes (which many office workers seem to have trouble with (or is that just in my place and previous 3 places?)). The problem seems to be that if you press the Ctrl key just before you drop then it replaces everything in the column under it. Pressing Alt has no effect. Pressing Shift does make it fairly clear that the column is going to be inserted between 2 columns. So i still think that Calc is better at this. It think it does involve knowing more rather than being intuitive as the cursor doesn't seem to change at all so it doesn't give any clues that certain things can be done. On the other hand most people don't notice the cursor changes and i missed it myself when i was in a rush the other day. As for blindly clicking on Reply to all i tried the way Tanstaafi suggested and it meant i had to do quite a bit more. It wasn't just a case of deleting the one address because i then needed to copypaste the Users List address and then delete the address left in the CC. Of course i could have just cutpaste but cutting risks losing stuff. So it's like a lot of these things, a LOT more complicated than necessary. Personally i usually find my email 'client' removes duplicates for me. On the odd occasion when one slips through it's much easier for me to hit delete than it would have been for the other person to edit all their address lines. So i am sorry if i appear rude but please contact the postmaster of the list to ask them to change the list's behaviour back to the way that used to work so much better, Regards from Tom :) On 3 March 2014 12:20, Tanstaafl tansta...@libertytrek.org wrote: Tom - please STOP blindly clicking Reply All on every single message - and see my next reply about your stupid advice to everyone else to do the same stupid thing.. I do NOT need to see your messages TWICE - I'm on the list, dammit. On 3/2/2014 4:08 PM, Tom Davies tomc...@gmail.com wrote: I've not tried the Excel edges one yet. Even if it does work i think the LibreOffice one is easier and more forgiving but maybe i'm biased. I have confirmed it works, but I agree the Libreoffice way is *much* easier. -- 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
Re: [libreoffice-users] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Tom - please STOP blindly clicking Reply All on every single message - and see my next reply about your stupid advice to everyone else to do the same stupid thing.. I do NOT need to see your messages TWICE - I'm on the list, dammit. On 3/2/2014 4:08 PM, Tom Davies tomc...@gmail.com wrote: I've not tried the Excel edges one yet. Even if it does work i think the LibreOffice one is easier and more forgiving but maybe i'm biased. I have confirmed it works, but I agree the Libreoffice way is *much* easier. -- 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] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
On 2/28/2014 9:37 AM, Tom Davies tomc...@gmail.com wrote: Hi:) I just tried out the various options (Ctrl, Alt, Shift combos) in Excel 2010 and there really doesn't seem to be a way of dragging a column into a new position. It seems you have to cut or copy first. Glad you were wrong - being able to drag-n-drop is so much easier, and now I can do it in both Libre and Excel... :) -- 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] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Hi :) I'm usually glad when i'm wrong because i learn something and usually find an easier way of doing whatever it was. I've not tried the Excel edges one yet. Even if it does work i think the LibreOffice one is easier and more forgiving but maybe i'm biased. Regards from Tom :) On 2 March 2014 16:13, Tanstaafl tansta...@libertytrek.org wrote: On 2/28/2014 9:37 AM, Tom Davies tomc...@gmail.com wrote: Hi:) I just tried out the various options (Ctrl, Alt, Shift combos) in Excel 2010 and there really doesn't seem to be a way of dragging a column into a new position. It seems you have to cut or copy first. Glad you were wrong - being able to drag-n-drop is so much easier, and now I can do it in both Libre and Excel... :) -- 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
Re: [libreoffice-users] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
On 28/02/14 21:04, Carlo Gonzato wrote: non c'è nessuno che capisca e scriva in italiano? Certo, sulla mailing list utenti in lingua italiana: us...@it.libreoffice.org. -- Italo Vignoli - italo.vign...@gmail.com mob IT +39.348.5653829 - mob EU +39.392.7481795 sip it...@libreoffice.org - skype italovignoli GPG Key ID - 0xAAB8D5C0 DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 -- 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] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
On 2/27/2014 3:44 PM, Mark Bourne libreoffice-ml.mbou...@spamgourmet.com wrote: Tanstaafl wrote: On 2/27/2014 1:25 PM, Tim Deaton t...@timdeaton.org wrote: Some time ago I created bug 39936 asking asking for an enhancement that would work the way Excel does. Maybe some more encouragement on that issue might move it up in terms of priority. Did you miss my request for anyone who knows how Excel does this to please chime in? I still can't figure out how to do this in Excel. It's much the same in Excel, except it's Shift+drag rather than Alt+drag. I think you also have to drag from the few-pixels-wide border around the selection, rather than from anywhere within the selection as LO allows. Oh, wow, I doubt I'd have EVER figured that out on my own... Thx 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
Re: [libreoffice-users] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Egregi Signori: non c'è nessuno che capisca e scriva in italiano? Sono un assoluto sostenitore di Libre Office, da tempo, ma ora ho un problema dovuto al cambio di ordinatore (computer): non riesco a copiare il testo da Libre Office Writer sul mio conto email. Come risolvere questo problema? Distinti saluti, C. Gonzato Il Venerdì 28 Febbraio 2014 20:27, Tanstaafl tansta...@libertytrek.org ha scritto: On 2/27/2014 3:44 PM, Mark Bourne libreoffice-ml.mbou...@spamgourmet.com wrote: Tanstaafl wrote: On 2/27/2014 1:25 PM, Tim Deaton t...@timdeaton.org wrote: Some time ago I created bug 39936 asking asking for an enhancement that would work the way Excel does. Maybe some more encouragement on that issue might move it up in terms of priority. Did you miss my request for anyone who knows how Excel does this to please chime in? I still can't figure out how to do this in Excel. It's much the same in Excel, except it's Shift+drag rather than Alt+drag. I think you also have to drag from the few-pixels-wide border around the selection, rather than from anywhere within the selection as LO allows. Oh, wow, I doubt I'd have EVER figured that out on my own... Thx 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 -- 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] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Original Message From: Carlo Gonzato txa...@yahoo.it To: users@global.libreoffice.org Date: Fri, 28 Feb 2014 20:04:43 + (GMT) Egregi Signori: non c'è nessuno che capisca e scriva in italiano? Sono un assoluto sostenitore di Libre Office, da tempo, ma ora ho un problema dovuto al cambio di ordinatore (computer): non riesco a copiare il testo da Libre Office Writer sul mio conto email. Come risolvere questo problema? Distinti saluti, C. Gonzato Sì, il contatto: http://it.libreoffice.org/supporto/ e http://it.libreofficeforum.org/forum Distinti saluti, Dave -- 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] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
On 2/26/2014 9:40 AM, Dries Feys dries.f...@tvh.com wrote: I select the part of the spreadsheet I want to move. Then I click in the middle of that area and drag the selection to the new position. I hope my brief explanation is clear enough. I know you can drag-n-drop cells. But you only have the choices to 'Move' or 'Copy'. As the subject/body make extremely clear: 1. I'm looking for INSERT function, 2. I want to be able to do this with entire rows and columns. But thanks for the attempt. -- 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] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Some time ago I created bug 39936 asking asking for an enhancement that would work the way Excel does. Maybe some more encouragement on that issue might move it up in terms of priority. -- Tim === On 2/26/2014 9:28 AM, Tanstaafl wrote: 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... If not, then what is the shortest route to MOVE a row/column using CUT+INSERT? In Excel it takes just 4 clicks/steps: 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, and last 4. Click 'Insert cut cells' which moves the row/column you cut and place it before or above the one you right-clicked on. 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' -- 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] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
On 2/27/2014 1:25 PM, Tim Deaton t...@timdeaton.org wrote: Some time ago I created bug 39936 asking asking for an enhancement that would work the way Excel does. Maybe some more encouragement on that issue might move it up in terms of priority. Did you miss my request for anyone who knows how Excel does this to please chime in? I still can't figure out how to do this in Excel. -- 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] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Tanstaafl wrote: On 2/27/2014 1:25 PM, Tim Deaton t...@timdeaton.org wrote: Some time ago I created bug 39936 asking asking for an enhancement that would work the way Excel does. Maybe some more encouragement on that issue might move it up in terms of priority. Did you miss my request for anyone who knows how Excel does this to please chime in? I still can't figure out how to do this in Excel. It's much the same in Excel, except it's Shift+drag rather than Alt+drag. I think you also have to drag from the few-pixels-wide border around the selection, rather than from anywhere within the selection as LO allows. 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
Re: [libreoffice-users] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Hi :) I think in Excel you can't drag the column. The best work-flow seems to be right-clicks to cut and insert columns using the column headers. I can never remember if the inserted column is to the left or the right of the one you selected to insert besides Regards from Tom :) On 27 February 2014 19:26, Tanstaafl tansta...@libertytrek.org wrote: On 2/27/2014 1:25 PM, Tim Deaton t...@timdeaton.org wrote: Some time ago I created bug 39936 asking asking for an enhancement that would work the way Excel does. Maybe some more encouragement on that issue might move it up in terms of priority. Did you miss my request for anyone who knows how Excel does this to please chime in? I still can't figure out how to do this in Excel. -- 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
Re: [libreoffice-users] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
225 Janice Drive Athens, GA 30606-1638 email: t...@timdeaton.org home: 706-543-0592 cell: 706-248-6544 fax: 888-415-5991 web: www.timdeaton.org === I know the plans I have for you: Plans to prosper you and not to harm you; Plans to give you hope and a future. --- God (Jeremiah 29:11)On 2/27/2014 2:26 PM, Tanstaafl wrote: On 2/27/2014 1:25 PM, Tim Deaton t...@timdeaton.org wrote: Some time ago I created bug 39936 asking asking for an enhancement that would work the way Excel does. Maybe some more encouragement on that issue might move it up in terms of priority. Did you miss my request for anyone who knows how Excel does this to please chime in? I still can't figure out how to do this in Excel. I guess I did miss that. In Excel, I: 1. right-click the row or column header 2. hit Cut or Copy 3. right-click the destination row or column header 4. hit Insert cut cells or Insert copied cells (whichever is visible) -- Tim === -- 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] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Hi I select the part of the spreadsheet I want to move. Then I click in the middle of that area and drag the selection to the new position. I hope my brief explanation is clear enough. Met vriendelijke groeten, Salutations distinguées, Kind Regards, DRIES FEYS CORPORATE SERVICES • Specialist Software Developer TVH GROUP NV Brabantstraat 15 • BE-8790 WAREGEM T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com Watch our company movies on www.tvh.tv On 26 February 2014 15:28, Tanstaafl tansta...@libertytrek.org wrote: 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... If not, then what is the shortest route to MOVE a row/column using CUT+INSERT? In Excel it takes just 4 clicks/steps: 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, and last 4. Click 'Insert cut cells' which moves the row/column you cut and place it before or above the one you right-clicked on. 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' -- 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 -- DISCLAIMER http://www.tvh.com/newen2/emaildisclaimer/default.html This message is delivered to all addressees subject to the conditions set forth in the attached disclaimer, which is an integral part of this message. -- 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] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
At 09:28 26/02/2014 -0500, Charles Marcus wrote: 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, ... 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? I trust this helps. 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