Date: prev next · Thread: first prev next last
November 2018 Archives by date, by thread · List index


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


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.