3 ms·
does anyone know how this kind of stuff gets built ? I'm considering a spreadsheet-y internal admin dashboard for my startup. I was looking at https://github.co
by sandGorgon 9y ago
does anyone know how this kind of stuff gets built ? I'm considering a spreadsheet-y internal admin dashboard for my startup. I was looking at https://github.com/JoshData/jot https://github.com/JoshData/jot to be able to sync stuff on the client side to the server.
has anyone worked on something like this ? the big challenge is synchronization - between server and multiple clients - while being able to offload a lot of computations on to the client.
I wonder how is the security built ? if i maliciously change the formulas in my browser.. will the backend datastore still accept the data ?
- fiatjaf 9y agoThe big challenge is implementing the spreadsheet UI.
- TomMarius 9y agoThere's a React component for that. React-datasheet or something like that.
- sandGorgon 9y agoActually aggrid or handsontable are the commercially available spreadsheet browser plugins. We use HOT, but have been considering aggrid. Because of these tools, that's not the hard part any more..It's the synchronization and computation logic.
- fiatjaf 9y agoI know there's a React component. There are many. They don't come even closer to the functionalities of an actual Excel-like spreadsheet. Implementing 70% of the most basic of all functionality of Excel is easy. Implementing 90% is insanely difficulty. I would say Handsontable reaches the mark of 78%. I've tried twice, one with React + Mori[0] and one in Cyclejs[1]. In the first I may have reached 82%, in the second probably 85%. But in both cases the latest features I added started to conflict with the oldest ones and I abandoned everything. [0]: https://github.com/fiatjaf/react-microspreadsheet https://github.com/fiatjaf/react-microspreadsheet [1]: http://sheets.alhur.es/ http://sheets.alhur.es/
- deleted 9y ago[deleted]