Skip to content

Known Bugs

Jump to bottom
Tavis Ormandy edited this page Mar 15, 2023 · 5 revisions

This is a list of known bugs in Lotus 1-2-3 for UNIX.

@INFO("osreturncode")
  • The formula @INFO("osreturncode") returns incorrect values.

This is because on UNIX system() returns the exit code, but on Linux system() returns the wait status. This is easy to change, but it's unclear if this should be fixed - perhaps someone might want the wait status for some reason (please open an issue if you have an opinion).

As a workaround you can use @INFO("osreturncode") / 2^8.

Numeric Precision

Lotus 1-2-3 uses double precision IEEE 754, or in some cases, extended precision i387 floating point values. There can be cases where small errors can be introduced due to rounding or truncation.

A good example is the formula 32.91-675.19+642.28, which surprisingly returns -1.1E-13 (see issue #115).

If this is affecting your worksheet, you can use @ROUND(RESULT, 2) as a workaround.

As this affects other spreadsheets, further discussion is available for Excel and LibreOffice.

Clone this wiki locally