Re: [libreoffice-users] Re: Calc - Merge multiple discontiguous selections at the same time?
Hi Thank for the clarification. Regards, El mié, 12-10-2011 a las 18:20 +0200, Andreas Säger escribió: > There are horizontal vectors, vertical vectors and rectangles of cells. > A multiple selection may include all of these in arbitrary arrangements > across sheets. All this can be handled in the most convenient way by > means of function CONCATENATE or operator &. > -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Calc - Merge multiple discontiguous selections at the same time?
There are horizontal vectors, vertical vectors and rectangles of cells. A multiple selection may include all of these in arbitrary arrangements across sheets. All this can be handled in the most convenient way by means of function CONCATENATE or operator &. -- For unsubscribe instructions e-mail to: users+h...@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
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+h...@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
[libreoffice-users] Re: Calc - Merge multiple discontiguous selections at the same time?
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. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Calc - Merge multiple discontiguous selections at the same time?
Hi: I didn't the question but it interest me. I tried to use macro but I can't use because: a) If I selected all the cells that I want to merge ... nothing pass. b) If I select the first and run the macro ... appears a mesage that "merge" isn't found method. This macro woud be usefull ... thank you if you help us. The other method that I know to merge string is this: For example: merge A1, A6 and B10: +A1&A6&B10 Regards, Jorge Rodríguez El mar, 11-10-2011 a las 21:26 +0200, Andreas Säger escribió: > Am 11.10.2011 20:48, Tanstaafl wrote: > > Does anyone know if there is an extension that makes this possible? > > > > Or, if there is already a Feature Request for it? > > > > Thanks > > > > Sub MultiMerge > sel = ThisComponent.getCurrentSelection() > e = sel.createEnumeration() > while e.hasMoreElements() >rg = e.nextElement() >rg.merge(true) > wend > End Sub > -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Calc - Merge multiple discontiguous selections at the same time?
Am 11.10.2011 20:48, Tanstaafl wrote: Does anyone know if there is an extension that makes this possible? Or, if there is already a Feature Request for it? Thanks Sub MultiMerge sel = ThisComponent.getCurrentSelection() e = sel.createEnumeration() while e.hasMoreElements() rg = e.nextElement() rg.merge(true) wend End Sub -- For unsubscribe instructions e-mail to: users+h...@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
