<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Proposed enhancement: a CYCLIC ADDRESSING mode for cells and ranges CALC, EDITING, UI"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124871">124871</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Proposed enhancement: a CYCLIC ADDRESSING mode for cells and ranges CALC, EDITING, UI
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>anthonydurham@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=150904" name="attach_150904" title="A simple example of how cyclic addressing would work, with screengrabs">attachment 150904</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=150904&action=edit" title="A simple example of how cyclic addressing would work, with screengrabs">[details]</a></span>
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>