OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Automatic Incrementing

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
prime23
General User
General User


Joined: 04 Feb 2004
Posts: 5

PostPosted: Thu Feb 05, 2004 6:13 pm    Post subject: Automatic Incrementing Reply with quote

Hey all. Got another, probably stupid, newbie question. When using calc is there a way to automatically fill a column with incremented numbers. For Example, I would like to fill column a with the numbers 1^2, 2^2, 3^2, ..... , 46^2. Is there an easy way to do this up to a specified number? Any help would be GREATLY appreciated. Thanks.
_________________
Pat O'Shea
Mathematics Student/Programmer
Antioch College
Back to top
View user's profile Send private message AIM Address
dfrench
Moderator
Moderator


Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand

PostPosted: Thu Feb 05, 2004 9:28 pm    Post subject: Reply with quote

Edit Fill Series will do the incremented fill and give you a linear series put a formula in the next column to get the ^2
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group