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

Am 08.02.2011 15:40, Klonuo wrote:

> 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

Hi,

When you try to solve this by means of a macro which is supposed to work 
with *any* thinkable range selection you will face some logical 
problems. Which of the multiple ranges should be considered as anchor 
when you paste to a single target cell? This is not problem when all 
ranges share either the same set of rows or columns. Then you have a 
top-left cell in any case.

Applying a filter is the comfortable way to select disjunct rows sharing 
the same columns. Apply a filter, copy a rectangle and paste. You get 
the visible rows only.
Contrary to filtered rows, hidden rows would be included.

Hope this helps,
Andreas Säger


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