[Libreoffice-ux-advise] [Bug 127633] Relative Cells

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #14 from Rick C. Hodgin <rick.c.hodgin at gmail.com> ---
I was thinking this morning that 7 things would need to be modified to make
this work, and 8 if you include unit testing:

1)  An icon to toggle Relative View.

2)  A keyboard shortcut to toggle Relative View, and to turn it on or off
explicitly.

3)  A post-processing step on UI presentation, where the actual formula for the
cell is processed to reference !!native cells (like !!A1 for the real A1), and
to take anything in the visible range and PRESENT IT as a relative name.

4)  A pre-processing step on the syntax parser for formula input, that does the
reverse of 3), making the relative values be real values.

5)  A new flag in the saved ods file indicating if the sheet's in relative view
or not.

6)  An alteration to the row and column painting algorithms to paint them in
relative view mode.

7)  Changes to the help file.

8)  Unit testing.

Nothing in the core algorithms, parsers, or logic would have to change.  This
could be implemented as a visible-at-the-UI-level change only, with post- and
pre- processing code injected in 3) and 4) as indicated.

-- 
You are receiving this mail because:
You are on the CC list for the bug.