GNU Oleo

Last updated
Original author(s) Tom Lord, [1]
Initial release1992;32 years ago (1992) [1]
Final release
1.6.16 [2]   OOjs UI icon edit-ltr-progressive.svg / 10 March 1999
Preview release
1.99.16 [3]   OOjs UI icon edit-ltr-progressive.svg / 10 March 2001
Written in C
Type Spreadsheet
License GPL-3.0-or-later
Website www.gnu.org/software/oleo/oleo.html

GNU Oleo is a discontinued [4] lightweight free software spreadsheet [5] originally designed as a text-based spreadsheet using the curses library. The last development version of Oleo, 1.99.16, was released in 2001.

Contents

History

The project was started in 1992 by Tom Lord, [1] and became part of the GNU initiative around 1994. [6] At the time, the only open source alternative was the older text-based sc, both products having similar functionality to early versions of Lotus 1-2-3 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. [7] Oleo and sc were the first Unix spreadsheet applications to acquire a graphical user interface. [8] Because Oleo was officially part of the GNU project, it was dubbed "GNU's response to Excel" in a 1996 article in iX magazine. [9] It claimed to be "better than the high priced spread", [10] 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. [6]

By 1995, sc had acquired an X Window front-end called xspread, which added graphics capabilities. [7] In 1998, [1] 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", [11] due to the awkward graphical interface lacking in user friendliness like X-style cut, copy, and paste or tear-off menus. [8] 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. [7] 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. [12] 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. [6] It has support for macro programming, and for printing purposes it supports ASCII and PostScript output. [13] Still, by 2000 it could not import Excel spreadsheets, while newer open source alternatives like Gnumeric offered this feature, [6] and could also import Oleo spreadsheets. [14]

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." [13] By default, Oleo uses numbers for both rows and columns; a cell reference uses a syntax like r12c26. [12] 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. [13]

Related Research Articles

<span class="mw-page-title-main">Bash (Unix shell)</span> GNU replacement for the Bourne shell

Bash, short for Bourne-Again SHell, is a shell program and command language supported by the Free Software Foundation and first developed for the GNU Project by Brian Fox. Designed as a 100% free software alternative for the Bourne shell, it was initially released in 1989. Its moniker is a play on words, referencing both its predecessor, the Bourne shell, and the concept of rebirth.

<span class="mw-page-title-main">Common Desktop Environment</span> Desktop environment for Unix, Unix-like, and OpenVMS operating systems

The Common Desktop Environment (CDE) is a desktop environment for Unix and OpenVMS, based on the Motif widget toolkit. It was part of the UNIX 98 Workstation Product Standard, and was for a long time the Unix desktop associated with commercial Unix workstations. It helped to influence early implementations of successor projects such as KDE and GNOME, which largely replaced CDE following the turn of the century.

<span class="mw-page-title-main">Free software</span> Software licensed to be freely used, modified and distributed

Free software, libre software, libreware or rarely known as freedom-respecting software is computer software distributed under terms that allow users to run the software for any purpose as well as to study, change, and distribute it and any adapted versions. Free software is a matter of liberty, not price; all users are legally free to do what they want with their copies of a free software regardless of how much is paid to obtain the program. Computer programs are deemed "free" if they give end-users ultimate control over the software and, subsequently, over their devices.

<span class="mw-page-title-main">GNU</span> Free software collection

GNU is an extensive collection of free software, which can be used as an operating system or can be used in parts with other operating systems. The use of the completed GNU tools led to the family of operating systems popularly known as Linux. Most of GNU is licensed under the GNU Project's own General Public License (GPL).

<span class="mw-page-title-main">Irssi</span> Text-mode IRC client

Irssi is an Internet Relay Chat (IRC) client program for Linux, FreeBSD, macOS and Microsoft Windows. It was originally written by Timo Sirainen, and released under the terms of the GNU GPL-2.0-or-later in January 1999.

Darwin is the core Unix-like operating system of macOS, iOS, watchOS, tvOS, iPadOS, audioOS, visionOS, and bridgeOS. It previously existed as an independent open-source operating system, first released by Apple Inc. in 2000. It is composed of code derived from NeXTSTEP, FreeBSD, other BSD operating systems, Mach, and other free software projects' code, as well as code developed by Apple.

man page Unix software documentation

A man page is a form of software documentation usually found on a Unix or Unix-like operating system. Topics covered include computer programs, formal standards and conventions, and even abstract concepts. A user may invoke a man page by issuing the man command.

In software development, Make is a command-line interface software tool that performs actions ordered by configured dependencies as defined in a configuration file called a makefile. It is commonly used for build automation to build executable code from source code. But, not limited to building, Make can perform any operation available via the operating system shell.

The GNU C Library, commonly known as glibc, is the GNU Project implementation of the C standard library. It is a wrapper around the system calls of the Linux kernel for application use. Despite its name, it now also directly supports C++. It was started in the 1980s by the Free Software Foundation (FSF) for the GNU operating system.

<span class="mw-page-title-main">GNU/Linux naming controversy</span> Issues of what to call a system with the GNU toolchain and the Linux kernel

The GNU/Linux naming controversy is a controversy regarding whether computer operating systems that use GNU software and the Linux kernel should be referred to as "GNU/Linux" or "Linux" systems.

