Re: [libreoffice-users] How to copy multiple diverse cells in Calc?

Looks like it will copy and paste multiple selections in the same column 
but not different columns.  And when it does paste the selection any 
empty cells between the selections are compressed out.

On 2/8/2011 5:55 AM, Luuk wrote:
> Hi Luuk,
>
> Am 08.02.2011 09:47, schrieb Luuk:
>
> > On 08-02-11 05:26, klonuo wrote:
> > > An example: I selected multiple diverse cells with Ctrl+Click,
> > > then pressed Ctrl+C, expecting that selected cells content
> > > would be placed in clipboard.
> > >
> > > Unfortunately clipboard contains value from only one cell - the
> > > top-most it seems. Why is this, and is there a way that I can
> > > copy data this way?
> > I sure hope that you are doing soemething wrong, because if this
> > does not work, than LO is.........
> >
> > So, i tried on my Windows7 64b, and here it works
> No folks. ;-) :-D
>
> Yes, it does work. And no, it does not work. ;-)
>
> Try this:
>
> (1) Click on cell A1 and Ctrl+Click on cell B1. Type Ctrl+C. You
> will get a warning, that Calc won´t do it this way.
no warning here, on Win7 and also not on openSUSE11.1 (same version of LO)
A1:B1  gets selected and copied..

> (2) Click on cell A1 and Ctrl+Click on A3. Type Ctrl+C. Click on
> cell C1 and type Ctrl+V. Works fine.
This is the 'hard' way to copy the contents from A3 to A2, if i'm
right... ;)

> (3) Click on cell A1 and Ctrl+Click on A3. Type Ctrl+C. Open any
> simple text editor on your system and type Ctrl+V. You get the
> content of A1 only.
This is because when you paste in your texteditor, it looks at the
clipboard for a piece of text, and not for a piece of spreadhsheet.
When you copy an image from somehwere, and try to paste it in your
text-editor, this will not work also..

But when pasting this selection in LO-Writer, i do thing that the
contents of these 2 cells should be pasted, just as it works when
copying/pasting A1:B1



--
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***