3 ms·
>Why is there not a code view for an excel spreadsheet? The MS Excel grid with code underneath each cell is declarative (not iterative loop) formulas so what w
by jasode 5y ago
>Why is there not a code view for an excel spreadsheet?
The MS Excel grid with code underneath each cell is declarative (not iterative loop) formulas so what would the ideal "code view" be?
Because of the architecture based on formulas, Excel does already have "Show Formulas" option (keyboard shortcut Ctrl+`) and "Trace Precedents" and "Trace Dependents".
For Excel iterative code like VBA Macros, it does have a typical "code view" (keyboard shortcut Alt+F11).
- triska 5y agoAn ideal "code view" of Excel could be a declarative programming language that states the relations that hold between cells, for example a logic programming language such as Prolog or Datalog, using constraints to express the relations.
- throwawayboise 5y ago> what would the ideal "code view" be? SQL?