Puppy Linux Discussion Forum Forum Index Puppy Linux Discussion Forum
Puppy HOME page : puppylinux.com
"THE" alternative forum : puppylinux.info
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

The time now is Sun 26 Oct 2014, 00:07
All times are UTC - 4
 Forum index » House Training » HOWTO ( Solutions )
Gnumeric autofilter
Moderators: Flash, Ian, JohnMurga
Post_new_topic   Reply_to_topic View_previous_topic :: View_next_topic
Page 1 of 1 Posts_count  
Author Message
JohnJS

Joined: 05 Jan 2009
Posts: 19
Location: Sacramento CA

PostPosted: Sun 25 Nov 2012, 12:31    Post_subject:  Gnumeric autofilter
Sub_title: Working with the results of autofilter
 

Using puppy528.
I found a way to work with the results of autofilter.
Steps:
Insert new sheet.
Copy appropriate column after autofilter search.
Paste into Geany.
From Geany copy and paste into the new sheet.
Accept default (click finish) in Text Import Configuration window.
Now calculations can be performed.
Several searches can now be added to the new sheet.
Hope this helps someone.
PS: I did an extensive search and could not find any simpler method.
Gnumeric.org has no information on autofilter.
Alternatively you could use sqlite but it involves more steps and not practical
with a non-completed file (ie will have new entries).
Sqlite steps:
Save file as .csv then create table in sqlite.
Import .csv file, must use (.separator ",") before importing.
Then "Select * from File where payee like "xxx"" or "select sum(debit) from
File where Payee like "xxx"".
Regards, John.
Back to top
View user's profile Send_private_message 
darkcity


Joined: 23 May 2010
Posts: 2462
Location: near here

PostPosted: Sun 25 Nov 2012, 17:52    Post_subject:  

thanks for the tip, I normally install libreoffice if I need extra features
; -)

_________________
helping Wiki for help | IF SendSpace link = "dead" THEN PM me ("up file to http://meownplanet.net/")
Back to top
View user's profile Send_private_message Visit_website 
Display_posts:   Sort by:   
Page 1 of 1 Posts_count  
Post_new_topic   Reply_to_topic View_previous_topic :: View_next_topic
 Forum index » House Training » HOWTO ( Solutions )
Jump to:  

Rules_post_cannot
Rules_reply_cannot
Rules_edit_cannot
Rules_delete_cannot
Rules_vote_cannot
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.0625s ][ Queries: 11 (0.0287s) ][ GZIP on ]