Puppy Linux Discussion Forum

[JohnJS]

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.

[darkcity]

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