<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 - Feature Request: Add Calc Tables with functionality similar to Excel tables"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132780">132780</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Feature Request: Add Calc Tables with functionality similar to Excel tables
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.0.3 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>vermelhusco1904@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=160446" name="attach_160446" title="Gif depicting excel tables functionality">attachment 160446</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=160446&action=edit" title="Gif depicting excel tables functionality">[details]</a></span>
Gif depicting excel tables functionality
One extremely handy feature present in Excel that Calc lacks is the capacity to
create tables inside Excel. These tables offer several functionalities besides
what is available to the normal spreadsheet cells, and what can be achieved
with just Sort and Filter of a selection of cells in Calc. This feature was
previously known as an Excel list.
The purpose of Excel tables is to manage and analyze related data easily.
These tables have several elements:
Header row - All tables have filtering enabled in header row to sort or filter
quickly.
Banded rows - Alternate shading to distinguish data.
Calculated column - insert a formula in one cell in a table column and you can
create a column in which that formula is applied to all cells in the same table
column.
Total row - Can add a total row to a table. Excel will provide an AutoSum
drop-down liist to select from functions
Sizing handle - a sizing handle in the lower right corner that allows to drag
and make the table the size I want (selecting which cells are part of it).
Steps to create a Table in Excel 365:
1 - Select range of interest in a sheet,
2 - Go to Home -> Format as Table or Insert -> Table,
3 - Pick a style,
4 - Select if you want headers in dialog, click OK.
Functionalities of tables: besides the previously mentioned and VERY important:
1 - When you add new values to the cells below the table, it automatically
extends the table to include them.
2 - make a chart of a table, and any time the table is extended the chart
auto-updates to include the new cells.
3 - If you paste that chart in a Powerpoint presentation, whenever you have the
Excel spreadsheet opened side by side the chart in the Powerpoint file will
also update if "Refresh Data" is selected.
These features are important for people that are dealing with constantly
growing related data, and for creating charts that auto-update allowing a
decree of automatization that is not possible in Calc. This is an extensive
feature but it's a feature that is also present in WPS Office and Softmaker
Office besides Microsoft Office.
I would like to request that a similar feature is created since it vastly
improves the use cases of Calc.</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>