Created attachment 125318 [details] some background coloring and comments are added to help understand How it happens: I am reorganizing a table that goes from 1 to 6, A to AC. I want the values of all the odd-line cells to go into a single line elsewhere (say line 8), going through lines before columns (will make sense just below). In A8, I attribute A1 (=A1), in B8 (=A3), C8 (=A5). Select these cells, and drag to the right. Cell D8 becomes (=D1), E8 (=D3), F8 (=D5). Calc understands that the formulas should pick up from the column it's in. To try to avoid that, I kept on filling through to F8, then selected (6 values this time) and dragged again. G8 becomes (=G1). Same thing happens. If I try to begin attributing values in another column, say B8, the first cell automatically filled will acts nearly the same way. Instead of getting the value of the same column, it gets 'column+1'. Things get a whole lot crazier when I copy and paste the cells on line 8 elsewhere. This part is so messed up it could probably go on another bug report. I'll attach the spreadsheet I'm using so others can confirm.
It should have been clearly said that I expected calc to follow the pattern in the selected cells, independently of where they're at. When I filled 6 cells myself, I change the columns from A to B, and use the same lines (So: A1 A2 A3 B1 B3 B5). I expected that selecting these and dragging, would generate (C1 C3 C5 D1 D3 D5...) Instead it gives me a pettern starting at the current column (G1 G3 G5)
Sorry @Sandro, please take a look in calc documentation "chapter 7 Formulas and Functions." for Absolute and relatives references (pg. 13). https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide If I'm understand right what you explain is not s but, you need to use a mix of relative and absolutes references. e.g.: A8: =A$1 copy to B10 B10: =B$1 Resolved a not a bug, please if you are not agree, reopen it. You can ask your question in ask.libreoffice.org