Re: [libreoffice-users] Calc - Auto fill stepped cell reference

IGraham wrote:
> Hello and good morning
>
> Calc
> Is it possible to auto fill a stepped cell reference ?  I've been trying
> without result
> What i want is in a cell (or two ) a cell reference, to highlight that cell
> and drag down
> So the first few cells might be
> A1
> A8
> A16
>
> highlighting and dropping would produce
> A1
> A8
> A16
> A24
> A32
> A40
> etc
> I've got a few columns needing the same stepped cell reference and this
> could save me some time

Fill in the first three cells as you explained:
  A1
  A8
  A16
Then select the second and third (i.e. A8 and A16), and drag the handle 
at the lower right corner of the selection down. Calc fills the range 
using the same interval as between the selected cells (i.e. 8) - so 
subsequent cells are filled with "A24", "A32", etc.

It doesn't work if you select all three, as the intervals between the 
first and second and second and third are different.

Mark.

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted