Summary: | Copying a column with Absolute referencing does not work | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Marty <marty.bugzilla> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | normal | CC: | marty.bugzilla |
Priority: | medium | Keywords: | needsDevAdvice |
Version: | 7.1.0.3 release | ||
Hardware: | All | ||
OS: | Windows (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: |
Description
Marty
2021-03-30 16:21:15 UTC
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. |