Re:Ask HN: What are the biggest problems with spreadsheets?
by marekr on Thursday July 23, 2015 @10:23AM
(#9935876)
Do you mean transition from specific spreadsheets you would already have for that task? Or in a wider sense, e.g. as a company - gradually transition from using spreadsheets to using applications for some of the tasks?
[ Parent
| on HN ]
Re:Ask HN: What are the biggest problems with spreadsheets?
by debacle on Thursday July 23, 2015 @11:25AM
(#9936313)
I mean I should be able to take a spreadsheet, properly configured, and turn it into a CRUD app through some sort of wizard.
Or, as a programmer, I should be able to massage an existing spreadsheet (to confirm data types, maybe add some validations) and have that be able to be wrung through a CRUD app generator.
People use spreadsheets because they combine business logic, data, and a simple user interface into a single document. 99% of spreadsheets should actually be CRUD apps (in my experience, at least) but it's not worth the hassle of going that route until you already have close to 30 MB of unstructured, manually edited data.
Re:Ask HN: What are the biggest problems with spreadsheets?
by BjoernKW on Thursday July 23, 2015 @12:06PM
(#9936629)
We're doing the latter (on a rather small scale, mind you), transitioning existing Excel-based applications to scalable, robust architectures: http://excelkoenner.de/ (German-only right now, sorry)