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 Mon 20 May 2013, 18:31
All times are UTC - 4

 Forum index » Taking the Puppy out for a walk » Misc
Interesting FOSS spreadsheet(-like) applications
Moderators: Flash, JohnMurga
Post new topic   Reply to topic View previous topic :: View next topic
Page 1 of 1 [6 Posts]  
Author Message
disciple

Joined: 20 May 2006
Posts: 6179
Location: Auckland, New Zealand
PostPosted: Thu 09 Feb 2012, 02:44    Post subject:  Interesting FOSS spreadsheet(-like) applications  
Check out these if you're that way inclined. Note that some aren't being developed currently:

moodss (Modular Object Oriented Dynamic SpreadSheet)
- written in tcl
- designed for viewing and processing dynamic (changing) data e.g. the same information `top` displays. Scroll down and look at the screenshots.

The Objectsheet
I guess this is really more of a database than a spreadsheet, which is good, because I like to say that most of the time when people use spreadsheets they should be using a database Wink
- prevents I think all of the major problems with traditional spreadsheets
Quote:
- "Templates" within tables organize formulas and formats
- Data, formulas, formats, and code can all be viewed at once
- Automatically highlights manually entered cell values/formulas
- Formulas apply over an entire column or table without replication
- Self-contained tables can be moved around and formatted independent of each other; not bound by a single large grid
...

- web based (javascript).
- Check out the table at http://richk.net/os/doc/what1-table.html#summary summarising how it is designed to reduce errors and be easier to use.
- try the examples at the web site.

FlexiSheet
Cross-platform (GnuStep) port
Quote:
FlexiSheet is a multi-dimensional spreadsheet.
Instead of the normal row/column layout (and different pages maybe) multi-dimensional tables have two, three, or even more dimensions that can be arranged and rearranged as you see fit, even on the fly. The view on the data changes, but the actual data stays the same.
Talking about views: FlexiSheet can have different views on the same table. Not only derived views like charts and reports, but also spreadsheet views on the same data, but with different layouts.

- I've read that it can open Lotus Improv and Quantrix files. It is modelled after those programs.
- Ported from Mac OSX Cocoa
Interestingly, it didn't work in my Arch Install, because all GnuStep things crash (I think its a bug in my gcc - better try updating Sad ). But it is trivial to build and run in Windows!

SIAG: Scheme In A Grid
Can Your Spreadsheet Do This?
Old timers will be familiar with this one.
- Basically a spreadsheet gui for the Scheme programming language... it can also supports C, Python, Ruby an Tcl.
- Turn your spreadsheet into a file manager or a web server or even for managing user accounts... not that we do that last one on puppy. (I always wanted to do that. If I ever find the time it would be interesting to see if it could be used as an mp3 tag editor Wink )
- Be aware that ^ is a "bitwise xor" operator - use ** for exponentiation

mtcelledit - A lightweight spreadsheet program.
- From the author of mtPaint.
- C I guess
- Check out the screenshots links.
Quote:
graphing is somewhat fiddly to master. Probably the best way to learn how to use graphs is to study the example graphs in the test suite...
The fiddly part of graphing in mtCellEdit is that you are effectively writing a computer program to do the graphing, whereas in other programs its more of a point and click affair which is easier. The reason I chose this more complex approach is to give myself more power and flexibility. Not only can mtCellEdit create traditional line and bar graphs, but its also possible to create graphs that other programs cannot create such as timelines and structure diagrams.


Matrex
Quote:
Matrex is a vectorial spreadsheet. It gives you the same functionalities of a classic spreadsheet application in a new, different way.
Matrex is excellent when working with blocks of data coming from databases, feeds, files, external applications, simulations.

-Keeps different features separate from each other: input of data matrices, formula building, presentation of results in a table...
-Java.
_________________
DEATH TO SPREADSHEETS
- - -
Classic Puppy quotes
- - -
Beware the demented serfers!
Back to top
View user's profile Send private message 
musher0


