[Libreoffice-bugs] [Bug 127633] New: Relative Cells

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 127633
           Summary: Relative Cells
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: rick.c.hodgin at gmail.com

Description:
I've had some big spreadsheets over the years. The further you get away from A1
the more complex and confusing it is to input formulas and keep track of
things.

I've had the idea for relative cells. You mark off a rectangle by selecting it,
then right-click, and a menu option says "View Relative."

In this mode, whatever cells are in the selected area become relative to a
temporary naming relative to A1 being the upper-left-most cell, and proceed
normally throughout the area.

This allows people to work with smaller numbers even when they're out in AA218
and thereabouts. Rather than typing =AA281+AB283, they can use relative cells
for input as =A1+B3. Much simpler on the eye.  To access the real A1 or B3 or
other cell, use a syntax like !A1+!B3 or some such.

Internally, it's still recorded as AA281 amnd AB283, but for presentation,
because it's relative to that A1 window, we see it in that easier range.

It would be undone by clicking the X in the upper-right area. It could also be
dragged around so the relative area moves into other cells. The sides could be
expanded or collapsed as necessary to resize. A hotkey could be setup to
provide a standard 12 x 20 grid or whatever common size would be nice. Once the
relative grid is there, it can be dragged as needed.

Just seems like a nice way to view complex data when it's out there in the
spreadsheet sticks.

Actual Results:
This is an enhancement.  The outline above is just guidance.  It can be
expanded / altered as needed to align with existing standards and practices. 
Just the general concept of a relative-to-A1 addressing is the real feature.

Expected Results:
This is an enhancement.  Not sure why I have to fill out this field. :-)


Reproducible: Always


User Profile Reset: No



Additional Info:
It's a nice feature to makes large spreadsheets easier to work with.

-- 
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/20190919/d5bd736b/attachment-0001.html>