[Libreoffice-bugs] [Bug 127633] Relative Cells

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #6 from Rick C. Hodgin <rick.c.hodgin at 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 the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190924/2ec0d767/attachment-0001.html>