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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Nov 10 13:01:10 UTC 2018


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 on the CC list for the bug.

More information about the Libreoffice-ux-advise mailing list