* Recalculate formulas a la excel: https://orgmode.org/worg/org-tutorials/org-spreadsheet-intro...
* Actually you can go way further than cloning basic excel functionality. For example, you can write inline code to generate or retrieve some data, feed that into a graphing program, and then inline the resulting chart back into the org file. https://orgmode.org/worg/org-contrib/babel/intro.html
* Display inline images: https://stackoverflow.com/questions/17621495/emacs-org-displ...
(I'm an enthusiastic org-mode user, by the way.)
I find inline pictures very helpful when Org Babel is used as analog of Jupyter notebooks (plantuml diagrams, pandas plots).
I am back to using org-mode for other stuff.
The other limitation of out-of-the-box Org Mode "plain text" architecture is that it limits collaboration of letting other users edit my file because fine-grain locking is not as straightforward as with a db file like SQLite. My "master todo list" is easier to manage if I can let my significant other can enter items for me instead of me doing all the manual data entry myself.
I do understand that since Emacs has Lisp, it can ultimately do anything if you really want to customize/extend/research it.
That said, no, I don't actually think it is a replacement for spreadsheets. Especially not if you are already fluent in them.
(EDIT: In the meantime, I guess you could shell out to https://www.gnu.org/software/datamash/manual/datamash.html.)
On the topic of commandline spreadsheets; I'm a huge fan of sc(1), a cute curses-based spreadsheet calculator.
However, at this point I'm OK with shelling out to external tool for data wrangling.
Linking implies too many manual operations to keep things tidy when moving headings around. Try Org attachments[1].
- Basically, a heading has an attachment directory, whose name is by default generated by Org, and optionally inherited from some level in the outline hierarchy.
- Any attachment is represented by a heading with the :ATTACH: tag and an ID in the :ID: property of its drawer. Actual files can be e.g. copied, moved, or symlinked.
- Attachment directories, the :ATTACH: tag and :ID: property are conveniently added by one of the attach commands, but can also be customized (`org-attach' is the dispatcher, bound by default to <C-c C-a>).
- For a given heading, run a command (conveniently, from the dispatcher) to visit the attachment directory for the heading from the configured file browser or Dired: <C-c C-a f> and <C-c C-a F>, respectively.
If it makes sense to move attachments when moving headings around, or when otherwise adding files externally to the attachment directory, there is `org-attach-sync' (<C-c C-a z>):
Synchronize the current task with its attachment directory, in case you added attachments yourself.
[1]: https://orgmode.org/manual/Attachments.htmlWhen referencing one of the attached files within the heading, one can use the `attachment' link type, which points to files resolving to the attachment directory[1]. The format is [[attachment:FILE-IN-ATTACHMENT-DIR][DESCRIPTION]] and can be easily inserted with completion by `org-insert-link'.
For more complicated attachment linking scenarios it might be better to configure the attachment directory to be absolute (`org-attach-id-dir').
Conclusion: The use of Org attachments and the attachment: link type stabilizes links to files.
Ultimately, it depends on the type of user but the "barrier" may be that it's plain text. So Org Mode's data format as a desirable selling point is also its ceiling of functionality.
Yes, I store 90% of my notes in plain text. But I also store some programming notes in MS Excel because I need a datagrid as UI with dynamic calculations. I store some project notes in MS Word because I need to embed graphics along with text. I suppose I could use Org Mode as a "single source of truth" by linking to .xlsx and .docx files but I reorganize my folder structures too often to make such file links stable.
I made a previous comment why Emacs Org Mode along with everything else I tried in the last few decades to organize life is a very hard problem of "boiling the ocean": https://news.ycombinator.com/item?id=23112843