Date: prev next · Thread: first prev next last
September 2019 Archives by date, by thread · List index


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

--- Comment #4 from Rick C. Hodgin <rick.c.hodgin@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.

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.