NewsLab
Apr 28 23:38 UTC

L123: A Lotus 1-2-3–style terminal spreadsheet with modern Excel compatibility (github.com)

91 points|by duane1024||21 comments|Read full story on github.com

Comments (21)

21 shown
  1. 1. create_accounts||context
    It would be great to have a terminal compatible Wordperfect alternative, like in the MS DOS days. Can you use Vim to edit documents for printing?
  2. 2. duane1024||context
    I started this project because I was nostalgic for Lotus 1-2-3, but I really really really loved WordPerfect. I'm afraid of starting that project, however, as it might take over my life :) I used to use WordPerfect 5.1 on a 386 PC to edit my school newspaper with multiple columns, graphics, custom fonts, etc. No WYSIWYG, just the power of Alt+F3 (Reveal Codes)!
  3. 3. gerdesj||context
    I still have an original cardboard strip with the function key codes on it somewhere. Ctrl-F9 ... font (I think, it was rather a long time ago).
  4. 4. somat||context
    Reveal Codes is a good start, but if I remember correctly they were read only. you could not close the loop and enter codes.

    Reveal codes in a small way made me swear off word processing for good. We had an office document in wp 8 or 9 if remember correctly, you know the type, it lived on a shared drive and whoever needed to make changes did. anyhow it was a complete mess, internal corruption all over the place, no consistent style. one night I sat down with it and thanks to reveal codes I was able to clean it up. At which point I had a revelation, most of the sins of the document were due to the WYSIWYG interface. I was able to fix it because I could(almost) see the source. Why not cut the middleman write the document in source and render it to the final form. So I rewrote it in html. and have had a lingering resentment of word processors ever since.

    You know why they call them word processors right?... Ever see what a food processor does to food?

  5. 5. devilbunny||context
    Ami Pro 3.1 was WYSIWYG with reveal codes. You could move the tags around, though I don't recall if you could enter them directly. Also happened to have the best WYSIWYG equation editor I've ever used.

    Not the most stable software in the world, but I loved it. It made writing lab reports as a chemistry major so much simpler (especially combined with ChemDraw).

  6. 6. kstrauser||context
    WP5.1 gave me some fun times. I was in the Navy and transferred to a school with a month or so to kill before class started. They dropped me into a data processing office as something to do while I waited. The job was easy: read a file off a floppy, put it into the right format in WP, print it, and repeat. I discovered WP’s macro language and automated my way into a cushy job: instead of the 16 reports a day we were suppose to process, I could do about 20 an hour.

    My boss was impressed, thanked me profusely, and told me to STFU about it. We’d come to work in the morning and knock out the day’s work in an hour, piddle around until lunch, then go home and enjoy the San Diego weather for the rest of the day.

    That was a pretty terrific couple of months.

  7. 7. kcartlidge||context
    If asked, I often name WordPerfect 4.2 as the best software I ever used. And that it was written in assembly is incredible.

    The book Almost Perfect [1] details those early times at WordPerfect.

    Incidentally, amongst the other best software I'd be tempted by Lotus 123, DataEase 4.53, Turbo Pascal 3, and Elite (BBC).

    [1] http://www.wordplace.com/ap/index.shtml

  8. 8. bitwize||context
    Yes, if you use a formatter like LaTeX. The beauty part is, "Reveal Codes" is always on!
  9. 9. manithree||context
    As a big fan of WordPerfect on my first DOS machine (286 clone), I agree. I respect authors like GRRM for sticking with WordStar, but whenever I get nostalgic and wondering about WordPerfect in DosBox, I remember I use emacs and typst. All the good things about WordPerfect, but vastly superior.
  10. 10. bitwize||context
    I keep seeing ads for expensive "writerdecks" that run between $500 and $1200 and have a bare-minimum OS that is intended for distraction-free writing. I keep wondering how these are any better than an old laptop, FreeDOS, and WordPerfect 5.2, except as Veblen goods.
  11. 11. bananapub||context
  12. 12. LeoPanthera||context
  13. 13. recsv-heredoc||context
    I can highly suggest visidata! https://www.visidata.org

    It's an incredibly useful piece of software for data wrangling and exploration.

  14. 14. easygenes||context
    Very early in my career I made friends with the business’s sole Lotus Notes administrator, "the email server guy." He was pretty proud of what it could do, and I sometimes get nostalgic for the admin UI.
  15. 15. nhatcher||context
    Cool to see this here! There are quite a few other terminal based spreadsheet people have been doing over the last few years.

    Most notably:

    https://github.com/andmarti1424/sc-im

    Has been in HN often, most recently:

    https://news.ycombinator.com/item?id=47662658

    New takes: https://github.com/zaphar/sheetsui https://github.com/garritfra/cell

  16. 16. tswq||context
    Doesn't seem as useful as visidata. Will check out though! Looks like a fun weekend project :)
  17. 17. CTOSian||context
    yea visidata light years , I still use 123R2 runs fine under msdos runner - old version I know but I have a hack of addins :}

    as for that project .. well not even windows binaries there

  18. 18. LeoPanthera||context
    See also Wordgrinder, a text-mode word processor. (As distinct from a text editor.) https://github.com/davidgiven/wordgrinder
  19. 19. bb88||context
    I remember being a teenager and building forms using the Lotus 123 WYSIWYG graphics.
  20. 20. taviso||context
    Hey, another 1-2-3 nerd :)

    I don't have any nostalgia it, I just appreciate how thoughtfully it was designed for data-input efficiency. I actually ported the official UNIX version of 1-2-3 to Linux a few years ago, I still use it regularly. It uses some tricks to get the original UNIX binaries working on Linux: https://github.com/taviso/123elf

    I had been thinking about how to add UTF-8 support, it only supports LMBCS (Lotus Multi-Byte Character Set) by default. It's actually worse than that, it stores everything internally as LMBCS but in a lot of cases can only display ASCII, so it transliterates a lot of characters (e.g. é -> e).

    It's also possible to run the real DOS version in dosemu - in terminal mode it's basically indistinguishable from an ncurses application, although dosemu is just cleverly sampling the framebuffer and translating it on-the-fly.

    I wrote a display driver to make that work a little better: https://github.com/taviso/lotusdrv

  21. 21. karunamurti||context
    I took Lotus 1-2-3 course along with Wordstar and dBase when I was in elementary school. Good times.