[Libreoffice-bugs] [Bug 121307] Table Design from Impress should be available in Calc and Writer

[bugzilla-daemon at bugs.documentfoundation.org]

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

Roman Kuznetsov <79045_79045 at mail.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |79045_79045 at mail.ru

--- Comment #8 from Roman Kuznetsov <79045_79045 at mail.ru> ---
just for info: 
"Format as Table" in Excel (2010 and more new) allows not only select a visual
style for range but also:
1. Every that "table" on sheet has its own name you can use in formulas with,
for example, SUMIF or VLOOKUP
2. "Table" automatic changes its size if you add row or column
3. In this "table" will be active autofilter by default
4. When you add rows in end of "table" then they automatic get all formulas
from previous row
5. When you add columns in "table" and enter a formula in to one cell then all
cells in this column will be have this formula automatically
6. If you scroll your "table" down, then headers (from first row of "table")
will be show in row with column number (will don't need freeze first row)
7. When you enable Total row for this "table" you can select in Total row some
different function (sum, average, count, etc.)

-- 
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/20181110/0853ad2e/attachment.html>