4 ms·
I wish people wouldn't copy Excel (or Google apps for that matter). Those spreadsheets are terrible. It still baffles me that none of them can do sideways scr
by rwmj 6y ago
I wish people wouldn't copy Excel (or Google apps for that matter). Those spreadsheets are terrible. It still baffles me that none of them can do sideways scrolling correctly, they are all incredibly awkward to edit, the formulae are fundamental to how they work yet hidden and obscure, they do weird "magical" stuff to strings like turning them into numbers or dates when you didn't ask, etc.
I'd really like to see people explore new paradigms. Something that has the functionality of a spreadsheet but looks nothing like current spreadsheets.
- continuational 6y agoI rather like the Airtable concept - it feels like a spreadsheet, but the columns are typed, and it can do joins. It's a shame that it's so limited (50,000 rows in the most expensive plan).
- ptman 6y agohttps://baserow.io/ https://baserow.io/ is promising
- hoistbypetard 6y agoThat looks really interesting. I hadn't run across it yet. Thanks.
- hexmiles 6y agoThey really are, i want a self-hosted airtable so bad... I just found out you can sponsor them: https://github.com/sponsors/bram2w https://github.com/sponsors/bram2w
- paulhodel 6y agohttps://jexcel.net/v5 https://jexcel.net/v5
- asplake 6y agoTerrible, but extraordinarily successful.
- adrianmsmith 6y ago> It still baffles me that none of them can do sideways scrolling correctly Ironically the original version of Google Sheets could do sideways scrolling correctly. At some point (maybe around 2010?) to be more like Excel.
- radva42 6y agoI had the same thought as you and started working on something that can be described as "AirTable meets Webflow". It's basically a no-code database with drag-and-drop page builder: tables are created and linked together (like in AirTable) and interactive pages are designed to work with that data (like in WebFlow). So in other words users don't directly use a spreadsheet-like UI to work with the data. Instead they use custom-designed pages - it is both much more powerful (e.g. fully scriptable, multiple pages can be linked to form more complex workflows, which wouldn't be even possible with spreadsheets) and yet easier to use. Oh, and it's self-hosted. Judging by the response from users it does seem like something like this is really needed. I put some pretty crude demos online about a year ago [0] ... back then the idea was to create a more general purpose no-code web app builder, but since then I decided to focus specifically on database applications. [0] https://www.formbeaver.com https://www.formbeaver.com
- kgwxd 6y agoI just happened across https://www.calcapp.net/ https://www.calcapp.net/ yesterday while doing research for a project I'm currently working on that requires similar features.
- chrispsn 6y agoWhen you say 'has the functionality of a spreadsheet but looks nothing like current spreadsheets', what do you mean? I am working on Mesh Spreadsheet. It gives you a spreadsheet UI that writes code as text. It will likely use k9 as the formula language once it matures, but: - you can try the JavaScript prototype at this link: http://mesh-spreadsheet.com http://mesh-spreadsheet.com - you can see a proof of concept video using k here: https://www.youtube.com/watch?v=CEG9pFNYBCI https://www.youtube.com/watch?v=CEG9pFNYBCI
- rwmj 6y agoThe problem is exactly that I don't know what I mean. That's why I think yet another Excel clone - whether it's free or works on the web or not - is not interesting. Your talk was interesting, thanks.
- mthoms 6y agoHi, what's K9? My Google searches in combination with "formula and/or language" gave me only dog related results.
- i_don_t_know 6y agoThat‘s pretty cool. One reason I prefer Apple Numbers to Excel is that in Numbers you arrange tables on a canvas. The tables can refer to each other. I think it makes it easier to work with, for example, an input table and an output table because they are separate entities and not just different ranges on the same grid. It’s similar to how some websites enable you to configure a dashboard view of multiple tables and charts. Your presentation reminded me of that, specifically the view of how you implemented the tool in itself. But you’re using one large table rather than a collection of tables on a canvas. I’m wondering if the Numbers approach might work better. In particular it might be more natural for dynamic arrays because they would not “overlay” a range of cells. They would be their own dynamically resizing table on the canvas. This might lead to something like Spreadsheet 2000: https://en.m.wikipedia.org/wiki/Spreadsheet_2000 https://en.m.wikipedia.org/wiki/Spreadsheet_2000