[Libreoffice-ux-advise] [Bug 127633] Relative Cells

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from Rick C. Hodgin <rick.c.hodgin at gmail.com> ---
Another option that might be simpler and just occurred to me could be a
relative view from the current visible page and visible cells.  Click the
"Relative View" icon, and the upper-left cell becomes A1.  Things proceed
across and down from there, but only on the visible page.  As you scroll
around, the upper-left cell becomes A1 in the new location.  Turn it off, back
to normal.

Cells could be displayed like this in Relative view:
[  ][ A1.AA281 ][ A2.AB283] ...

The whole purpose of this feature would be to allow easy human-readable /
writable references for quick-and-dirty calculations wherever you are in the
sheet, so you can populate a value, range of values, whatever it is, without
having to use the fully qualified multi-letter + lengthy number references. 
When you complete your work using the more convenient names, turn Relative View
off, and now the formulas are auto-updated with their more lengthy / less
convenient names.

Usage:  Toggle Relative View on/off.  Off is like it is today.  On always makes
what you see in the upper-left cell be A1, proceeding over and down from there
to something like O39 if that's the lower-right cell.  The Relative View is
always just the visible cells on-screen in this design / use scenario.  It
wouldn't work with any type of programmatic automation.

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