[Libreoffice-bugs] [Bug 124871] New: Proposed enhancement: a CYCLIC ADDRESSING mode for cells and ranges CALC, EDITING, UI

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 124871
           Summary: Proposed enhancement: a CYCLIC ADDRESSING mode for
                    cells and ranges CALC, EDITING, UI
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: anthonydurham at gmail.com

Created attachment 150904
  --> https://bugs.documentfoundation.org/attachment.cgi?id=150904&action=edit
A simple example of how cyclic addressing would work,  with screengrabs

Cyclic addressing would allow users to treat a region of the sheet as if its
edges were joined to form a cylinder or torus. It would be useful in
mathematical and scientific applications, or wherever cyclic structures exist.

Relative addresses offset freely when copied. Absolute addresses do not offset
at all. Cyclic addresses would offset cyclically within a limited set of rows,
columns or both.

How it might work:
* Select a rectangle of cells where cyclic addressing is to operate
* Specify whether cyclic addressing applies to rows, columns or both

Suggested behaviour on copy-paste or replicate-down/across
* Relative references to cells within the rectangle are treated as cyclic, i.e.
offsets are calculated mod(n) where n is the number of rows or columns (as
applicable)
* Absolute ($) references operate as usual
* Ranges wholly within the rectangle are handled cyclically. A 'reversed' range
such as A9:A5 would include cells from A9 to the bottom of the rectangle, and
from the top of the rectangle down to A5.  
* Appropriate behaviour should be defined for ranges extending beyond the
rectangle, ranges spanning two or more such rectangles, and range references
containing both absolute and relative addresses.
PLEASE SEE ATTACHED EXAMPLE

Compatibility: earlier versions of LibreOffice should interpret cyclic
addresses as normal relative addresses.

-- 
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/20190421/bbe58a32/attachment-0001.html>