Joined: 04 Jan 2009
Posts: 2201
Location: Gatineau (Qc), Canada
PostPosted: Wed 07 Mar 2012, 03:01    Post subject:  
Thanks.

Most timely, since my pango libs decided to go on strike against my gnumeric. (Or is it the reverse?)

BFN.
_________________
Wink "...l'industrie de l'informatique n'aura besoin que de très peu de temps pour ramener l'humanité aux dessins rupestres." (M. Goebbel, Order of the Command Line; [ma trad.])
Back to top
View user's profile Send private message Visit poster's website 
musher0


Joined: 04 Jan 2009
Posts: 2201
Location: Gatineau (Qc), Canada
PostPosted: Wed 07 Mar 2012, 03:15    Post subject:  
Flexisheet's concept reminds me of QubeCalc for DOS published +/- 20 years ago.
_________________
Wink "...l'industrie de l'informatique n'aura besoin que de très peu de temps pour ramener l'humanité aux dessins rupestres." (M. Goebbel, Order of the Command Line; [ma trad.])
Back to top
View user's profile Send private message Visit poster's website 
Jasper


Joined: 25 Apr 2010
Posts: 869
Location: England
PostPosted: Wed 03 Oct 2012, 10:14    Post subject:  
Hi,

You may find that an application such as "Homebank personal accounting" is already included (perhaps under "Menu" at the bottom left hand corner of your screen, then click "Business", then "Homebank").

If you want to make your own spreadsheet the picture below gives a few general hints. However, if the financial detail is very important - especially for a few months - make a pencil and paper copy.

My regards

Spreadsheets vary as to precise looks and formulas, but they are in fact similar in their basic methods.

Cosmetic adjustments e.g. right justifying the word "Balance" are easily done when you have got the figures computed accurately. Just check your spreadsheet calculations make sense.
just an example.jpg
 Description   
 Filesize   78.1 KB
 Viewed   270 Time(s)

just an example.jpg
Back to top
View user's profile Send private message 
disciple

Joined: 20 May 2006
Posts: 6179
Location: Auckland, New Zealand
PostPosted: Wed 03 Oct 2012, 16:59    Post subject:  
For anyone interested in the Improv/Quantrix/Flexisheet "multi dimensional spreadsheet" concept:
The old Flexisheet pages I linked to have an OK outline of what they’re all about, although I think one thing omitted is the aspect of showing the same data in more than one “spreadsheet” simultaneously.
But the user interface is truly genius - if it isn’t clear from that site, check out the videos on the quantrix website showing how they work.
http://www.quantrix.com/Quantrix_Video_Demos.htm?url_text=Product_Tours

My favourite quote is from a thread a few years ago which started off with Apple users lamenting the fact that when Apple released a spreadsheet it was the traditional style, not a Lotus Improv / Quantrix clone:
Quote:
I really like the Multidimensional spreadsheet idea. However, how is this different from something like MS Access? (Except that it might actually be usable).

I think this person is almost onto something really good: what would be really cool is if someone implemented that user interface in a standard toolkit (GTK or QT), and with the ability to act as a gui to a normal database.
_________________
DEATH TO SPREADSHEETS
- - -
Classic Puppy quotes
- - -
Beware the demented serfers!

Last edited by disciple on Thu 04 Oct 2012, 18:16; edited 1 time in total
Back to top
View user's profile Send private message 
01micko


Joined: 11 Oct 2008
Posts: 7018
Location: qld
PostPosted: Wed 03 Oct 2012, 21:16    Post subject:  
Wow.. MT's mtcelledit has come along, if it's still pretty light might be a great alternative to gnumeric in light distros for older/slower kit (raspberry pi springs to mind).
_________________
keep the faith Cool ..
Back to top
View user's profile Send private message Visit poster's website 
Display posts from previous:   Sort by:   
Page 1 of 1 [6 Posts]  
Post new topic   Reply to topic View previous topic :: View next topic
 Forum index » Taking the Puppy out for a walk » Misc
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.0581s ][ Queries: 13 (0.0055s) ][ GZIP on ]