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 Sat 20 Dec 2014, 08:29
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 [2 Posts]  
Author Message
JohnJS

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

PostPosted: Sun 25 Nov 2012, 12:31    Post subject:  Gnumeric autofilter
Subject description: 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: 2481
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 poster's website 
Display posts from previous:   Sort by:   
Page 1 of 1 [2 Posts]  
Post new topic   Reply to topic View previous topic :: View next topic
 Forum index » House Training » HOWTO ( Solutions )
Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.0397s ][ Queries: 12 (0.0045s) ][ GZIP on ]