dd is a command-line utility for Unix, Plan 9, Inferno, and Unix-like operating systems and beyond, the primary purpose of which is to convert and copy files. On Unix, device drivers for hardware and special device files appear in the file system just like normal files; dd can also read and/or write from/to these files, provided that function is implemented in their respective driver. As a result, dd can be used for tasks such as backing up the boot sector of a hard drive, and obtaining a fixed amount of random data. The dd program can also perform conversions on the data as it is copied, including byte order swapping and conversion to and from the ASCII and EBCDIC text encodings.

bc, for basic calculator, is "an arbitrary-precision calculator language" with syntax similar to the C programming language. bc is typically used as either a mathematical scripting language or as an interactive mathematical shell.

gEDA

The term gEDA refers to two things:

  1. A set of software applications used for electronic design released under the GPL. As such, gEDA is an ECAD or EDA application suite. gEDA is mostly oriented towards printed circuit board design. The gEDA applications are often referred to collectively as "the gEDA Suite".
  2. The collaboration of free software/open-source developers who work to develop and maintain the gEDA toolkit. The developers communicate via gEDA mailing lists, and have participated in the annual "Google Summer of Code" event as a single project. This collaboration is often referred to as "the gEDA Project".
<span class="mw-page-title-main">Linux</span> Family of Unix-like operating systems

Linux is a generic name for a family of open-source Unix-like operating systems based on the Linux kernel, an operating system kernel first released on September 17, 1991, by Linus Torvalds. Linux is typically packaged as a Linux distribution (distro), which includes the kernel and supporting system software and libraries, many of which are provided by the GNU Project.

Duplicity, graphical interface known as Déjà Dup, is a software suite that provides encrypted, digitally signed, versioned, local or remote backup of files requiring little of the remote server. Released under the terms of the GNU General Public License (GPL), Duplicity is free software.

Linux began in 1991 as a personal project by Finnish student Linus Torvalds to create a new free operating system kernel. The resulting Linux kernel has been marked by constant growth throughout its history. Since the initial release of its source code in 1991, it has grown from a small number of C files under a license prohibiting commercial distribution to the 4.15 version in 2018 with more than 23.3 million lines of source code, not counting comments, under the GNU General Public License v2 with a syscall exception meaning anything that uses the kernel via system calls are not subject to the GNU GPL.

<span class="mw-page-title-main">Unix-like</span> Operating system that behaves similarly to Unix, e.g. Linux

A Unix-like operating system is one that behaves in a manner similar to a Unix system, although not necessarily conforming to or being certified to any version of the Single UNIX Specification. A Unix-like application is one that behaves like the corresponding Unix command or shell. Although there are general philosophies for Unix design, there is no technical standard defining the term, and opinions can differ about the degree to which a particular operating system or application is Unix-like.

<span class="mw-page-title-main">Unix</span> Family of computer operating systems

Unix is a family of multitasking, multi-user computer operating systems that derive from the original AT&T Unix, whose development started in 1969 at the Bell Labs research center by Ken Thompson, Dennis Ritchie, and others.

Comparison of user features of operating systems refers to a comparison of the general user features of major operating systems in a narrative format. It does not encompass a full exhaustive comparison or description of all technical details of all operating systems. It is a comparison of basic roles and the most prominent features. It also includes the most important features of the operating system's origins, historical development, and role.

References

  1. 1 2 3 4 https://www.gnu.org/software/oleo/ChangeLog [ bare URL ]
  2. "ChangeLog". 22 November 2000. Archived from the original on 8 January 2001.
  3. "Oleo - GNU Project - Free Software Foundation". 10 March 2001. Archived from the original on 1 April 2001.
  4. "oleo - Summary [Savannah]". savannah.gnu.org. 2001-01-23. Retrieved 2024-02-18. Development Status: ? - Orphaned/Unmaintained
  5. "Oleo - GNU Project - Free Software Foundation)". GNU.org. 2016-05-11. Retrieved 2023-10-21.
  6. 1 2 3 4 Clifford Smith, "Spreadsheets under BSD (part 2)". Archived from the original on February 24, 2001. Retrieved 2010-01-17.{{cite web}}: CS1 maint: bot: original URL status unknown (link), BSD Today, August 2000
  7. 1 2 3 "Novice to Novice | Linux Journal". www.linuxjournal.com. Retrieved 2023-10-21.
  8. 1 2 "The Xxl Spreadsheet Project | Linux Journal". www.linuxjournal.com. Retrieved 2023-10-21.
  9. online, heise (1996-03-17). "GNU mal wieder". iX Magazin (in German). Retrieved 2023-10-21.
  10. "Oleo 1.99.13". www.gnu.org. Retrieved 2023-10-21.
  11. "xxl: A Free Spreadsheet for Linux | Linux Journal". www.linuxjournal.com. Retrieved 2023-10-21.
  12. 1 2 "Oleo: a commandline spreadsheet". Tux Training. Archived from the original on 2008-10-06.
  13. 1 2 3 "Articles about Code Red are invading the Internet". Linux.com. 2001-08-06. Retrieved 2023-10-21.
  14. Hall, Michael. "Suites for the Sweet: GNOME Office". LinuxPlanet . Archived from the original on 2000-08-23.