Fedora Linux Support Community & Resources Center
  #1  
Old 22nd January 2014, 12:15 PM
djs407 Offline
Registered User
 
Join Date: Jan 2014
Location: Canada
Posts: 45
linuxchrome
Filtering in Gnumeric: how to?

If anyone here uses Gnumeric, can you tell how to filter data?
Gnumeric's help doesn't make sense, and there is no forum for Gnumeric to ask, web search was useless too.

I'm trying to filter rows, containing the same word (there is more than one word in the cell), in interrupted columns range. Or is the filtering possible only by the whole cell content?

There is no information what AutoFilter is or how to use it, and for Advanced filter, it seems that List Range is name of the sheet in quote marks ' ' with "!", the selection of all sheet's cells without headers, say A2-AD1100.

But what can I use as Criteria Range? For what I'm trying to filter, it cannot be a range of sells, only one cell's content.

And why copy title bars in free cells in the same sheet, as help says, why type criteria there, if it will be not used anyway?

Can you clarify, please?
Reply With Quote
  #2  
Old 22nd January 2014, 01:39 PM
flyingfsck Offline
Registered User
 
Join Date: Aug 2010
Location: Al Ain, UAE
Posts: 2,000
macoschrome
Re: Filtering in Gnumeric: how to?

No idea. However, I would try reading the help for MS Excel. Chances are that Gnumeric will do the same!
Reply With Quote
  #3  
Old 22nd January 2014, 01:50 PM
djs407 Offline
Registered User
 
Join Date: Jan 2014
Location: Canada
Posts: 45
linuxubuntufirefox
Re: Filtering in Gnumeric: how to?

Don't have Excel, sorry.
Help of the Libre Office Calc worked well until now, but not for filtering.
Reply With Quote
  #4  
Old 22nd January 2014, 01:52 PM
flyingfsck Offline
Registered User
 
Join Date: Aug 2010
Location: Al Ain, UAE
Posts: 2,000
macoschrome
Re: Filtering in Gnumeric: how to?

Yes, but google for data help with Excel and you may find something.
Reply With Quote
  #5  
Old 22nd January 2014, 01:56 PM
djs407 Offline
Registered User
 
Join Date: Jan 2014
Location: Canada
Posts: 45
linuxubuntufirefox
Re: Filtering in Gnumeric: how to?

Thanks, will try.
Reply With Quote
  #6  
Old 22nd January 2014, 02:35 PM
djs407 Offline
Registered User
 
Join Date: Jan 2014
Location: Canada
Posts: 45
linuxubuntufirefox
Re: Filtering in Gnumeric: how to?

It works, exactly as described for Excel:

1. Make sure that each column contain the same type of data (no date and text formats in the same colum, but could be general format for both).
2. Click on header of the column that contains cell with content to be filtered.
3. Data > Filter > AutoFilter
4. Each column header will have drop box with arrow. Click on arrow column that contains terms to be filtered, choose them.
5. Now only rows containing search term will be visible.

Unfortunately, the next action, Copy Only Visible (to copy filter results to another sheeth) is not working in Gnumeric. It was reported as a bug in 2004 and recent entry hints that this is not going to be implemented.

So, the choice is:
1 - either copy/paste ea row manually (unless you have hundreds of them)
2 - or switch to Libre office or Calligra suite spreadsheets. Real pity.

Thank you for the sound advice, it worked very well for me.
Problem solved.
Reply With Quote
Reply

Tags
filtering, gnumeric, how to

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Gnumeric problem SeriyVolk Using Fedora 4 18th May 2007 03:12 AM
Gnumeric jim Using Fedora 1 5th April 2005 12:21 AM


Current GMT-time: 21:38 (Wednesday, 24-05-2017)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive
logo

All trademarks, and forum posts in this site are property of their respective owner(s).
FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding Members

Powered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc.

FedoraForum is Powered by RedHat