Hacker News Reader

Paul, Dmitry, thanks for the link, the idea of an SQLite-backed spreadsheet with Python for computations looks quite enticing.

Right now, the spreadsheet is unworkable (formulas are updating where I don't want them to, visual editing glitches), hope you iron out the bugs.

View on HN

For formulas: could it be that Grist formulas are per-column rather than per-cell? This can take a little getting used to, but we think it leads to neater spreadsheets, and there are other features that can take up the slack that mixed-content columns used to (like multiple views within a page/tab). Sorry you hit editing glitches - thanks for letting us know, and if you have the time I'd like to hear more here or via the "give feedback" button in the app. Cheers!

Ah, this explains a lot, sorry for the confusion. It's an uphill battle to make folks drop their ingrained Excel habits, though.

Column-wide formulas are an example of Grist data being more structured than a traditional spreadsheet. In a spreadsheet, one might type over a cell because it's an exception. In Grist, you'd need to think what makes it special, and change the formula to reflect that. E.g. `=$Price - $Discount if $Status != 'Comped' else 0`. But once that exception is turned into a rule, it applies to all records. Which is a good thing.

Reply on news.ycombinator.com