EEditor 2.4.1

What's new

• Spreadsheet functions, ready in any sheet formula with nothing to load: countif, sumif, averageif and their …ifs forms, counta, countblank, vlookup, hlookup, xlookup, index, match, ifs, switch, median, mode, stdev, var, large, small, rank, roundup, rounddown, left, right, mid, trim, proper, textjoin, concat, unique, sort. Conditions read the way a spreadsheet reads them — "Work", ">10", "<>Done", "W*" — and text compares ignoring case. (#41, #43)
• Whole columns: =(countif E:E "Work") reads column E down to its last filled row, and keeps up as rows are added. Rates!E:E reads another sheet's column. (eelisp-rs#20)
• A range wider and taller than one cell now arrives as a list of rows, so lookups know where a row ends. One row or one column is still a flat list, and sum/avg/min/max work as before. (eelisp-rs#20)
• Your own functions: put them in .eeditor/functions.eelisp — the open-functions command creates it. They load at launch and again whenever the file is saved. (#41)
• About EEditor, in the workspace's right-click menu and as the about command: the version, and who makes it. The macOS About box now shows the developer and website too. (#43)
• The manual has a new Spreadsheet functions section: https://eeditor.app/manual.html#sheets

Note: (length A1:C3) on a block now counts rows (3), not cells (9). A saved value only changes when its sheet next recalculates.

Downloads

Desktop builds of EEditor 2.4.1.

Platform	File
macOS (Intel + Apple Silicon)	.dmg
Windows 10/11 (x64)	.msi or -setup.exe
Linux (x64)	.AppImage or .deb

EEditor-* are the same installers under names that don't change between versions —
what the website links to. SHA256SUMS.txt has the checksums of every file.

The macOS build is ad-hoc signed: on first launch, right-click the app and
choose Open (or allow it under System Settings → Privacy & Security).
The Windows installer is unsigned, so SmartScreen will ask once —
More info → Run anyway.