Usually when you click on the bottom-right square of a cell and drag downward, the cells will fill with sequential numbers in a list, a very handy tool.
Another handy tool is seen in the above video. This continues ADDING a certain chosen number to each subsequent cell, like an old school adding machine.
I think this should work in every version of Open Office, such as Libre Office and Apache, etc.