The time now is Wed 25 Apr 2018, 08:46
All times are UTC - 4 |
Author |
Message |
disciple
Joined: 20 May 2006 Posts: 6781 Location: Auckland, New Zealand
|
Posted: 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
- 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 ). 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 )
- 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.
_________________ If you have or know of a good gtkdialog application, please post a link here
Classic Puppy quotes
ROOT FOREVER
|
Back to top
|
|
 |
musher0

Joined: 04 Jan 2009 Posts: 12095 Location: Gatineau (Qc), Canada
|
Posted: 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.
_________________ musher0
~~~~~~~~~~
"Logical entities must not be multiplied beyond necessity." | |
« Il ne faut pas multiplier les entités logiques sans nécessité. » (Ockham)
|
Back to top
|
|
 |
musher0

Joined: 04 Jan 2009 Posts: 12095 Location: Gatineau (Qc), Canada
|
Posted: Wed 07 Mar 2012, 03:15 Post subject:
|
|
Flexisheet's concept reminds me of QubeCalc for DOS published +/- 20 years ago.
_________________ musher0
~~~~~~~~~~
"Logical entities must not be multiplied beyond necessity." | |
« Il ne faut pas multiplier les entités logiques sans nécessité. » (Ockham)
|
Back to top
|
|
 |
Jasper
Joined: 25 Apr 2010 Posts: 1350 Location: England
|
Posted: 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.
Description |
|
Filesize |
78.1 KB |
Viewed |
1103 Time(s) |

|
|
Back to top
|
|
 |
disciple
Joined: 20 May 2006 Posts: 6781 Location: Auckland, New Zealand
|
Posted: 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.
_________________ If you have or know of a good gtkdialog application, please post a link here
Classic Puppy quotes
ROOT FOREVER
Last edited by disciple on Thu 04 Oct 2012, 18:16; edited 1 time in total
|
Back to top
|
|
 |
01micko

Joined: 11 Oct 2008 Posts: 8670 Location: qld
|
Posted: 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).
_________________ Puppy Linux Blog - contact me for access
|
Back to top
|
|
 |
disciple
Joined: 20 May 2006 Posts: 6781 Location: Auckland, New Zealand
|
Posted: Sat 14 Sep 2013, 18:54 Post subject:
|
|
http://strlen.com/treesheets/
Quote: | The ultimate replacement for spreadsheets, mind mappers, outliners, PIMs, text editors and small databases. |
The maths capability is pretty limited (they call it "experimental"), but this concept might even stack up against the Improv/Quantrix/Flexisheet one.
_________________ If you have or know of a good gtkdialog application, please post a link here
Classic Puppy quotes
ROOT FOREVER
Last edited by disciple on Sat 14 Sep 2013, 18:58; edited 1 time in total
|
Back to top
|
|
 |
disciple
Joined: 20 May 2006 Posts: 6781 Location: Auckland, New Zealand
|
Posted: Sat 14 Sep 2013, 18:57 Post subject:
|
|
http://manns.github.io/pyspread/
Quote: | Pyspread is a non-traditional spreadsheet application that is based on and written in the programming language Python.
The goal of pyspread is to be the most pythonic spreadsheet.
Pyspread expects Python expressions in its grid cells, which makes a spreadsheet specific language obsolete. Each cell returns a Python object that can be accessed from other cells. These objects can represent anything including lists or matrices. |
_________________ If you have or know of a good gtkdialog application, please post a link here
Classic Puppy quotes
ROOT FOREVER
|
Back to top
|
|
 |
plankenstein

Joined: 15 Nov 2008 Posts: 121 Location: Arkansas, USA
|
Posted: Sun 15 Sep 2013, 01:52 Post subject:
|
|
I'm going to have to check some of these out. Objectsheet sounds very interesting.
_________________ I carefully plan ALL my random acts! 
|
Back to top
|
|
 |
|
|
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
|