It seems there was a graphic attached to the original post which I can't see..
Here is a very brief tutorial on the Advanced Filter function in Calc http://www.openofficetips.com/blog/archives/2004/10/data_filtering_2.html Let us know if you need further help on this... Dave On 9/24/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > Hi, > > How to use Advanced filter function in Openoffice calc? > > Verify the below mentioned contents : In that, > > If I have to Filter the "Item" Which has "A" > > > > Note : Some "item" has "Aa", that also has to be filtered. > > How can i use this filter function in this case? > > Regards > N. Sivasakthi > Helpdesk Engineer > LMW-Unit I-FM Team > Extn : 5512480 / 2481 > > > *Paul <[EMAIL PROTECTED]>* > > 09/19/2005 12:57 PM Please respond to > [EMAIL PROTECTED] > > To > [email protected], [EMAIL PROTECTED] cc > > Subject > Re: [users] [moderated] > > > > > > > I'm assuming that you are meaning the function of filtering (auto, > standard and advanced filtering) within Calc. > > You can use regular expressions (which will allow you to do what you want) > by selecting the 'more' option after choosing advanced filtering. More > assistance on regular expressions that may assist can be found in the > inbuilt help files. > > Check them out. > > /paul > > On 9/19/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> <[EMAIL PROTECTED] > * <[EMAIL PROTECTED]>> wrote: > Hai, > > How to use "Contains, Starts with," etc., filter comments in > Spreadsheet/Calc? > > Regards > N. Sivasakthi > Helpdesk Engineer > LMW-Unit I-FM Team > Extn : 5512480 / 2481 > "This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they are > addressed. If you have received this email in error please notify the system > manager. Please note that any views or opinions presented in this mail are > solely those of the author and do not necessarily represent those of the > company. Finally, the recipient should check this email and any attachments > for the presence of viruses. The company accepts no liability for any damage > caused by any virus transmitted by this email." > > "This email and any files transmitted with it are confidential and intended > solely for the use of the individual or entity to whom they are addressed. If > you have received this email in error please notify the system manager. > Please note that any views or opinions presented in this mail are solely > those of the author and do not necessarily represent those of the company. > Finally, the recipient should check this email and any attachments for the > presence of viruses. The company accepts no liability for any damage caused > by any virus transmitted by this email." > > -- My OpenOffice Calc Website http://www.openofficetips.com
