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
[Reproducible] with attached Sample and "LibreOffice 3.5.3.2 (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 cell > 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?
What is interesting: msExcel 2007 in such situation issues warning: "For this needed that all cells should have equal size" and does nothing.
Reproducible with LO 4.3.2.2 (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 Result: Numbers are filled into the cells, but cell A2 and A3 are no longer merged.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.