How to customize libreoffice behavior?

Question

excel

Any libreoffice experts out there? Such a question ..
I enter several numbers into cells in Calc into a line, then I leave a couple of empty ones and this construction needs to be extended further to a certain range of cells. But Calc doesn't just extend, it increments the values ​​by one after every space!
For example:
1;1;1;;; we extend in Excel, we get 1;1;1;;;1;1;1;;;1;1;1;;;
1;1;1;;; we extend in Calc, we get 1;1;1;;;2;2;2;;;3;3;3;;;
Is there a way to set this up in libre?

Answer 1

Try holding Ctrl while dragging