Lotus 1-2-3 for Linux
This is a native port of Lotus 1-2-3 Release 3 to Linux. This is possible because Lotus 1-2-3 for UNIX SystemV used a trick called partial linking to workaround a technical limitation in early UNIX systems. Surprisingly, that can be used to modify it to support new platforms.
There's an article documenting how this is possible here.
First, you need a version of binutils that is compiled with
coff-i386 target support. You can check like this:
$ objdump --info | grep coff-i386
Note: Most distributions do not enable this for some reason.
Run the included
binutils.sh to download and compile a version of binutils known to work for this.
Secondly, you need a copy of Lotus 1-2-3 for UNIX, you can download it here. Just place the raw disk images in the build directory and run
Finally, just run
The following packages are required
Unfortunately, most distributions do not enable
coff-i386 support in binutils.
It's very easy to enable it yourself, download binutils and configure it with
Note: binutils-2.38 is known to work, some earlier versions have been found to not work.
There's no need to install it, just build it with
When that's complete, copy
objdump from the
binutils directory, and
ld-new from the
ld directory to
Important: Remember to rename
The Makefile should automatically use the new binaries, and continue to build.
- There is a man page in
./root/lotus/man/man1/123.1, and a full manual available online here.
Lotus 1-2-3 has context sensitive online help, you can press
F1 at most times to see some hints.
Note: You use use the
/key to open the 123 menu!
If you've used any spreadsheet before, you should be able to get started quickly. Functions use
@ instead of
=, but the common functions like
@INDEX, and even
@HLOOKUP all work as you would expect.
- Q. How do I quit 123?
If the status indicator in the top right says
If it doesn't say
READY (it might say
MENU or something else), try hitting
Esc until it goes back to
The keyboard map seems to be incompleteThis seems to be working in xterm, please test other terminals!
- Graphs don't work yet (we're working on it!, see #5).
- Printing doesn't work yet.
- File an issue if you notice something, there are probably lots of minor issues that can be fixed!
By default, 123 allows Autoexec macros in worksheets. Lotus macros are very powerful, and can run shell commands, read and write arbitrary files, load plugins and so on.
However, you can disable Autoexec macros via
/Worksheet Global Default Autoexec.
I am thinking of changing this default before we reach a first release, see #27.
If you disable Autoexec then in theory it's safe to open untrusted worksheets -- but this software hasn't been maintained for over 30 years, and may contain security bugs!
We can fix bugs with
coffsyrup, by redirecting unsafe functions to new safe versions, so we will make a best effort to fix vulnerabilities if you report them!