Ask Your Question
0

Autofill in merged cells splits them

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

martin87i gravatar image

Using Libreoffice Version: 5.3.1.2 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

1 Answer

Sort by » oldest newest most voted
0

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

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

Stats

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

Seen: 207 times

Last updated: Oct 11 '17