Apache OpenOffice (AOO) Bugzilla – Issue 2131
RFE: ability to merge cells already merged
Last modified: 2013-08-07 15:13:10 UTC
in Calc, suppose that there're cells named [ A ][ B ][ C ] if you've merged A,B together [ AB ][ C ] oo.o doesn't allow us to merge AB,C "Cell merge not possible if cells already merged" message shown in pop-up dialog in MS Excel, we can merge AB,C [ ABC ] ---- request for enhancement
Hi Falko, this is for you. Regards, Peter
This issue is re-assigned to Christian Jansen for further evaluation.
Sounds good, we should think about it.
This also applies when copying and pasting merged cells into merged cells of the same size. eg. You have [ A B ] (as a merged cell). If you try to copy this and paste into a different merged cell [ C D ], you get the same message, "Cell merge not possible if cells already merged".
*** Issue 7605 has been marked as a duplicate of this issue. ***
please adjust the Platform, OS and version field ! (the merged cells behaviour needs to be "completely" redesigned beacuse there are many related issues)
@Lars: Platform, OS and Version seem to be adjusted right. So what's wrong? Peter
*** Issue 10858 has been marked as a duplicate of this issue. ***
Reassigned to Bettina.
*** Issue 16286 has been marked as a duplicate of this issue. ***
Yes, merging already merged cells should be possible.
Summary: Merging already merged cells should be possible. Hello Niklas, please give approval for this evaluated OO.o 2.0 flagged issue. If you confirm with the target OO.o 2.0, then please keep it on your owner (or the owner of the concerning developer) for implementation. In case you want this issue for 'OOo Later', then please reset the target milestone. If you decline the issue finally, please set the resolution to 'Wontfix' (but do not close). In case of 'OOo Later' or 'Wontfix' please reset it on Bettina's owner. Thank you.
*** Issue 11402 has been marked as a duplicate of this issue. ***
This is not on the list of features that we're going to do for 2.0. We need to focus on the enhancements from the PCD document.
*** Issue 26288 has been marked as a duplicate of this issue. ***
Here are some more good details from Jonthan describing the different cases to consider at merging: Let us assume we have a merged range, D3:H10. The scope of deleting cells within this range, means that we only allow deletion of a row, column or block which extends up to both edges: We do not permit deletion of only one edge. (2 is permitted only if they are both the vertical or horizontal ones; 3 or 4 is permitted) So, if we select column E; or cells E2:E20, F1:M6 or D2:D11, this operation should be permitted. (covers 2 edges, 2 edges, 4 edges (ie the entire item) and 3 edges) It would not be possible to delete G2:G4, G2:J4 or F14:K5 still as these are only affect one edge of a row or column, or 2 edges which are not both horizontal or vertical. It is also not possible to delete E4:F6, A1:F5 as these are within the area. Note that the GUI won't allow you to select this anyway (as far as I know) but requests might be generate by macros. If a new data cell (The top left one which defines the formatting and contents) is created, it should be set to the old data cell, unless the entire range has been deleted.
Reassigned to owner 'requirements', set the appropriate keywords.
*** Issue 43337 has been marked as a duplicate of this issue. ***
*** Issue 65189 has been marked as a duplicate of this issue. ***
I was lead to this after having crashed my 2.0.2 by trying to insert a column right through some horizontally merged cells. Starting the chase in OOo's issuezilla I found #10858 which is stated a duplicate of this one, but I guess inserting columns through merged cells and merging groups of already merged cells are different issues. But you guys @OOO will know better... So, if my problem really relates to #2131 which has been detected in 1.0.1, I fear it will take some more time (maybe up to 3.0.3) till OOo will behave as it should.
ATM I only tagged a column that crosses a horizontally merger. Then I clicked to that merger, and OOo decided to quit... :(
*** Issue 77253 has been marked as a duplicate of this issue. ***
a workaround can be this: 1) create a macro (a personal macro) with the following code: REM ***** BASIC ***** sub MergeAllCells rem ---------------------------------------------------------------------- rem define variables dim document as object dim dispatcher as object rem ---------------------------------------------------------------------- rem get access to the document document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") rem ---------------------------------------------------------------------- dispatcher.executeDispatch(document, ".uno:SplitCell", "", 0, Array()) dispatcher.executeDispatch(document, ".uno:MergeCells", "", 0, Array()) end sub 2) Tools -> Personalization -> Symbol toolbars Note: Sorry ... I have Italian OOo so I don't know if all the English names are correts 3) select "Formatting" from combo box "Toolbars" 4) press Import button 5) select "OpenOffice.org macro" -> MergeAllCells 6) press Add button You can now add an icon for it and adjust its position and also can delete the "join cells" button I think that the same warkaround can be implemented very easy into the code and probably it need only few minuts (to search the code) Ciao Davide
5
This issue is important and listed on the quarterly review for Calc: http://wiki.services.openoffice.org/wiki/2008_Q2_Review_of_Spreadsheet_Project Therefore adjusting target to 3.x.
In OO 3.0 Beta this still not work (copying a group of marged cells to another group of merged cells with the same number of merged cells - merged AB line 1 is not possible to copy to merged AB line 2).
*** Issue 95062 has been marked as a duplicate of this issue. ***
In MergA.ods, click on (triple) cell A1, copy it (^c), paste it (^v) to A3: get cannot_do_it_msg 'cell merge not possible if cells already merged!' To do the copy, one has to 'unmerge' the cells A3 and C3 (by 'merging' them), then do the copy; Calc should do that, instead of popping the cannot_do_it_msg. Calc also refuses to merge A3 and C3. One has to unmerge them, then highlight A3..D3, click Merge, and answer the_question: 'Should the contents...?'. Again, Calc should do that --including the_question, which should have (beside the Yes/No choice) a Cancel option, in case the user did not foresee the implications of his/her request. In conclusion, the solution to this whole issue seems simple: Calc should do automatically all the necessary 'unmerge', then do the requested operation. (If that gives an unexpected or unwanted result, the user can undo it.) Since all the required steps are already programmed, it should be fairly easy (through a few procedure calls) to substitute them for the cannot_do_it_msg.
Created attachment 65131 [details] File with merged cells