[Libreoffice-ux-advise] [Bug 154075] Calc's F4 absolute cycle is sub-optimal when starting from a sheet-only absolute reference

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Mar 19 12:49:42 UTC 2023


https://bugs.documentfoundation.org/show_bug.cgi?id=154075

--- Comment #8 from ady <adylo811517 at gmail.com> ---
> To sum-up, from the POV of final users, the resulting change should be:
> 

  From current:         To Proposed:

> 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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.


More information about the Libreoffice-ux-advise mailing list