5 ms·
Things I miss in modern spreadsheets: - Formula references (to be used as function references) - Formatting formulas (directly in formula section, not via
by janci 7y ago
Things I miss in modern spreadsheets:
- Formula references (to be used as function references)
- Formatting formulas (directly in formula section, not via conditional formatting)
- Format-querying functions (as isBold, cellFontFamily, textcolor)
- better non-macro controls
- in-cell controls (instead of floating control objects)
- dynamic ranges (ie. you can paste any number of input values and all connected ranges will expand to the needed size)
- better external data handling
- serialization formats native support (json, xml) - no more error prone string pseudoparsing and manual concatenation without proper escaping
- HTTP(S) client for executing API calls from formulas
- (above requires selective manual re-evaluation instead full-auto/all-manual options we have)