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: [email protected] 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
