Joined: 05 Jan 2009 Posts: 19 Location: Sacramento CA
Posted: Sun 25 Nov 2012, 12:31 Post subject:
Gnumeric autofilter Subject description: Working with the results of autofilter
I found a way to work with the results of autofilter.
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).
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"".
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