Comment by rpod
7 years ago
Especially since org-mode has a built-in spreadsheet system that supports formulas written in emacs calc or even arbitrary elisp: https://orgmode.org/worg/org-tutorials/org-spreadsheet-intro...
7 years ago
Especially since org-mode has a built-in spreadsheet system that supports formulas written in emacs calc or even arbitrary elisp: https://orgmode.org/worg/org-tutorials/org-spreadsheet-intro...
I really should learn that. I often find myself maniupulating text data in emacs, turning it into CSV or something that I can then copy/paste into a spreadsheet for calculations.
You should. It's surprisingly good. You won't get pivot tables (at least until someone codes them up, which isn't out of the question in Emacs community), but for regular calculations it's awesome.
Here's a short intro: https://orgmode.org/worg/org-tutorials/org-spreadsheet-intro....
Here's some documentation: https://orgmode.org/manual/The-Spreadsheet.html
And if you feel that TBLFMs are getting unwieldy, here's a bunch of features I absolutely love: https://orgmode.org/manual/Advanced-features.html. Turning on an extra column lets you name columns and cells, and have Org Mode recalculate the table automatically on any change, instead of on explicit command.
I didn't know about calculation marks, thanks for sharing! I use org spreadsheets to keep track of my D&D party's character sheets, so this should definitely come in handy :)