[Libreoffice-bugs] [Bug 132780] New: Feature Request: Add Calc Tables with functionality similar to Excel tables

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 132780
           Summary: Feature Request: Add Calc Tables with functionality
                    similar to Excel tables
           Product: LibreOffice
           Version: 6.4.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: vermelhusco1904 at gmail.com

Created attachment 160446
  --> https://bugs.documentfoundation.org/attachment.cgi?id=160446&action=edit
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.

-- 
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/20200506/0e2c52e1/attachment.htm>