Created attachment 153356 [details] Problem mit Cell Reference 1. click on cell B1 2. go to the left corner of the cell --> cross 3. Klick the cross, move right for two cells 4. WRONG Content C1 = $A2 instead of $A3 D1 = $A2 instead of $A4
There is not a bug, if drag to the right, column remains it's an absolute column reference $A, and row also remain because you are dragging along the same row, although it it is relative, of course doesn't change. https://help.libreoffice.org/6.3/en-US/text/scalc/guide/relativ_absolut_ref.html?DbPAR=CALC#bm_id3156423
Thank you for the answer. The manual solution to my problem: a) copy range b) special paste c) transpose Works, but is only static. --- Thank you for your help.