E.g. I have this:
and I want this:
I tried Insert Rows Below, but that doesn’t carry the current row’s merges.
There’s Cut, Insert Rows Above, Paste - but as expected that messes up references.
I find no way to copy and paste parts of merges.
Starting from selected 3rd row:
- ⇒Insert Row above
- c4 ⇒ ctrl+x
-
c3 ⇒ ctrl+v
done
1 Like
Thanks. That works, except on the first row:
Insert Rows Below
Version: 24.8.5.2 (X86_64) / LibreOffice Community
Build ID: 480(Build:2)
CPU threads: 4; OS: Linux 6.4; UI render: default; VCL: gtk3
Locale: es-MX (en_US.UTF-8); UI: en-US
Calc: threaded
I fear it should work with any random pattern e.g. merged A1:A3 ; B2:B4 etc.
1 - Select line 5, Insert line above
2 - Select A5:C5
3 - Ctrl + D, press Delete
Hello @schiavinatto,
If the start case is the first screenshot we must work with row 3 (not 5). But there could be a bug here (tdf#168216), because in the merged cells, although cells borders update, the active cell border don’t.
See the B1:B4 in the name box.
