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

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
Of course we have no information about the OS, the office version nor file
type. But my chrystal ball tells me that it is some Excel file with a
database range imported as "Excel_FilterData_0_8_15" or something. That
imported filter range does not include the current region. In this case the
automatic detection needs to fail because the database range is explicitly
restricted.

@Robert
menu:Data>Define... might show some filterable lists with "Excel" in the
name. Select such an entry and adjust the range address to the actual cell
range that describes the full list. Hit buttons [Modify] and [OK] when you
are done. Now all the solutions that have been given to you should work
actually.

--
View this message in context: 
http://nabble.documentfoundation.org/Basic-use-of-the-spreadsheet-tools-tp3612347p3613483.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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