Sunday, 12 October 2014

What I still miss from Lotus 1-2-3

I use Microsoft Excel practically every day. It's running right now on this machine as I write this posting.

But there are a couple of things that I miss from Lotus 1-2-3 right to this day.

Slash Commands

The first is the ability to use slash commands. With 1-2-3 all commands were initiated by pressing the slash key. "/FO", for example, was used for File Open.

The great things about this was that 1-2-3 was designed to be used with a keyboard rather than a mouse. Originally this was because 1-2-3 was a DOS application rather than a Windows application. But the combination of the slash commands and the matrix of cells which could be navigated using cursor keys meant that using the keyboard was fast. Much faster than using a mouse.

The benefit of Excel (based on Windows and the mouse) is that it is easier to learn. But it is slow.

1-2-3 was used by power users. Power users were easily able to learn the slash commands. But as everyone migrated from 1-2-3 to Excel that speed was lost for power users.

Deleting Rows

The second thing I still miss was that in 1-2-3 you could define a source (input) table, a target (output) table, and a criteria table and you could, for example, copy all rows from the source table to the target table which met the criteria. And the target table did not need to have all of the columns from the source table. All very useful and powerful. Now Excel does have some of those capabilities (filter and advanced filter). But what was even more powerful and is missing from Excel was that you could delete the rows from the source table which met the criteria in the criteria table. "/ Data Query Delete". Genius!