Conversation

Notices

1. minute (mntmn@mastodon.social)'s status on Thursday, 05-Oct-2023 21:13:16 JST minute

   i wish someone would write, from scratch (with modern, but minimalist approaches) a text-first spreadsheet that is based on something like TSV (but with some metadata) and can be easily synced/merged and viewed/edited on the web as well.

   • minute (mntmn@mastodon.social)'s status on Thursday, 05-Oct-2023 21:26:05 JST minute

     in reply to

     • Johann150 ⁂ :ipv6: :open_access: ☮

     @Johann150 yeah, both. cells could be styled with something like CSS

   • Johann150 ⁂ :ipv6: :open_access: ☮ (johann150@genau.qwertqwefsday.eu)'s status on Thursday, 05-Oct-2023 21:26:06 JST Johann150 ⁂ :ipv6: :open_access: ☮

     in reply to

     @mntmn@mastodon.social What do you mean with "some metadata"? On the level of the entire spreadsheet or for individual cells of the sheet? Like formatting cells (colours, font styles etc.) and having connected cells?

   • Ben Zanin (gnomon@mastodon.social)'s status on Thursday, 05-Oct-2023 21:46:14 JST Ben Zanin

     in reply to

     @mntmn argh, yes. For functionality and the text-first approach I am absolutely in love with the org-mode spreadsheet¹²³, but it's no good for simultaneous collaboration with other users.

     ¹: https://orgmode.org/manual/The-Spreadsheet.html

     ²: https://orgmode.org/worg/

     ³: https://www.gnu.org/software/emacs/manual/html_node/calc/index.html

   • minute (mntmn@mastodon.social)'s status on Thursday, 05-Oct-2023 21:54:41 JST minute

     in reply to

     • Ben Zanin

     @gnomon org-mode spreadsheet does not calculate in realtime though, or does it? maybe i'm remembering a different one in emacs where it was cumbersome to recalculate and rearrange things

   • Ben Zanin (gnomon@mastodon.social)'s status on Thursday, 05-Oct-2023 22:01:51 JST Ben Zanin

     in reply to

     @mntmn both automatic cell recalculation¹ and rearranging rows & columns while automatically updating formula references do work now, but I think only in the last couple of years did they get particularly polished.

     (I like the decoupling between data entry and formula evaluation, possibly because I got used to clock expressions in a different spreadsheet I used previously²³, but I think I'm in the minority.)

     ¹: https://orgmode.org/manual/Advanced-features.html

     ²: https://github.com/samuelludwig/teapot

     ³: https://www.syntax-k.de/projekte/teapot/

   • minute (mntmn@mastodon.social)'s status on Thursday, 05-Oct-2023 23:10:24 JST minute

     in reply to

     • djinn & juice

     @ieure yeah, visidata is really cool!

   • djinn & juice (ieure@retro.social)'s status on Thursday, 05-Oct-2023 23:10:25 JST djinn & juice

     in reply to

     @mntmn Doesn't have the web/sync/merge bits, but VisiData is awful close to the rest.

   • Steinar Bang (steinarb@mastodon.social)'s status on Friday, 06-Oct-2023 00:03:08 JST Steinar Bang

     in reply to

     • Ben Zanin

     @mntmn @gnomon It triggers recalculation when you leave a cell (once the row and column formulas are in place).

     Setting up the formulas can be a bit non-intuitive (sometimes the formulas created from ":=" or "=" needs a little manual tweaking), but once they are in place recalculation works sweet for my purposes.

     But it's not easily separable form the rest of org-mode I think.

     Of course org-mode is where I organize my life anyway...