Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.