With Stencila Sheets we want to help authors spot and fix errors faster. One idea we had is introducing a source mode view, to reveal what's going on behind the curtain. Consider this simple calculation sheet with errors:
Instead of checking each cell individually, we could head over to source mode.
- a tool (in the toolbar) that lets you toggle between display and source mode
- when you move the cursor inside a formula, you see all the dependencies visualized with dashed lines (In excel you need to enter a cell to see that, which is why you often overlook errors)
- you also see the current value previewed in the status bar on cell selection (this is inverse to revealing the formula in display mode)
- we use a fixed width font for everything to indicate we are editing the source here
Would you use such a feature? Please add your comments/ideas!