12
votes
Recommendations for self-hosted spreadsheet software (such as Grist or Ethercalc)
two promising options I found from some quick googling were Grist and EtherCalc
of the two, Grist looks more compelling (I like the tech stack of Python+SQLite more than JS+Redis) but I'm open to any other suggestions as well.
the specific use case I have in mind to start out with is planning ratios for a Factorio megabase (sort of a local, homegrown version of tools like the Kirk McDonald calculator). if that works out well I'd also like to play around with doing household budgeting and finances with it.
if it matters: I'd be running this on Linux (NixOS); on an x86 box with plenty of headroom so I don't have any particular resource constraints; and I have an existing Postgres database server if that's an option for the backend
LibreOffice Calc?
Do they still use leaflet-the-mapping-library to simulate a remote desktop?
I got the impression that was never more than a tech demo.
I'd love to see LibreOffice have some kind of offline-first collaborative editing, ideally with plugins for back ends for data exchange.
I don't want a spreadsheet in my browser...I want a spreadsheet that can sync as nicely as Google Docs though. That's the holy grail IMO.
I'm sort of split 50-50 here. For alot (but not all) of my simple computing needs, i do see the value of (and appreciate/like) having an app in my browser...However, when we get to more powerful apps/tools like spreadsheets, that's when i really do NOT want them in a browser. And, as you noted, the holy grail is indeed having those implemented as offline-first, local, super-fast-to-respond, with locally-saved data app...which then can be configured to synch data to our other (user-controlled) places. Basically, the concept of what, say, Microsoft does with their Word app - where it is a locally-installed app, but it can be made to save locally and synched online, and then alternatively use the online version of Word (which i know, is close to horrible, etc.)...that's a close approximation to what i would liike...but, no way do i like that this is managed by an entity like Microsoft (or Google or other big providers that i do not trust).
To the original question posed by @spit-evil-olive-tips , while i have experience self-hosting the basic stuff from Nextcloud, i have never used their Office stuff (https://nextcloud.com/office/)...though i hear it can be nicely integrated with Collabora (https://www.collaboraoffice.com/). Maybe you might want to check out how the spreadsheet app works there?
These aren't exactly spreadsheets, but have you looked at jupyter or livebook?
I'm not sure if a simple excel alternative is enough for you (because for me self-hosted implies a server - client system)
But I use onlyoffice. It looks nice, is intuitive and has nearly all of excels features.