tag:blogger.com,1999:blog-8544609315733972726.post7562426535774742087..comments2023-10-15T10:05:41.443-06:00Comments on OpenOffice.org Ninja: Move, copy, and link cells using drag and dropAndrew Zhttp://www.blogger.com/profile/10108637160465346326noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-8544609315733972726.post-26415115443997699172010-05-11T16:24:01.657-06:002010-05-11T16:24:01.657-06:00I appreciate Sun's work on building a free sof...I appreciate Sun's work on building a free software....but you know the saying....what is free ...sucks! If you want something professional get MS Office!!! Dont play with toys!Unknownhttps://www.blogger.com/profile/08341609464249492390noreply@blogger.comtag:blogger.com,1999:blog-8544609315733972726.post-898945654063816262010-01-25T03:54:45.611-07:002010-01-25T03:54:45.611-07:00I have a calc sheet for storing addresses and othe...I have a calc sheet for storing addresses and other data, in my First sheet can I 'link' the name if an address (say in cell A5) so that when you click on it it will automatically link to the sheet (say sheet 10) where I have all of the info for that address stored.<br /><br />I want it to behave like a hyperlink but only want it to link to another sheet in the same spreadsheet.Mick Reayhttps://www.blogger.com/profile/12404687993368528053noreply@blogger.comtag:blogger.com,1999:blog-8544609315733972726.post-4612922645154781962009-10-22T00:55:13.517-06:002009-10-22T00:55:13.517-06:00I was getting really frustrated not being able to ...I was getting really frustrated not being able to move some rows, Alt really did the trck thanks a ton!Sanjhttps://www.blogger.com/profile/05791160286580879075noreply@blogger.comtag:blogger.com,1999:blog-8544609315733972726.post-46646168331946103832009-01-12T15:03:00.000-07:002009-01-12T15:03:00.000-07:00oh wow... you just saved me a ton of time. thanks...oh wow... you just saved me a ton of time. thanks!<BR/><BR/>Fredfinalrunehttps://www.blogger.com/profile/12101954952954409052noreply@blogger.comtag:blogger.com,1999:blog-8544609315733972726.post-16410420612024598592008-12-23T06:45:00.000-07:002008-12-23T06:45:00.000-07:00Copy mode may optionally be combined with insertio...Copy mode may optionally be combined with insertion mode by holding down both CTRL and ALT.<BR/>I tried 2.4.1 on Linux. ALT+SHIFT is not working.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8544609315733972726.post-29511256927343936452008-09-15T09:14:00.000-06:002008-09-15T09:14:00.000-06:00I love Open Office, I hate that most institutions ...I love Open Office, I hate that most institutions use Microsoft Word.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8544609315733972726.post-66941760003396966222008-06-05T15:45:00.000-06:002008-06-05T15:45:00.000-06:00How can I copy cells A1 and B1 and paste their con...How can I copy cells A1 and B1 and paste their contents into A2-A20 and B2-B20 respectively. Example:<BR/> Hello World<BR/>.<BR/>.<BR/>.<BR/>.<BR/> Hello WorldAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8544609315733972726.post-41500423464123453832008-03-27T15:14:00.000-06:002008-03-27T15:14:00.000-06:00Strange.. All these great features also works on m...Strange.. All these great features also works on my current version 2.3 (platform Ubuntu, exact version in about box: openoffice.org-core 1:2.3.0-1ubuntu5.3. Tue Nov 27 18:52:42 GMT 2007.)<BR/>Anyone else can this confirm too?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8544609315733972726.post-90009422725554507902008-03-04T18:44:00.000-07:002008-03-04T18:44:00.000-07:00Thanks, Andrew Z. It works. After I posted my mes...Thanks, Andrew Z. It works. After I posted my message I kept on surfing and found another variation on your solution.<BR/>1 Select the cell.<BR/>2 Hold the shift and click the cell. The cell is now highlighted.<BR/>3 Let go of the shift key and you can drag the cell wherever.<BR/><BR/>Thanks very much for your help.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8544609315733972726.post-76335045885162205202008-03-04T18:25:00.000-07:002008-03-04T18:25:00.000-07:00How to drag a single cell1. Click the cell. Notic...How to drag a single cell<BR/>1. Click the cell. Notice the cell is outlined.<BR/>2. Drag down to highlight multiple cells. Notice they have a dark background.<BR/>3. Drag back up to highlight just the one. Notice the one still has dark background.<BR/>4. Continue normally.<BR/><BR/>Thanks to <A HREF="http://user.services.openoffice.org/en/forum/viewtopic.php?p=3528#p3528" REL="nofollow">acknack</A> for the tip.Andrew Zhttps://www.blogger.com/profile/10108637160465346326noreply@blogger.comtag:blogger.com,1999:blog-8544609315733972726.post-53687458587699624332008-03-04T10:50:00.000-07:002008-03-04T10:50:00.000-07:00In Calc, how do I drag and drop one single cell as...In Calc, how do I drag and drop one single cell as in Quatro-Pro or Excel?<BR/>Open offoice only seems to work for two or more cells.Anonymousnoreply@blogger.com