printing page number in open office calc spreadsheet

1. Turn on header / footer

go to Format > Page > header / footer

check "turn on footer"

2. Insert page number in the above footer -

go to Edit > Hearders & Footers

Choose styles of page numbering.