https://bugs.documentfoundation.org/show_bug.cgi?id=127633
--- Comment #6 from Rick C. Hodgin <rick.c.hodgin@gmail.com> ---
Taking this whole "Relative A1" concept a step further, it's almost like the
idea of having virtual spreadsheets within a root spreadsheet.
Imagine you're on cell K92, and you need a calculation to feed into that cell's
value. Rather than consume 2D space in the surrounding row,col cells, you dive
into 3D and create a virtual spreadsheet at that cell which can pop up and
handle normal input.
That virtual spreadsheet pops up with a full A1..max_extent sheet available
with all of the abilities the parent had. And from there you could have more
pop up, all relative to the parent.
Rather than having new sheet tabs to select from, you can reference the
calculations directly there, at the cell, in the virtual sheet. Ctrl+PgUp
enters the virtual sheet. It pops up to a 1/3rd screen presentation by default
looking like a popup, and you can assign values to the "RESULT" name to
populate a value into that cell using something like: RESULT=[normal formulas
/ values here]. Only one RESULT cell can be used for the virtual. If you need
to update more information, reference it by a long-hand syntax identifying the
tab and cell.
There's so much possibility here. It's time to evolve a little and think
"flexibility!" (be sure you read that with the same intonation as Phlox saying,
"Optimism, Captain!")
--
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.