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

Tuesday, February 8, 2011, 9:47:43 AM, Luuk wrote:

> Question: Do you also have (a version of ) openOffice installed?
> (if 'yes', please remove openOffice & reinstall LibreOffice, and see if
> problem is solved)

Yes, I do have openOffice, but wouldn't removing it for such issue be at least doubtful? Are there 
other problems that may occur having both installations?


Tuesday, February 8, 2011, 11:55:22 AM, Luuk wrote:

> > (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


I tried to do the same operation in:

1. openOffice Calc 3.3.0

No problems with pasting data from multiple diverse cells (in same column/row) in regular text 
editor. Clipboard data seems same like LibreCalc - some star office XML format and various others 
format objects 

2. Corel Calculate (from Home Office) 5.0.38

Can't do Ctrl+select then copy at all (I had it handy so thought to try it)

3. MS Excel 2010

No problems with cells in same row/columns. Clipboard data is available in even more formats - 
worth mentioning XML spreadsheet and CSV


Finally, it seems interesting to me that this spreadsheet programs can do copy/paste when cells 
aren't in same column/row. At least I expected Excel to do it, but it can't

And it seems that problem is not in intolerance between openOffice and LibreOffice in same OS, like 
Stefan replied with same observation







-- 
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 ***