You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by David Deeks <pr...@gmail.com> on 2020/04/27 17:08:01 UTC
Numbers automatically advance in spreadsheet columns
I have been an Open Office user for many years, but only recently discovered this group, and have already learned a couple of things!
I am hoping however that someone can help with a specific and longstanding problem with numbers in spreadsheet columns. If I have a cell with a number in that I want repeated down the column, I would love to able to simply highlight the cell and drag down the column. The problem is that in each line the numbers always increase by 1. This is useful of course sometimes, but not always! I have tried all formats, including text etc, and feel as though I’ve looked through every menu - but cannot find how to stop it doing this. I am sure there must be a way?
Thanks
David Deeks
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Numbers automatically advance in spreadsheet columns
Posted by "WA.TWORSX via AOL" <wa...@verizon.net.INVALID>.
TNX Alan:
I had experienced same as David did; now I know that I must hold Ctrl
key to repeat the number while dragging the mouse pointer.
Regards, and please ALL, stay safe.
VinceB.
On 4/27/2020 1:13 PM, Alan B wrote:
> Hello David,
>
> Have you tried,
> - select cell
> - grab cell handle at bottom right with mouse left click and hold
> - press and hold Ctrl key
> - drag mouse
>
> That will produce a column that repeats the number in the highlighted cell.
>
> On Mon, Apr 27, 2020 at 1:08 PM David Deeks <pr...@gmail.com>
> wrote:
>
>> I have been an Open Office user for many years, but only recently
>> discovered this group, and have already learned a couple of things!
>>
>> I am hoping however that someone can help with a specific and longstanding
>> problem with numbers in spreadsheet columns. If I have a cell with a number
>> in that I want repeated down the column, I would love to able to simply
>> highlight the cell and drag down the column. The problem is that in each
>> line the numbers always increase by 1. This is useful of course sometimes,
>> but not always! I have tried all formats, including text etc, and feel as
>> though I’ve looked through every menu - but cannot find how to stop it
>> doing this. I am sure there must be a way?
>>
>> Thanks
>>
>> David Deeks
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>> For additional commands, e-mail: users-help@openoffice.apache.org
>>
>>
Re: Numbers automatically advance in spreadsheet columns
Posted by Alan B <ab...@gmail.com>.
Hello David,
Have you tried,
- select cell
- grab cell handle at bottom right with mouse left click and hold
- press and hold Ctrl key
- drag mouse
That will produce a column that repeats the number in the highlighted cell.
On Mon, Apr 27, 2020 at 1:08 PM David Deeks <pr...@gmail.com>
wrote:
> I have been an Open Office user for many years, but only recently
> discovered this group, and have already learned a couple of things!
>
> I am hoping however that someone can help with a specific and longstanding
> problem with numbers in spreadsheet columns. If I have a cell with a number
> in that I want repeated down the column, I would love to able to simply
> highlight the cell and drag down the column. The problem is that in each
> line the numbers always increase by 1. This is useful of course sometimes,
> but not always! I have tried all formats, including text etc, and feel as
> though I’ve looked through every menu - but cannot find how to stop it
> doing this. I am sure there must be a way?
>
> Thanks
>
> David Deeks
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>
--
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011
Re: Numbers automatically advance in spreadsheet columns
Posted by Brian Barker <b....@btinternet.com.INVALID>.
At 18:08 27/04/2020 +0100, David Deeks wrote:
>I have been an Open Office user for many years, but only recently
>discovered this group, and have already learned a couple of things!
Only two?
;^)
>I am hoping however that someone can help with a specific and
>longstanding problem with numbers in spreadsheet columns. If I have
>a cell with a number in that I want repeated down the column, I
>would love to able to simply highlight the cell and drag down the
>column. The problem is that in each line the numbers always increase
>by 1. This is useful of course sometimes, but not always!
There are various ways to do this.
o (As someone has already said) Use Ctrl+fill instead of normal fill.
o Enter the same number again in the cell immediately below the
original. Select both cells. (Drag over them or use click and
Shift+click). Now fill down as usual.
o Select the entire range you want filled - including your original
cell. Go to Edit | Fill > | Down.
o For more complex requirements, select the entire range and use Edit
| Fill > | Series... .
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Numbers automatically advance in spreadsheet columns
Posted by David Deeks <da...@sunderland.ac.uk>.
Thanks for this - a really useful suggestion!
David D
On Tue, 28 Apr 2020, 04:50 Jean Lear, <me...@gmail.com> wrote:
> As a regular user of Calc in Apache OpenOffice I have added two extra items
> to my tool bar (another learning curve to do this). I have added 'Fill
> Down' and 'Fill Series'
> Fill Series will bring up the Fill Series window which allows a lot of
> alternatives for what is being done in the column or row selected.
> Fill down is also useful to repeat text down a number of rows.
> Hope this extra information helps.
> Jean
>
> On Tue, Apr 28, 2020 at 4:27 AM Peter Kovacs <le...@posteo.de> wrote:
>
> > 1) Mark the Cell
> >
> > 2) Right Klick -> select copy
> >
> > 3) select first Cell of your row. (i.e. the cell below)
> >
> > 4) Press shift And mark the last cell -> you now see the rows that you
> > target marked.
> >
> > 5) right click select copy.
> >
> >
> > Am 27.04.20 um 19:08 schrieb David Deeks:
> > > I have been an Open Office user for many years, but only recently
> > discovered this group, and have already learned a couple of things!
> > >
> > > I am hoping however that someone can help with a specific and
> > longstanding problem with numbers in spreadsheet columns. If I have a
> cell
> > with a number in that I want repeated down the column, I would love to
> able
> > to simply highlight the cell and drag down the column. The problem is
> that
> > in each line the numbers always increase by 1. This is useful of course
> > sometimes, but not always! I have tried all formats, including text etc,
> > and feel as though I’ve looked through every menu - but cannot find how
> to
> > stop it doing this. I am sure there must be a way?
> > >
> > > Thanks
> > >
> > > David Deeks
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> > > For additional commands, e-mail: users-help@openoffice.apache.org
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> > For additional commands, e-mail: users-help@openoffice.apache.org
> >
> >
>
Re: Numbers automatically advance in spreadsheet columns
Posted by Jean Lear <me...@gmail.com>.
As a regular user of Calc in Apache OpenOffice I have added two extra items
to my tool bar (another learning curve to do this). I have added 'Fill
Down' and 'Fill Series'
Fill Series will bring up the Fill Series window which allows a lot of
alternatives for what is being done in the column or row selected.
Fill down is also useful to repeat text down a number of rows.
Hope this extra information helps.
Jean
On Tue, Apr 28, 2020 at 4:27 AM Peter Kovacs <le...@posteo.de> wrote:
> 1) Mark the Cell
>
> 2) Right Klick -> select copy
>
> 3) select first Cell of your row. (i.e. the cell below)
>
> 4) Press shift And mark the last cell -> you now see the rows that you
> target marked.
>
> 5) right click select copy.
>
>
> Am 27.04.20 um 19:08 schrieb David Deeks:
> > I have been an Open Office user for many years, but only recently
> discovered this group, and have already learned a couple of things!
> >
> > I am hoping however that someone can help with a specific and
> longstanding problem with numbers in spreadsheet columns. If I have a cell
> with a number in that I want repeated down the column, I would love to able
> to simply highlight the cell and drag down the column. The problem is that
> in each line the numbers always increase by 1. This is useful of course
> sometimes, but not always! I have tried all formats, including text etc,
> and feel as though I’ve looked through every menu - but cannot find how to
> stop it doing this. I am sure there must be a way?
> >
> > Thanks
> >
> > David Deeks
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> > For additional commands, e-mail: users-help@openoffice.apache.org
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>
Re: Numbers automatically advance in spreadsheet columns
Posted by Peter Kovacs <le...@posteo.de>.
1) Mark the Cell
2) Right Klick -> select copy
3) select first Cell of your row. (i.e. the cell below)
4) Press shift And mark the last cell -> you now see the rows that you
target marked.
5) right click select copy.
Am 27.04.20 um 19:08 schrieb David Deeks:
> I have been an Open Office user for many years, but only recently discovered this group, and have already learned a couple of things!
>
> I am hoping however that someone can help with a specific and longstanding problem with numbers in spreadsheet columns. If I have a cell with a number in that I want repeated down the column, I would love to able to simply highlight the cell and drag down the column. The problem is that in each line the numbers always increase by 1. This is useful of course sometimes, but not always! I have tried all formats, including text etc, and feel as though I’ve looked through every menu - but cannot find how to stop it doing this. I am sure there must be a way?
>
> Thanks
>
> David Deeks
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Numbers automatically advance in spreadsheet columns
Posted by David Deeks <pr...@gmail.com>.
Brian, Alan
Thanks so much for your very prompt replies - problem solved!
Well pleased I discovered the group!
All best
David
> On 27 Apr 2020, at 18:25, Brian Barker <b....@btinternet.com.INVALID> wrote:
>
> At 18:08 27/04/2020 +0100, David Deeks wrote:
>> I have been an Open Office user for many years, but only recently discovered this group, and have already learned a couple of things!
>
> Only two?
>
> ;^)
>
>> I am hoping however that someone can help with a specific and longstanding problem with numbers in spreadsheet columns. If I have a cell with a number in that I want repeated down the column, I would love to able to simply highlight the cell and drag down the column. The problem is that in each line the numbers always increase by 1. This is useful of course sometimes, but not always!
>
> There are various ways to do this.
>
> o (As someone has already said) Use Ctrl+fill instead of normal fill.
>
> o Enter the same number again in the cell immediately below the original. Select both cells. (Drag over them or use click and Shift+click). Now fill down as usual.
>
> o Select the entire range you want filled - including your original cell. Go to Edit | Fill > | Down.
>
> o For more complex requirements, select the entire range and use Edit | Fill > | Series... .
>
> I trust this helps.
>
> Brian Barker
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org