Open Office Calc Problem
5 posts
• Page 1 of 1
Open Office Calc Problem
by rise on Tue Oct 26, 2010 8:55 am
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?
-
rise - But here, at the top of the world, where I raise my hands and I clench my fists...
- Posts: 5266
- Joined: Tue Apr 13, 2010 9:52 am
- Location: buzz city
Re: Open Office Calc Problem
by JaoSming on Tue Oct 26, 2010 9:14 am
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
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
- JaoSming
- 2KTV Producer
- Posts: 29904
- Joined: Tue Sep 13, 2005 12:45 am
- Location: 2K
Re: Open Office Calc Problem
by rise on Tue Oct 26, 2010 9:40 am
It's just adding one to a bunch of values. I've looked online and can't find anything.
-
rise - But here, at the top of the world, where I raise my hands and I clench my fists...
- Posts: 5266
- Joined: Tue Apr 13, 2010 9:52 am
- Location: buzz city
Re: Open Office Calc Problem
by JaoSming on Tue Oct 26, 2010 9:56 am
....really....
=A1+1
=A1+1
- JaoSming
- 2KTV Producer
- Posts: 29904
- Joined: Tue Sep 13, 2005 12:45 am
- Location: 2K
-
rise - But here, at the top of the world, where I raise my hands and I clench my fists...
- Posts: 5266
- Joined: Tue Apr 13, 2010 9:52 am
- Location: buzz city
5 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 2 guests