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

is this possible?

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


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Tue Feb 01, 2005 7:07 am    Post subject: is this possible? Reply with quote

i have tried to copy a formula into an entire column by selecting the column (ie click on D) and pasting .
The programme then closes down! Am i trying the unallowable?
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
DiGro
Super User
Super User


Joined: 02 Jun 2004
Posts: 1415
Location: Hoorn NH, The Netherlands

PostPosted: Tue Feb 01, 2005 7:44 am    Post subject: Reply with quote

Probably doing something that is unwanted, but I don't know what.

You can't copy 1 (one) formula into an entire column. I tried to do the same but
it pasted the formula into the top-cell of the column.

From there you have to fillout the entire column.
Select the cell with the formula and pull that one down the column
(take it at the right lower bottom of the cell)

This will also make you're formula use the right references.

DiGro
Back to top
View user's profile Send private message
koenh
Power User
Power User


Joined: 27 Feb 2004
Posts: 51

PostPosted: Wed Feb 02, 2005 5:27 am    Post subject: Reply with quote

i tried the same thing and everything worked well...
I use v 1.9.69

greetz...
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Wed Feb 02, 2005 7:04 am    Post subject: Re: is this possible? Reply with quote

carl wrote:
i have tried to copy a formula into an entire column by selecting the column (ie click on D) and pasting .
The programme then closes down! Am i trying the unallowable?


I put values in A1, B1, C1, and the sum forula in D1. Copied D1 [CTRL-C]. Selected all of column D, and pasted [CTRL-V]. No problem.

David.
Back to top
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Thu Feb 03, 2005 12:36 am    Post subject: Reply with quote

Quote:
I put values in A1, B1, C1, and the sum forula in D1. Copied D1 [CTRL-C]. Selected all of column D, and pasted [CTRL-V]. No problem

not always but often it crashes
_________________
carl
Using OpenOffice.org 2 on XP sp2
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