Open Office Calc Problem

I just got Open Office Calc to do some dbf editing for my rosters. I've been trying to look for a way to add one to every entry in a column. (I'm trying to increase everyone's experience by one year and lower everyone's contract length by one year.) Help from anybody?

go into a new speadsheet and set up a formula

copy the entire column, then in the other speadsheet paste it in and then do a formula to add a year or whatever

if you dont know how to formulas in excel/open office google it

It's just adding one to a bunch of values. I've looked online and can't find anything.

....really....


=A1+1

Tried it.