Description: If I copy an entire column that contains cells using absolute references ($), the copied cells do not reference the correct location. The absolute reference is ignored. I have to go each cell in the original column and copy them one by one for the proper absolute reference to work. Steps to Reproduce: 1.Create a cell with an absolute reference to a cell to the right. 2. Copy the entire column 3. Paste insert the column (paste all, shift cells right) 4. the cell will reference the wrong location Actual Results: the wrong cell is used by the formula Expected Results: I expect the data in the cell in the absolute reference to be used in the cell formulas in the pasted column. Reproducible: Always User Profile Reset: Yes Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no
From LibreOffice Help - https://help.libreoffice.org/latest/en-US/text/scalc/guide/relativ_absolut_ref.html?DbPAR=CALC#bm_id3156423: > Absolute and relative references are always adjusted in LibreOffice Calc > whenever the referenced area is moved. and hence I'd assume this is not a bug but intended behavior.
I don't agree: "Absolute references are used when a calculation refers to one specific cell in your sheet. If a formula that refers to exactly this cell is copied relatively to a cell below the original cell, the reference will also be moved down if you did not define the cell coordinates as absolute." Note the "if you did not define the cell coordinates as absolute."
(In reply to Marty from comment #2) > I don't agree: "Absolute references are used when a calculation refers to > one specific cell in your sheet. You are free to disagree - of course. But you don't just copy but perform a shift as well, which is a "move" from my perspective.
Sorry. You are wrong.