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
- [Libreoffice-ux-advise] [Bug 127633] Relative Cells · bugzilla-daemon
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.