[Libreoffice-bugs] [Bug 132780] 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

--- Comment #19 from Thierry <t_hugue at yahoo.fr> ---
I filed a duplicate of this request (sorry !), explaining again some of the
good reasons to add this feature.

As I mentioned in my request:
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
- ...


And I fully agree with @Pedro : no, this is not a bug of Calc loosing
formatting, but a request for enhancement.
=> we are looking for introducing this notion of "table"

I really think we need this feature in Calc, to be able to continue using
LibreOffice as a standalone alternative to Microsoft Office in a consistent and
effective way...

I also realize it may not be easy to develop, but, at least, let's track this
need and look at it...

Thanks !

-- 
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/20201229/16f0444b/attachment.htm>