<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Feature Request: Add Calc Tables with functionality similar to Excel tables"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132780#c20">Comment # 20</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Feature Request: Add Calc Tables with functionality similar to Excel tables"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132780">bug 132780</a>
from <span class="vcard"><a class="email" href="mailto:jocn@protonmail.com" title="jocn@protonmail.com">jocn@protonmail.com</a>
</span></b>
<pre>Tables are ubiquitous in any Excel spreadsheet I make. I'm very happy to see
everything that's been implemented so far. It makes feature parity seem very
possible.
Here are the gaps I consider most important:
- The @ operator to specify a structured reference to a cell in the current
row. Calc's syntax to accomplish the same thing is much more verbose, implicit,
and, as far as I know, undocumented.
- Calculated columns: some way to ensure that every cell of a field inside a
database range uses the same formula, that changing the height of the range
will also copy the formula, that changing the formula in one cell will change
it for the whole column.
- The ability to rename a database range, updating the name in any references
elsewhere in the workbook.
- Formula bar autocomplete for structured reference syntax, especially when
selecting a range of cells.</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>