I had a specific need for a column to show the same number for 12 cells going down then increase that number by 1 for 12 more cells, then increase that number by 1 for 12 cell.....etc. Copy and paste or fill down, or fill down series or even autofill did not give an option.

What I did notice if I filled the first 24 cells then grabbed the fill handle in the bottom right corner of the last cell with a number, and dragged down, OpenOffice autofill would try to figure what series I wanted but could not replicate it. It would fill twice as many cells then add one number. Every 24 cells, instead of every 12 cells, the number went up by 1.

So I tricked it by filling in 6 of the first number and 6 of the next higher number then fill down and got the results I needed.

Wonder Why? Are there better ways?

Hope this might help someone.

Regards,

atzi