At 02:03 26/07/2014 -0700, Graham Lovatt wrote:
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
Your first interval is seven and your second one eight. Will the next
be nine, or what?
highlighting and dropping would produce
A1
A8
A16
A24
A32
A40
etc
That's supposing that Calc can read your mind and guess that the
subsequent gaps should all be eight - despite your first pattern
example gap being seven.
I've got a few columns needing the same stepped cell reference and
this could save me some time
At 02:35 26/07/2014 -0700, Graham Lovatt wrote:
Slight edit to my original post I missed out the =
Er, I wonder where that should have been in your message!
The simplest way would be to construct the formula yourself. Let's
suppose you actually want =A8, =A16, =A24, and so on. You could do this using
="A"&ROW()*8
where the ROW() function returns the number of the row containing the
formula itself. But that creates a text string that looks like a
formula, not a formula as such. You can interpret text as a formula
using the INDIRECT() function, so you need something like
=INDIRECT("A"&ROW()*8)
which you can copy or fill down the column.
If you want A1, A9, A17, and so on, you could use
=INDIRECT("A"&ROW()*8-7)
I trust this helps.
Brian Barker
--
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.