Problem description: According to LibreOffice Version 3.4 Calc Guide , "a shortcut way to fill cells is to grab the “handle” in the lower right-hand corner of the cell". Actually, it is not possible to copy a merged cell in Calc and paste the merged cell by dragging the handle, and to create another merged cell at the same time.
Steps to reproduce:
1. The operating system used is Linux debian 2.6.32-5-686 #1 SMP Sun Sep 23 09:49:36 UTC 2012 i686 GNU/Linux.
2. The LibreOffice versions involved are:
- LibreOffice Version 184.108.40.206 (Build ID: 2ef5aff) (LO220.127.116.11)
- LibreOffice Version 18.104.22.168 (Build ID: 527dba6f6e0cfbbc71bd6e7b88a52699bb48799) (LO22.214.171.124)
3. File -> New -> Spreadsheet
4. Select A1:B1 -> Format -> Merge Cells -> Merge Cells
5. Type the letter a in A1:B1. -> Enter
6. Select A1:B1.
7. Drag the handle to the right to copy and paste the content.
8. C1:D1 is not a merged cell.
9. The letter a in A1:B1 appears separately in C1 and D1.
10. Select A1:B1.
11. Drag the handle downwards to copy and paste the content.
12. A2:B2 is not a merged cell.
13. The letter a in A1:B1 appears separately in A2 and A3.
Current behavior: Users cannot create another merged cell by dragging the handle of an existing merged cell.
Expected behavior: Users can create another merged cell by dragging the handle of an existing merged cell.
C. H. D.
Operating System: Debian
Version: 126.96.36.199 rc
can you change the importance from normal to enhancement.
High (merged cells pretty common, copying these should work as expected which is to carry the merge with the copy/paste and/or drag - copy/paste works as expect, dragging does not)
*** Bug 79042 has been marked as a duplicate of this bug. ***
A decision has to be made, whether formatting should be carried over or not. Ideally, the user should be able to chose. If that was implemented, Bug 40993 would be resolved, too.
*** Bug 86908 has been marked as a duplicate of this bug. ***
I tested the behaviour of MS Office 365 and with Excel you can drag merged cells as specified in the "Expected behavior" of the Description.
Tested with Office 365:
* Version: 15.0.4701.1002
* Locale: it_IT
* OS: Windows 7 Home Premium SP1 x86
Why are we bumping pet enhancement requests to highest? Makes literally no sense....setting back to medium - as all enhancements should be. Enhancements are by definition "pet" requests thus highest (equivalent to MAB) is not appropriate.
*** Bug 119817 has been marked as a duplicate of this bug. ***
*** Bug 85322 has been marked as a duplicate of this bug. ***
Attila Szűcs committed a patch related to this issue.
It has been pushed to "master":
tdf#40993 tdf#59585 sc fill: copy merged cell structure
It will be available in 7.1.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
This fix does not handle filtred row case...
If you have an idea how to fill merged cells through hidden rows, please create a new bug ticket explaining the desired workflow.
This seems to be an impossible case.. even excel does not handle every possible case well.
If we fill 1x2 merged cells down.. we should see 1x2 cells no matter if there is filtered row or not... And the hided cells should not change by the fill.
If there is a filtered row in the middle of a now copyied 1x2 cell.. then turning off the filtering should unhide the filtered row..
what should we display then?
we would expect to see the previously hidden cell in the center with its old value ... and around it the merged cell... like:
merged cell upper half
previously hidden cell
merged cell lower half
In this case Excel does simply drop the lower half of the merged cell.
But in LO we can have important data even in the lower half of the merged cell... like data for other cells formulas... do we want to drop that too?
more complex problem is when we fill down 2 columns with different merged cells.. like left column is 1x2 cell.. and right column is 1x1 + 1x1 cell
normally they would be aligned to each other ..
but if a hidden row would cut a merged cell in half only in 1 column.. then the next filled merged cells move 1 cell upper... while the other column stay the same..