Re: [discuss] filter data : contains

2005-11-12 Thread CPHennessy
On Sun October 23 2005 13:10, + claudiorizzoli wrote: [ MODERATED ] in the filter data option in calc how can i filter data that contains a certain word or part of word? I.e. in a spreadsheet i want to filter all lines that contain the word xyz only it's an

[discuss] filter data : contains

2005-10-26 Thread sergio boso
Hi Claudio, to do this, you have ALSO go to: instruments - options go to staroffice calc - calculations UNCHECK search criteria refers to whole cell In SO 8/ OO 2.0 this is checked by default. ciao !!! sergio -- | Sergio Boso ([EMAIL PROTECTED])

[discuss] filter data : contains

2005-10-23 Thread claudiorizzoli
in the filter data option in calc how can i filter data that contains a certain word or part of word? I.e. in a spreadsheet i want to filter all lines that contain the word xyz only it's an extremely usfull filter option that i'm not able to activate in Open Officeis it there

Re: [discuss] filter data : contains

2005-10-23 Thread Jonathon Coombes
On Sun, 2005-10-23 at 14:10 +0200, [EMAIL PROTECTED] wrote: in the filter data option in calc how can i filter data that contains a certain word or part of word? I.e. in a spreadsheet i want to filter all lines that contain the word xyz only it's an extremely usfull filter option