how to do Excel Like Filtering in Open Office


  1. Posts : 30
    Windows 7
       #1

    how to do Excel Like Filtering in Open Office


    Hello , i am new to open office .. i used excel 2007 earlier...
    i like to know is excel 2007 type tick filtering is available on open office.... if yes how to do it..

    if no ... please tell me what is the alternative way to do that kind of filtering in open office
      My Computer


  2. Posts : 10,455
    Microsoft Windows 7 Home Premium 64-bit Service Pack 1
       #2

    In LibreOffice which is pretty much like OpenOffice it is Data->Filter->Auto Filter...
      My Computer


  3. Azo
    Posts : 91
    Windows 7 Home Premium 64Bit
       #3

    Easy !


    In openOffice the easiest way to filter your data is to use the inbuilt autofilter feature. To do this, you’ll need to select the cells you want to filter.

    Let’s click the upper left corner of the sheet to select the entire worksheet. Next, select the data menu then choose filter, autofilter.



    You may see a message stating “The range does not contain column headers. Do you want the first line to be used as column header?”
    In this case, the first line of the selected range functions as a column header so you can click the yes button.
    Suppose you wanted to only view items that belong to the category of deciduous shrubs.





    Click the auto filter menu button in the category column. Then select deciduous shrubs from the drop down menu. Now only deciduous shrubs are displayed.
    You can filter further if you want to. Imagine you only want to show deciduous shrubs that have a medium growth rate. Just click the autofilter dropdown button in the growth column and select medium. Now you only see deciduous shrubs with a medium growth rate.
    To remove the filter, select the filter option from the data menu, then choose remove filter.


    Source:Free OpenOffice Calc tutorials - Filtering data
      My Computer


  4. Posts : 30
    Windows 7
    Thread Starter
       #4

    Thanks a lot guys.... i will go for libreoffice ... hope open office will also add this feature in their coming version........
      My Computer


  5. Azo
    Posts : 91
    Windows 7 Home Premium 64Bit
       #5

    mnr367 said:
    Thanks a lot guys.... i will go for libreoffice ... hope open office will also add this feature in their coming version........
    It's already there in OpenOffice and I just showed you how to do that !
      My Computer


  6. Posts : 30
    Windows 7
    Thread Starter
       #6

    Azo said:
    mnr367 said:
    Thanks a lot guys.... i will go for libreoffice ... hope open office will also add this feature in their coming version........
    It's already there in OpenOffice and I just showed you how to do that !
    ya thank you.... but in that i can't filter multiple items.... that's why
      My Computer


  7. Azo
    Posts : 91
    Windows 7 Home Premium 64Bit
       #7

    mnr367 said:
    Azo said:
    mnr367 said:
    Thanks a lot guys.... i will go for libreoffice ... hope open office will also add this feature in their coming version........
    It's already there in OpenOffice and I just showed you how to do that !
    ya thank you.... but in that i can't filter multiple items.... that's why
    Is this what you are searching for: OpenOffice Calc Tips : Data Filtering : Advanced Filter
      My Computer


  8. Posts : 30
    Windows 7
    Thread Starter
       #8

    Advance Filter is what i was looking for... but i find it a little complicated... so thats why i like the tick filtering in Excel and LIbre... that's very easy to use
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 15:25.
Find Us