Issue 124937

Summary: Inserting rows / columns does not respect cell merge
Product: Calc Reporter: vijayzither
Component: formattingAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: oooforum, rainerbielefeld_ooo_qa
Version: 3.3.0 or older (OOo)   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: 4.1.0
Developer Difficulty: ---
Description Flags
PDF file showing non merged cells
Sample Document none

Description vijayzither 2014-05-20 10:14:36 UTC
Created attachment 83428 [details]
PDF file showing  non merged cells

When a row is inserted in between merged cells, the inserted row appears as separate unmerged coloumns.


Comment 1 oooforum (fr) 2014-05-20 14:50:22 UTC
Seems to be covered by <u></u>
Comment 2 Rainer Bielefeld 2014-05-20 17:04:59 UTC
NOT reproducible with "AOO 4.2.0-Dev – German UI / German locale [AOO420m1(Build:9800)  -   Rev. 1595858 2014-05-20 1]" on German WIN7 Home Premium (64bit)", “historic” 4. User Profile used for all predecessor versions.

My test: 
1. New Writer document from AOO start Center -> Insert 2 columns x 3 rows table
2. Merge the 2 cells of each row, row by row
   > Table will look like a 1 column table
3. Click into second row
   > Caret flashes
4. Menu 'Table -> Insert -> Rows - quantity=1, option = after [ok]'
   > Row inserted looks like "single column"

Thank you for your feedback – unfortunately important information we will 
need to reproduce your problem is missing.
Please add all information requested in following:
a) Write a meaningful Summary describing exactly what the problem is
   (" Inserting rows in meged cells" is not the description of a problem)
b) Attach a sample document (not only screenshot) or refer to an existing 
   sample document in an other Bug with a link; to attach a file to this 
   bug report, just click on "Add an attachment" right on this page.
   If you want to attach a test kit with multiple documents zip them into
   a single and attach the
c) Contribute a document related step by step instruction containing every 
   key press and every mouse click how to reproduce your problem 
e) if possible contribute an instruction how to create a sample document 
   from the scratch
   best way is to contribute a sample document where the first table
   is the source table and by copy/paste of the source table you 
   add a new table below where you do edits for step 1 and and by copy/paste
   of this table you add a new table below where ...
f) add information 
   f1) what EXACTLY is unexpected. 
   f2) and WHY do you believe it's unexpected (cite Help or Documentation!)
   f5) concerning your AOO version (with Build/revision ID if it's not a 
      public release) and localization (UI language, Locale setting)
   f6) AOO settings that might be related to your problems 
   f7) how you launch AOO and how you opened the sample document
   f9) Whether that worked in former OOO / AOO Versions 
   f10) whether (and how) a competitor's software (MSO, LibreOffice, ...)
        fulfills your needs

Please do not cite these hints in your reply, but cite the items like:
f7): Desktop-icon for soffice.exe / AOO File menu -> Open
Comment 3 Rainer Bielefeld 2014-05-20 17:06:30 UTC
Damned, may be I should have read the Product ...
Comment 4 Rainer Bielefeld 2014-05-20 17:18:58 UTC
Created attachment 83435 [details]
Sample Document

Reproducible with "AOO 4.2.0-Dev – German UI / German locale [AOO420m1(Build:9800)  -   Rev. 1595858 2014-05-20 1]" on German WIN7 Home Premium (64bit)", “historic” 4. User Profile used for all predecessor versions

If you have rows 1-4 with merged cells for column-cells B:C in each row 
if you click intl second row
and insert a row
the newly inserted row will show unmerged cells

More intuitive description and sample cell ranges in sample document
Comment 5 mroe 2014-05-20 17:44:09 UTC
I think there is no defect. Simple reason: How should it work if cells over more than one row are merged? What should be happen if there are merged cells between row n and n+1 and between n+1 and n+2? And so on. Same for columns.

A change of behaviour if only one row is affected breaks consistency.
Comment 6 Rainer Bielefeld 2014-05-20 17:54:16 UTC
(a) Not only 'insert -> row' affected, same problem with 'insert -> column' 
    for vertically merged cells
(b) Not a new problem, already reproducible with OOo 2.0.2
(c) users might expect that merge should be respected because normally insert row
    applies format of row above to newly created row. For example document:
    before you test in Step 1 table apply green background and red characters
    to B22. If you afterwards click to B23 and insert new row, the "new B23" will
    have background and character color from B22, but not "merged"

(d) but is that "merge" really a format property of a cell? I am not sure, and
    Gnumeric, Kingsoft  and SoftMaker FreeOffice behave the same way.
(e) So I only can confirm the effect, but I do not know whether it's a bug
(f) I can't see the relation to Bug 2131 (Bug 8302) as in Comment 1
(g) I can't understand comment 5
Comment 7 mroe 2014-05-20 17:59:51 UTC
Hint 1: (for only one new row)
Select a formatted row, select the paintbrush, click onto the first cell of the new row.

Hint 2: (for not only one new row)
1. Select a formatted row.
2. Copy it into the clipboard.
3. Select the new rows.
4. Edit → Paste Special: deselect all and select only [x]Formats.
Comment 8 Rainer Bielefeld 2014-05-20 19:51:20 UTC
I think it's at least unintuitive that Calc behaves different from Writer. Without very good reasons that would be a bug.

(In reply to mroe from comment #7)
Thank you for explication, I will think about that tomorrow
Comment 9 mroe 2014-05-21 07:13:50 UTC
(In reply to Rainer Bielefeld from comment #8)
> I think it's at least unintuitive that Calc behaves different from Writer.
> Without very good reasons that would be a bug.

The reason is: Writer is word processing, Calc is calculation.

A text table isn't a spreadsheet.

In Calc: Merging of cells: the first cell grows to the size of the merged cells and overlap them. (The other cells still exists under this cell.)You cannot split a single cell. The fixed structure of rows and columns doesn't change. 

In Writer: Merging of cells destroys the former cells to one cell. You can split a single cell to new cells. So every row/ column can have its own structure.