4 ms·
Excel is excellent for simple formulas in a single spot. It sucks in two points: complex/ugly formulas (anything that requires a switch/case statement or nested
by PeterisP 14y ago
Excel is excellent for simple formulas in a single spot. It sucks in two points: complex/ugly formulas (anything that requires a switch/case statement or nested IF's) and heavily repeated(copypasta) formulas.
Here's what I can imagine as a real improvement: Allow me to write a piece of code that does the job of a function, but allows to touch multiple cells - and integrate it into excel as deeply as 'normal' formulas.
This means the following things that current macros don't really do:
a) Show the "formula" in the formula bar when selecting a result cell (it will usually be only a couple or dozen lines long anyway), and allow editing it in the sheet, not in a separate editor;
b) When a result cell is selected, highlight the data source cells (as is done for 'normal' formulas), and the other result cells;
c) When I change a source cell, recalculate all result cells automagically as for normal formulas - this likely imposes a 'no-side-effect' restriction on the code language.
d) For the "stdlib" use the same function names as current excel formulas, so you don't have to learn a new set of them.
Simple, and very useful - could LibreOffice handle that?
- mdda 14y agoPerhaps in the pop-up editor, the names of the parameters could also show their current values on hover (where possible), so that one could debug the function live, in a similar way to the sheet showing live numbers most of the rest of the time (with show-me formulae). Also, by doing functions like this, one could have some documentation too...