Live data from Hacker News

Lotus 1-2-3 arbitrary resolution

lock.cmpxchg8b.com

11–20 of 130 posts

Re: Lotus 1-2-3 arbitrary resolution

#11
post #3

A 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…

Never tried it, but Wolfram has a Mathematica plug-in for Excel.

https://www.wolfram.com/products/applications/excel_link/

Re: Lotus 1-2-3 arbitrary resolution

#12
post #9
post #3

A 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/

Or f# https://docs.microsoft.com/en-us/dotnet/fsharp/language-refe...

Re: Lotus 1-2-3 arbitrary resolution

#15
post #3

A 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…

Yes this would have been so useful in my lab courses at university. Bonus points if cells could have errors and it could do error propagation.

I started working on this back then but got frustrated trying to make a grid control and gave up :-)

Re: Lotus 1-2-3 arbitrary resolution

#17
post #9
post #3

A 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/

R also has a units package. It's mostly used by geospatial libraries.

Re: Lotus 1-2-3 arbitrary resolution

#18
post #3

A 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…

Interesting! I do this on paper a lot because that's how I learned in college. Thinking of it. It's composing converters. That should be fairly easy to automate!

Re: Lotus 1-2-3 arbitrary resolution

#19
post #3

A 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…

The only one I know of is org-mode[0]. It defers calculations to calc-mode which handles units.

[0]: https://orgmode.org

Re: Lotus 1-2-3 arbitrary resolution

#20

This 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.

Word97 has actually run perfectly in Wine since 1998-1999. I tested it back then and it worked perfectly.
Post reply on HN