4 ms·
Totally agree that audibility is an important part of the story here! Having spent the past 2 years building a spreadsheet [1], it's really interesting how oft
by narush 4y ago
Totally agree that audibility is an important part of the story here!
Having spent the past 2 years building a spreadsheet [1], it's really interesting how often we run into design problems that pit "audibility" against "what you expect from a spreadsheet."
A simple example: imagine you add a filter to column to remove null values, you then go and create a new formula that is dependent on this filtered column, before finally going back to edit the filter.
On one hand, effective audibility usually implies a nice, linear story you can follow and understand. On the other hand, users expect filters to update based on the most recent values - but the filter is applied in a way-old step. In practice, there's a bunch of extra state you have to store to make sure things work properly, and even then, there are lots of foot guns!
[1] https://trymito.io https://trymito.io