Micoshaft oriffice no more! - Use OpenOffice
in [UK Linux]
|
Prev: (F3) Find Files can't work, after installing SP3 ; os says a
Next: Installing package ending rpm.run ?
From: Gordon on 29 Jan 2010 11:02 On 28/01/2010 23:49, R. Georgeson wrote: > On Thu, 28 Jan 2010 20:51:49 +1300, zed wrote: > >> Conor<conor(a)gmx.co.uk> wrote: >> > >>> OK, tried to do this in Calc today. >>> >>> Tried dragging down columns to get a value un each subsequent row to >>> increase in 10's (10,20,30 etc). It steadfastly refused to even when I >>> manually entered the first and second values and instead was intent in >>> going up in 1's. >> >> Highlight column - Click on Edit - Choose Fill-Series - Enter Start value >> (10) - Enter Increment (10) - Click O.K. It's so easy th > > Easier way is to put 10 in one cell, 20 in the next, select both and drag > the handle. Or any other start value and increment you like (including > 'Mon' and 'Tue'). Mind you I found that out by reading the help. > You mean just like Excel does? ;-)
From: David on 29 Jan 2010 15:15
"R. Georgeson" <rmg(a)nospam.zen.uk> wrote: > On Thu, 28 Jan 2010 20:51:49 +1300, zed wrote: > > > Conor <conor(a)gmx.co.uk> wrote: > > > > > > OK, tried to do this in Calc today. > >> > > > Tried dragging down columns to get a value un each subsequent row to > > > increase in 10's (10,20,30 etc). It steadfastly refused to even when I > > > manually entered the first and second values and instead was intent in > > > going up in 1's. > > > > Highlight column - Click on Edit - Choose Fill-Series - Enter Start > > value (10) - Enter Increment (10) - Click O.K. It's so easy th > > Easier way is to put 10 in one cell, 20 in the next, select both and drag > the handle. Or any other start value and increment you like (including > 'Mon' and 'Tue'). Mind you I found that out by reading the help. Ah! thank you. Could never get this to work before but concentrated on what I was doing, this time, and "all is sweet" :-) Zed -- Zed |