Lotus 1-2-3 arbitrary resolution
lock.cmpxchg8b.com
Lotus 1-2-3 arbitrary resolution
1–10 of 130 posts
Re: Lotus 1-2-3 arbitrary resolution
#2very interesting software archeology!
Re: Lotus 1-2-3 arbitrary resolution
#3A bit off topic, but what I've wanted forever and never found is a spreadsheet that deals in units natively. So if one cell is in Newtons and I divide it by a cell that is in m/s^2 I want the resulting cell to be in grams. Units should propagate through the sheet automatically. Unit prefixes can either be automatic (km, m, mm, um, etc) or fixed as you would with a format setting.
Google calculator is the closest thing I've seen to this, but it isnt in spreadsheet form.
Anyone know of a system that provides this functionality?
Re: Lotus 1-2-3 arbitrary resolution
#4A bit off topic, but what I've wanted forever and never found is a spreadsheet that deals in units natively. So if one cell is in Newtons and I divide it by a cell that is in m/s^2 I want the resulting cell to be in grams. Units should propagate through the sheet automatically. Unit prefixes can either be automatic (km, m, mm, um, etc) or fixed as you would with a format setting. Google calculator is the closest thin…
Interestingly, it seems there's a Sheets add-on which provides at least some of what you want— unfortunately not with cell metadata, but rather using pairs of adjacent cells for the quantity and units:
https://workspace.google.com/marketplace/app/legendsheet/210...
The dev does a demo here: https://www.youtube.com/watch?v=K6Nvw2q889Q
Re: Lotus 1-2-3 arbitrary resolution
#5This is freaking awesome!
I mostly stick to GUI era software, and find Word 97 to be amazing for writing.
I run it inside a VM rather than using Wine.
Re: Lotus 1-2-3 arbitrary resolution
#6A bit off topic, but what I've wanted forever and never found is a spreadsheet that deals in units natively. So if one cell is in Newtons and I divide it by a cell that is in m/s^2 I want the resulting cell to be in grams. Units should propagate through the sheet automatically. Unit prefixes can either be automatic (km, m, mm, um, etc) or fixed as you would with a format setting. Google calculator is the closest thin…
Not a spreadsheet, no, (it is more of a freeform worksheet) but SMath Studio is a breeze to work on with units.
It has complete support for units of measurement and comes with most built-in. It can also decompose derived units into simpler forms if it finds a match.
It is free but not open-source.
Re: Lotus 1-2-3 arbitrary resolution
#7A bit off topic, but what I've wanted forever and never found is a spreadsheet that deals in units natively. So if one cell is in Newtons and I divide it by a cell that is in m/s^2 I want the resulting cell to be in grams. Units should propagate through the sheet automatically. Unit prefixes can either be automatic (km, m, mm, um, etc) or fixed as you would with a format setting. Google calculator is the closest thin…
spreadsheets barely have distinction between strings and numbers. Units would be another level! I hope that at some point something like a strongly typed jupyter notebook tailored specifically for table inputs would arise and replace some current usages of spreadsheets in office/consumer space.
Re: Lotus 1-2-3 arbitrary resolution
#8A bit off topic, but what I've wanted forever and never found is a spreadsheet that deals in units natively. So if one cell is in Newtons and I divide it by a cell that is in m/s^2 I want the resulting cell to be in grams. Units should propagate through the sheet automatically. Unit prefixes can either be automatic (km, m, mm, um, etc) or fixed as you would with a format setting. Google calculator is the closest thin…
Or a programming language? Or a Python module?
Re: Lotus 1-2-3 arbitrary resolution
#9A bit off topic, but what I've wanted forever and never found is a spreadsheet that deals in units natively. So if one cell is in Newtons and I divide it by a cell that is in m/s^2 I want the resulting cell to be in grams. Units should propagate through the sheet automatically. Unit prefixes can either be automatic (km, m, mm, um, etc) or fixed as you would with a format setting. Google calculator is the closest thin…
There's always Frink. https://frinklang.org/
Re: Lotus 1-2-3 arbitrary resolution
#10Stuff like this is so cool, and also highlights the importance of archiving the internet.
I've never used Lotus 1-2-3, but this makes me want to try and get it running to try out older software that is brutally efficient.