https://bugs.documentfoundation.org/show_bug.cgi?id=173608
--- Comment #4 from Icy Comet <[email protected]> --- Reading this indeed suggests so: "In a copied tab, it is needed to adjust the relative tab references, as they still need to point to the same tab, but because the reference is relative, the actual value needs to change (for example from index -1 to -2). This mechanism was missing." This reasoning makes no sense to me. If the user wants to be able to copy sheets, but have references still point to a cell in the same absolute sheet, the user should use absolute sheet references and not relative references. As a matter of fact, I have used such absolute sheet references and they have worked fine for years. Now someone has decided that in 26.8.0 the user only gets to use absolute references, even though they are formatted as regular relative references. That is weird. The old behaviour between sheets was consistent with how relative references work for cells within the same sheet: if you copy a cell containing a formula and paste it for example two columns to the right, the relative references will be adjusted accordingly. The new behaviour is inconsistent between working with cells and working with sheets. IMO this change needs to be reverted. -- You are receiving this mail because: You are the assignee for the bug.
