Increment by 6 when I pull down cell?

When I pull a cell down the cells are usually filled with a series of numbers that increase by 1.

1, 2, 3, 4, 5 etc.

I want to pull a cell and get all the other cells filled by an increment of 6

1,7,13 etc.

How do I go about doing so?

In excel I just have to fill the first three cells with the series I want and it fills automatically. Is there any way I can do something like this in Librecalc?

Also, I would like for this to apply to formulas as well.

I enter 1 to A1, 7 to A2, select them both and drag-copy, and it works.

This works for numbers but when I try with cell references it makes no sense.

In cells B1 and B2 I enter the following: =A1 and =A7. Then, when I pull down the handle it gives me:

A1, A7, A3, A9

It makes sense, just not what you expect. It just copies the formulas as you put them: in first cell “reference to the cell to the left”, in second “reference to cell one left and 6 below”. So it goes. To make what you want, you need to construct the reference: =OFFSET($A$1;(ROW()-1)*6;0;1;1)

I don’t quite follow. This is exactly what I’m trying to do:
In column A I have references to cells on another sheet. Sheet1.A1, Sheet1.A7, Sheet1.A13 etc.
I want this series to fill automatically on the reference so I don’t have to write them manually and I get a reference of every 6th cell in Sheet1.

I provided the formula to you. You only need to add the sheet name: =OFFSET(Sheet1.$A$1;(ROW()-1)*6;0;1;1)