tag:blogger.com,1999:blog-8544609315733972726.post7562426535774742087..comments2008-06-05T15:45:48.799-06:00Comments on OpenOffice.org Ninja: Move, copy, and link cells using drag and dropAndrew Zhttp://www.blogger.com/profile/10108637160465346326noreply@blogger.comBlogger5125tag: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 Zhttp://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