https://bugs.documentfoundation.org/show_bug.cgi?id=154075
--- Comment #7 from ady <[email protected]> --- (In reply to Justin L from comment #6) > I have > coded up your suggested sequence. > https://gerrit.libreoffice.org/c/core/+/148516 I have no coding skills/knowledge in order to comment about it. I do thank you. To sum-up, from the POV of final users, the resulting change should be: 0. $Sheet2.A1 0. $Sheet2.A1 1. Sheet2.$A$1 1. $Sheet2.$A$1 2. Sheet2.A$1 2. $Sheet2.A$1 3. Sheet2.$A1 3. $Sheet2.$A1 4. Sheet2.A1 4. Sheet2.A1 5. $Sheet2.$A$1 5. Sheet2.$A$1 6. $Sheet2.A$1 6. Sheet2.A$1 7. $Sheet2.$A1 7. Sheet2.$A1 It is clear that the proposed change is in the absolute vs relative reference for worksheets, and there is no effect for rows/columns. For same-sheet formulas, there is no effect either. I think it would reduce some confusion (and unneeded "bug reports" and forum posts) on users that are unaware of the existence of relative worksheet references, and it would also reduce the amount of F4s. -- You are receiving this mail because: You are the assignee for the bug.
