It only copied the beginning cell to the end cell, but didn't fill all the ones in between.
Try writing it in the first cell, then click on any other cell, then click on the first again, you will then see a box with a small tag on the bottom right corner, Click and hold that tag, then drag it down to the final cell. It should copy the text (or figures) into all the cells in the column.
If it doesn't work then there must be something wrong with your Open Office.