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 is a Unix shell and command language written by Brian Fox for the GNU Project as a free software replacement for the Bourne shell. The shell's name is an acronym for Bourne-Again SHell, a pun on the name of the Bourne shell that it replaces and the notion of being "born again". First released in 1989, it has been used as the default login shell for most Linux distributions and it was one of the first programs Linus Torvalds ported to Linux, alongside GCC. It is available on nearly all modern operating systems.

<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, or libreware 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">GnuCash</span> Personal and small-business financial-accounting software

GnuCash is an accounting program that implements a double-entry bookkeeping system. It was initially aimed at developing capabilities similar to Intuit, Inc.'s Quicken application, but also has features for small business accounting. Recent development has been focused on adapting to modern desktop support-library requirements.

<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.

An integrated development environment (IDE) is a software application that provides comprehensive facilities for software development. An IDE normally consists of at least a source-code editor, build automation tools, and a debugger. Some IDEs, such as IntelliJ IDEA, Eclipse and Lazarus contain the necessary compiler, interpreter or both; others, such as SharpDevelop and NetBeans, do not.

Darwin is the core Unix operating system of macOS, iOS, watchOS, tvOS, iPadOS, 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 build automation tool that builds executable programs and libraries from source code by reading files called makefiles which specify how to derive the target program. Though integrated development environments and language-specific compiler features can also be used to manage a build process, Make remains widely used, especially in Unix and Unix-like operating systems.

The GNU C Library, commonly known as glibc, is the GNU Project's 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

Within the free software and the open-source software communities there is controversy over whether to refer to computer operating systems that use a combination of GNU software and the Linux kernel 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.

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 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. Many Linux distributions use the word "Linux" in their name, but the Free Software Foundation uses and recommends the name "GNU/Linux" to emphasize the use and importance of GNU software in many distributions, causing some controversy.

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 in a manner similar to a Unix system

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
  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.