https://bugs.documentfoundation.org/show_bug.cgi?id=121307
Roman Kuznetsov <79045_79045@mail.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |79045_79045@mail.ru
--- Comment #8 from Roman Kuznetsov <79045_79045@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.
Context
- [Libreoffice-ux-advise] [Bug 121307] Table Design from Impress should be available in Calc and Writer · bugzilla-daemon
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.