Can’t get Calc to follow a series I’ve defined, where the increment is an increment in the position of the cell.
Bit difficult to explain, so I’ll show it.
What I want now is to select B1:B2 [edited], and have B3 filled with “=A5”, B4 with “=A7”, and so on.
The problem is that calc fills B3 with “=A3”.
“… mark B1+B2 …”
contains an annoying misuse of the operator “+”. Please replace the quoted text piece with “…select B1:B2…” (or similar) to avoid misunderstandings.
Thanks. Fixed.
You didn’t use Fill Series, did you?
An automatic Fill Down unavoidably needs to do an “algorithmic guess” concerning what a user might expect.
You may know the fact of infinitely many ways to continue a series of only a few known elements from brain-twisters.
I don’t know an explicit specification of “Auto Fill Down” if formulas are afflicted.
Continue 0, 1, 1, … (mostly given without the starting 0)
A fascinating solution: 0, 1, 1, 2, 3, 5, … (The Fibonacci series)
=OFFSET(A$1;(ROW(A1)-ROW(A$1))*2;0) in B1 and then filled down may help you?