Oleo with a Motif GUI
|Original author(s)||Tom Lord,|
1.99.16 / 2001
|License||GPLv3 or later|
The project was started in 1992 by Tom Lord, and became part of the GNU initiative around 1994. At the time, the only open source alternative was the older text-based sc, both products having similar functionality to early versions of Lotus 123 or Microsoft Excel. Oleo's key bindings however were inspired from the Unix world, and similar to those used by the emacs editor, which frustrated novice users familiar with the DOS counterparts. Oleo and sc were the first Unix spreadsheet applications to acquire a graphical user interface. Because Oleo was officially part of the GNU project, it was dubbed "GNU's response to Excel" in a 1996 article in iX magazine. It claimed to be "better than the high priced spread", a reference to old oleomargarine advertisements promoting margarine over the more expensive butter. Oleo also worked well in a BSD environment; a FreeBSD port was available.
By 1995, sc had acquired an X Window front-end called xspread, which added graphics capabilities. In 1998, Oleo acquired a Motif-like GUI, relying on the royalty-free LessTif widget set. A GTK version was also under development. By 1999 Oleo was still judged as "not completely usable", due to the awkward graphical interface lacking in user friendliness like X-style cut, copy, and paste or tear-off menus. In the 1995 version, to type a number into a cell the user had to hit the "=" key first, similar to the early versions of Excel. This was later changed to typing a number directly, although typing a number in a cell that already contains one appends to it rather than overwrite it. Graphics are drawn using the device-independent library libplot, the centerpiece of the GNU plotutils. Oleo offers spreadsheet access to the GNU Scientific Library, a large collection of mathematical functions. It also offers some database connectivity, allowing access to MySQL database via queries, Xbase and DBF file access. It has support for macro programming, and for printing purposes it supports ASCII and PostScript output. Still, by 2000 it could not import Excel spreadsheets, while newer open source alternatives like Gnumeric offered this feature, and could also import Oleo spreadsheets.
Oleo was still recommended as a console spreadsheet application in a 2005 article in Linux.com, but the reviewer warns that "I had expected Oleo to be more intuitive, but I needed multiple sessions with the info file before I could use it proficiently. Even cell reference syntax was not what I had expected." By default, Oleo uses numbers for both rows and columns; a cell reference uses a syntax like
r12c26. A single Oleo process does not support the display of more than one file at a time, but GNU screen or multiple terminals can be used as a work-around. Oleo supports editing the same spreadsheet in concurrent application instances.
- Clifford Smith, "Spreadsheets under BSD (part 2)". Archived from the original on February 24, 2001. Retrieved 2010-01-17.CS1 maint: BOT: original-url status unknown (link), BSD Today, August 2000
- Dean Oisboid, Novice to Novice, Linux Journal, August 1st, 1995
- Vincent Granet, The Xxl Spreadsheet Project, April 1st, 1999, Linux Journal
- (in German) Torsten Beyer, GNU mal wieder, iX magazine, April 1996
- Oleo manual
- Larry Ayers xxl: A Free Spreadsheet for Linux, Linux Journal, January 1st, 1999
- Tuxtraining.com (March 23, 2008) Oleo: a commandline spreadsheet
- Michael M. Murphree, Top 10 Linux console applications, Linux.com, April 26, 2005
- Michael Hall (June 6, 2000) Suites for the Sweet: GNOME Office, LinuxPlanet