| View previous topic :: View next topic |
| Author |
Message |
carl
Super User
Joined: 21 Apr 2003
Posts: 920
Location: Germany
|
 Posted: Tue Feb 01, 2005 7:07 am Post subject: is this possible? |
 |
|
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 |
|
 |
DiGro
Super User
Joined: 02 Jun 2004
Posts: 1208
Location: Hoorn NH, The Netherlands
|
| Posted: Tue Feb 01, 2005 7:44 am Post subject: |
|
|
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 |
|
|
koenh
Power User
Joined: 27 Feb 2004
Posts: 51
|
| Posted: Wed Feb 02, 2005 5:27 am Post subject: |
|
|
i tried the same thing and everything worked well...
I use v 1.9.69
greetz... |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Wed Feb 02, 2005 7:04 am Post subject: Re: is this possible? |
|
|
| 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 |
|
|
carl
Super User
Joined: 21 Apr 2003
Posts: 920
Location: Germany
|
| Posted: Thu Feb 03, 2005 12:36 am Post subject: |
|
|
| 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 |
|
|
|
