Re: [libreoffice-users] Re: Calc - Merge multiple discontiguous selections at the same time?

Hi:

        I know that is better using a macro, off course. That was I request to
help us with this macro that you did, because I tried to run and it
failed. Now I tried to run like this:

A1 = jor
A2= ge

B3 = Rodrí
B4 = guez

D2 = Fon
D3 = seca

        I selected all ranges and run the macro...the result was:

Merge A1 with A2 but lost "ge"
Merge B3 with B4 but lost "guez"
Merge D2 with D3 but lost "seca"

        I thought that merge multiple range macro would bring this:

Merge the content of A1:A2 with B3:B4 and with D2:D3 in other cell, like
this:

D6 = jorgerodriguezfonseca

        I expose you all this because I think is a good idea and usefull to get
a macro like this.

        Excuse me if I'm abusing of your time and knowledge 

Regards,

Jorge Rodríguez
_______________


El mié, 12-10-2011 a las 02:28 +0200, Andreas Säger escribió:
> Am 12.10.2011 02:16, jorge wrote:
> >     For example: merge A1, A6 and B10:
> >
> >                                     +A1&A6&B10
> > Regards,
> >
> > Jorge Rodríguez
> > ________________
>
> Replacing a formula with a macro would be useless. My macro merges 
> multiple selections of ranges such as A1:B4 D3:D5 E1:G1 as 
> menu:Format>Merge does with one selected range at a time.

-- 
Atentamente,

Jorge Rodríguez


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted