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

Autoselecting Column Data - AutoFill

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


Joined: 27 Oct 2003
Posts: 2

PostPosted: Mon Oct 27, 2003 3:05 pm    Post subject: Autoselecting Column Data - AutoFill Reply with quote

I import large quantities of data from text files and then perform operations on the columns. I am using version 1.1 on Linux.

I have spent a lot of hours trying to figure out how to:

1. Select a column from my current position (say A2) to the last data point (say A19332). Other programs perform this by double clicking the bottom of the input box while holding the shift key. Since the number of rows vary from file to file and are ~20k lines long this is highly desirable.

-- or --

2. AutoFill data down to the last data point. Say there is data from A2 - A19432 and I enter in B2 "=log(A2;2)". Is there a way to automagically fill this down to the last datapoint? In gnumeric you can do this by double clicking the little black box of the input box. Edit-Fill->Down works OK if I delete the column header and select the column, but it continues the formula past the last data point to row 32000.

Thanks,

-ryan
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: Mon Oct 27, 2003 9:37 pm    Post subject: Reply with quote

1. select from current active cell down to bottom of filled cells

CTRL_SHIFT_DownArrow

2. to fill down, select as above then EDIT FILL DOWN

have a look at Help 'Shortcut Keys for Spreadsheets'
Back to top
View user's profile Send private message
roltman
Newbie
Newbie


Joined: 27 Oct 2003
Posts: 2

PostPosted: Wed Oct 29, 2003 8:02 am    Post subject: Reply with quote

Works like a charm.

Thanks for the pointer on where to find these things in help.

-ryan
Back to top
View user's profile Send private message AIM Address
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