<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 - FORMATTING: "format as a table" - implement Excel feature"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=139291">139291</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FORMATTING: "format as a table" - implement Excel feature
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.4.2 release
</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>t_hugue@yahoo.fr
</td>
</tr></table>
<p>
<div>
<pre>Description:
This Excel feature is really a key one for a spreadsheet management tool such
as... Excel... or Calc ! We are using those tools to manipulate data, organized
in tables. That's the core feature of those tools...
Before Excel introduced the "format as table" feature, we had to do all the
stuff "by hand". AND TO MAINTAIN IT when the table content was changing. Very
uncomfortable and time consuming...
Today, with this feature, it is very simple to:
- organize dynamic data in table (named range, easier references in external
vlookup,...)
- create a footer with smart formulas (sum, subtotal,...), that remains a
footer, whatever you add/remove in the table and that don't get sorted in the
table content flow...
- add new lines in the range (simply press tab key at the end of the table)
- get formulas automatically created in the columns (limit risks of mistake)
- use explicit column titles as names in the formulas (simplify writing and
maintenance)
- get a consistent auto formatting (such as alternate colors for rows,...)
whatever sort/insert/delete action you can do on the table itself
- ...
Is there any target to get this replicated in Calc ?
For sure, from a user perspective, this is not an "advanced" feature of Excel
(even if technically, it could be a real pain to implement !)... It gets used
by many "basic users" nowadays, and is dramatically missing from Calc.
Any hope to get this in the roadmap ?
Thanks
Actual Results:
N/A
Expected Results:
Same as in Excel feature "format as table" (see description above for most
common features provided in Excel)
Reproducible: Always
User Profile Reset: No
Additional Info:
Check description field</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>