Un, deux, trois

There’s quite a few of us old buggers on this forum… Sure I’m not the only one who used Lotus 123 back in the day…

Anyway - I subscribe to Bryan Lunduke’s “stuff” and noted this the other day :

https://lock.cmpxchg8b.com/linux123.html#lotus-1-2-3-for-unix

Wow!

I actually learned the whole 123 Macro language - it was incredible, you could write a whole application in 123’s macro language! *

I have floppies buried away somewhere with “archival” backup copies of 123 (the real version, 2.x I think - not the DOS “3D” version of 123, or the Windows version, that futilely tried to compete with MS Excel…

Sure there was nothing special about 123, and it was basically Mitch Kapor cloning what Visicalc could do, for 8 bit Intel systems (8086 / 8088)…

* I did write a whole “system” in 123 Macro language for an “applications” unit when I was at Uni, and got a “A” - i.e. something like 95% or more (but wasn’t reflected in my overall result for the semester, as I got “marked down”)…

Sometimes when I’m hitting “:” or “/” in vi, reminds me of using Lotus 123 :smiley:

2 Likes

Yes I used Lotus.
There is a reasonable Linux spreadsheet called gnumeric
Have you tried it? It reads excel files ok

I’ve no use for Gnumeric…

I have access to corporate Office 365 and MS Excel, on Macs or via the web interface to O365 (Excel online is very usable!).

I can use LibreOffice Calc anytime…

I can use Google Sheets anytime…

Having a console / terminal spreadsheet sounds like the duck’s nuts to me! Now that is INTERESTING!

I also wrote a shonky rough and ready shell script to display CSV files like they were spreadsheets, “cli-excel.bash”… the main ingredient of that shell script is the “column” command…

1 Like

Wow 123 takes me back in time.
I was very lucky in my early days of teaching computing and business to work for 2 different ITeCs and pushed them into becoming Lotus authorised training centres.
I started on version 1and installed it on a network of DOS machines, then went to version 2 and on to 3. Great memories of seeing 3d spreadsheet at the uk launch.
Sadly the windows version and apple mac versions just could not compete with excel.
On the same front taught Lotus symphony,
With windows came freelance, aproach, and ami pro, wordpro …
Even became a authorised trainer and system engineer.
The purchase by IBM and Lotus notes perhaps not a good move for the company.

Now prefer libre office but bet i could still do the macro language if pressed.

Dont think i need to install on my linux box for now, but never know

They say nostalgia isn’t like it used to be, but that remark is in fact quite topical. You can buy a book on the dreaded VBA with the weekly shopping, but you’re unlikely to find one on whatever alternative LibreOffice is offering. Last time I looked it up, I got the impression the LibreOffice people don’t approve of amateurs writing code, on the grounds that they’re amateurs and that companies have crashed like that. So you can’t even use LO for making flashcards for language teaching and so on, whereas there’s a plethora of choice to download from the VBA/Excel ecosystem.

I use LO as a matter of principle, but really shouldn’t. For example, I can’t lock the layout of a Calc spreadsheet so the the user can enter data without worrying about wrecking the whole thing; that’s critical for a small family enterprise sending out a legally-binding invoice. I did a bug report a few years ago. They said it’s a genuine bug, but unsquashable because, apparently, it had escaped the attention (wonder why?) of the committee that designed the odf file format.

I used SuperCalc 3 when I was in college. That was out before Lotus 123.

Lotus was my epiphany app. I used spreadsheets forever after that. It was the original “what if” app. To me, it was what made computers useful and marked the beginning of the rise of the machine. It was the first truly powerful application.

1 Like

You’re probably right… I remember when it was a paid NIX app called “Star Office” - I vaguely remember wanting a copy, but not desperately…

Sun Microsystems bought it - and made it free as “Open Office”… Sun hardware and system software used to be my bread and butter… One day a Sun “engineer” emailed me an ODF document, I couldn’t open it - he suggested installing Open Office for Windows - which I promptly did, and it KILLED my Java install and stopped my ability to run the Enterprise Backup Server management app (EMC Legato Networker)… What a piece of crap! I ended up having to VNC to a Solaris machine to run EMC Legato Networker Java GUI app - so much for Java being a write once, run anywhere bullshit answer…

I don’t know who pays the bills at Open/Libre Office these days, I doubt anyone from Oracle would want that responsibility, doesn’t fit with Larry Ellison’s modus operandi… I reckon he only bought Sun so he could get all the Java patents and sue the crap out of Google…

More “character / text” based spreadsheeting solutions here :

https://lock.cmpxchg8b.com/spreadsheet.html

1 Like

Things that made computers useful (for me)

  • Fortran compiler
  • Improvements in disc storage and memory
  • Access. A keyboard and screen is a long way ahead of punched cards or paper tape
  • Splus and R ( I use R like a spreadsheet)
  • Practice

I am sure others have a different experience. Lets hear about it?
What is your epiphany moment?

Dear Daniel,

I have used Lotus123 and it was one of the premium software at that point of time.

Thanks, I tried Gnumeric today, loading a LIbre Office Calc file with four columns of data and a line chart with three plotted series versus date. The chart didn’t come in correctly, but with some work on it I was able to get it put back in order, so I will give this a try for a while. It does seem to be a little easier to figure out how to do things. Is there a word processor you prefer over L.O.Writer?

I dont use a word processor I am afraid.
I use a text formater called Latex. It is mostly used for typesetting mathematics. Old habit, but it dies hard.

Yes, gnumeric seems OK for my elementary usage. It reads excel files OK.