https://bugs.documentfoundation.org/show_bug.cgi?id=98440
Eyal Rozenberg <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |libreoffice-ux-advise@lists | |.freedesktop.org --- Comment #9 from Eyal Rozenberg <[email protected]> --- A few observations: * This happens when copying any (horizontal) range of cells containing a merged cell, onto a corresponding horizontal range in another row. It can be the entire line, part of the line, or just the merged cell itself. For example, in attachment 123352, copy just the second cell (a merging of columns 2 and 3), containing "Ttt", onto the second and third cells of the first row, which are not merged. The result will be two cells, not one merged cell; and the contents will be "Ttt" in each of the two cells. * One could argue that the duplication is a definite bug, and the question of what to do with the merged cell is more of a behavior change request than a bug per se. Adapting what I wrote on the dupe bug, the following seem to me like legitimate behaviors when pasting a range with n-1 cells, one of which is the result of merging 2 cells, onto a range of n cells: 1. Paste the source (n-1-cell) range onto the first n-1 cells of the selected range; do not change any cell widths; do not touch the n'th target cell. 2. Paste the source (n-1-cell) range onto the first n-1 cells of the selected range; clear the contents of the n'th range cell (as though it had been selected and Delete was pressed). 3. Refuse to paste due to the incompatible range sizes (problematic, but avoids undesirable action) 4. Merge the appropriate two cells of the target range, then copy the corresponding contents between n-1 and n-1 cells. 5. Open a dialog asking what to do (and offer some of the options above). Independently of the above, this may be an opportunite for placing a hovering mini-toolbar/mini-buttonmenu, like MSO offers after some paste operations. -- You are receiving this mail because: You are the assignee for the bug.
