relgames wrote > > I have Calc file with a long list of rows, what I need is to filter those > rows by some criteria entered by user. > So, if user enters "15" into some cell, list should immediately update > itself and show only rows containing "15" > Any suggestions? >
I think using a database for such a trivial task is like using a nuclear bomb in a knife fight :) Just select the header cells, click on Data, Filter, AutoFilter Now the user just has to select 15 from the appropriate column by clicking on the button with the down arrow. -- View this message in context: http://nabble.documentfoundation.org/Calc-How-to-refresh-advanced-filter-automatically-tp3561522p3562868.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
