Bug 47778 - EDITING: Filling down or across through merged cells undoes the merge
Summary: EDITING: Filling down or across through merged cells undoes the merge
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
: 49638 (view as bug list)
Depends on:
Blocks: Calc-Merge-Split AutoFill
  Show dependency treegraph
Reported: 2012-03-23 10:55 UTC by Mark C
Modified: 2023-10-23 09:51 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:

Excel2000,drag copy OK. (53.36 KB, image/png)
2020-06-05 02:09 UTC, Junichi Matsukawa
Calc,Drag Copy NG. (105.32 KB, image/png)
2020-06-05 02:12 UTC, Junichi Matsukawa

Note You need to log in before you can comment on or make changes to this bug.
Description Mark C 2012-03-23 10:55:00 UTC
Problem description: If I create a merge of two or more cells horizontally or vertically and then fill down or across from or through these cells, the merge is removed and the fill happens to individual cells. If the merged areas are the same size, filling should work, not erase the 'merge' formatting.

Steps to reproduce:
1. Create one or more merged regions
2. Enter some data above or in the merged region
3. Drag the corner of the data cell to drag down or across

Current behavior: The merge formatting disappears when the data is filled into the merged cells

Expected behavior: If the merged region(s) are a compatible size, the data should be entered and the merge left alone. If this is impossible or overly ambiguous, an error message should be generated.

Platform (if different from the browser): 
Browser: Opera/9.80 (Windows NT 5.1; U; en) Presto/2.10.229 Version/11.61
Comment 1 Rainer Bielefeld Retired 2012-05-11 08:06:25 UTC
[Reproducible] with attached Sample and "LibreOffice (RC2) German UI/Locale [Build-ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b80] on German WIN7 Home Premium (64bit) 
In sample in yellow Area the contents of A1:B3 is shown.

Steps to reproduce:
1. Select B1:B2
2. Click "Merge Cells" Icon and merge without shifting contents of hidden
   > Double width cell visible with contents "11", no changes in yellow
     "show contents" area
3. Click B1
4. Fill down using fill handle until B3
   Expected: B1,B2,B3 containing 1,2,3, merge remains
   Actual: As Expected, see H1:H3
5. Click A1
6. Fill down using fill handle until A3
   Expected: A1,A2,A3 containing 1,2,3, merge remains
   Actual: Cell Contents as expected, but merge destroyed

I never saw that working in a different way, already the same in OOo 1.1.4 (so "inherited"), but to me the current behavior seems inconsistent.

I disagree with proposed solution in AOOo Bugzilla, in example but I simply want to see the same behavior in columns A and B and that merged cells keep merged.

But may be there are ODF dependencies or similar?
Comment 2 sasha.libreoffice 2012-06-18 04:16:06 UTC
What is interesting: msExcel 2007 in such situation issues warning: "For this needed that all cells should have equal size" and does nothing.
Comment 3 A (Andy) 2014-10-11 22:26:46 UTC
Reproducible with LO (Win 8.1)

Steps Done:
1. Open a new spreadsheet in CALC
2. Type in cell A1 "1"
3. Select cell A2 and A3 and merge them (e. g. via right mouse click -> MERGE CELLS)
4. Go to cell A1
5. Click on the small square in right bottom corner of this cell and move the mouse down over the merged cell A2 and A3

Numbers are filled into the cells, but cell A2 and A3 are no longer merged.
Comment 4 QA Administrators 2015-10-14 19:57:01 UTC Comment hidden (obsolete)
Comment 5 Buovjaga 2015-12-04 16:25:24 UTC
Still repro.

Win 7 Pro 64-bit Version:
Build ID: 81fa5340191baf8687f9c82f1f414f5afc86b529
Threads 4; Ver: Windows 6.1; Render: default; 
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-12-03_21:19:19
Locale: fi-FI (fi_FI)
Comment 6 QA Administrators 2017-01-03 19:41:20 UTC Comment hidden (obsolete)
Comment 7 Timur 2018-11-08 16:59:07 UTC
Repro 6.2+
Comment 8 Timur 2018-12-24 17:35:25 UTC
*** Bug 49638 has been marked as a duplicate of this bug. ***
Comment 9 Junichi Matsukawa 2020-06-05 02:09:25 UTC
Created attachment 161628 [details]
Excel2000,drag copy OK.

I reproduced this bug.
Excel2000,drag copy OK.
Comment 10 Junichi Matsukawa 2020-06-05 02:12:32 UTC
Created attachment 161629 [details]
Calc,Drag Copy NG.

I reproduced this bug.
I can't drag and copy merged cells well in Calc.

バージョン: (x64)
Build ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff
CPU threads: 4; OS:Windows 10.0 Build 18363; UI render: default; VCL: win; 
ロケール: ja-JP (ja_JP); UIの言語: ja-JP
Calc: CL
Comment 12 BogdanB 2021-07-31 08:33:58 UTC
Retested. Repro in
Version: / LibreOffice Community
Build ID: 5aa74aa1e6fac571f99146ebcb6adc9feb1459ad
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-07-28_19:35:14
Calc: threaded
Comment 13 QA Administrators 2023-08-01 03:16:41 UTC Comment hidden (obsolete)
Comment 14 Stéphane Guillou (stragu) 2023-10-06 08:44:40 UTC
Still reproduced in recent trunk build:

Version: (X86_64) / LibreOffice Community
Build ID: f95c3994f0b6a82a3bc2ddfb68822b74479ae185
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

For comparison, MS Office 365 gives the following error message when trying to fill down over merged cells:

"To do this, all the merged cells need to be the same size"