Ask Your Question

Autofill in merged cells splits them

asked 2017-10-11 18:21:33 +0100

martin87i gravatar image

Using Libreoffice Version: in Linux

Trying to add a growing date to merged cells. I have tried both to add two consecutive dates and use the formula ="formercell"+1 but when I drag the fill handle, the merged cells splits. Am I doing anything wrong?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-07-17 15:46:57 +0100

glococo gravatar image

updated 2019-07-17 15:47:29 +0100

I have the same problem. Not only do not copy the cell format, it even jump a number if your initial cell is merged.2019-07-17 14-46-09.png

edit flag offensive delete link more

answered 2017-10-11 23:24:26 +0100

Kruno gravatar image

Moving handle down, you also copying formating. If previous cell is not merged, next cell will split as this is controlled by formating. What you need to do is enter 11. 10. 2017 in A1 and then =A1 + 1 in B1. Now right click on B1 and click Copy. Select all cells where you need growing consecutive dates and do Right Shift + CTRL + V and select only Date and time. Click Ok.

Does it work?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-10-11 18:21:33 +0100

Seen: 559 times

Last updated: Jul 17 '19