[libreoffice-users] Re: Basic use of the spreadsheet tools

On 26-12-2011 14:37, Stefan Weigel wrote:
> Hi,
>
> Am 26.12.2011 11:24, schrieb Luuk:
>
> > Before creating the 'auto' filter, select all columns that are involved,
> > or (better) select all the cells involved.
>
> I would rather recommend to select one single cell inside the list
> of data. Calc will automatically detect the data range.
>
> Stefan

But, be aware, that if you add a new line to your data (at the end),
that this line will not be in the range of filtered items.

Thats why i mostly select all columns. this way new data is
'automagically' included in the filter.

-- 
Luuk


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted