![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
HOFs in Google Spreadsheets
Dec. 23rd, 2007 09:56 pmI discovered the delightful inclusion of a "map" function ("ARRAYFORMULA") in Google Spreadsheets today. Those of you with experience programming in functional languages will appreciate the elegance of this, and of the other higher-order functions (HOFs), none of which have yet made it into the world of spreadsheets as far as I can determine, Google or otherwise.
![[livejournal.com profile]](https://www.dreamwidth.org/img/external/lj-userinfo.gif)
terpsichore1980 (whose job requires her to be an Excel wizard) informs me that Microsoft have gone down the road of implementing custom functions for every combination of HOFs they think their users might need (eg COUNTIF, which is equivalent to FOLD(ADD(),(MAP(IF(condition, 1, 0)))) in some vaguely spreadsheety functional pseudocode, or ARRAYFORMULA(SUM(IF(rangecondition, 1, 0))) in Googlese.
Anyway, it made me happy, and I thought I'd share it.
terpsichore1980 (whose job requires her to be an Excel wizard) informs me that Microsoft have gone down the road of implementing custom functions for every combination of HOFs they think their users might need (eg COUNTIF, which is equivalent to FOLD(ADD(),(MAP(IF(condition, 1, 0)))) in some vaguely spreadsheety functional pseudocode, or ARRAYFORMULA(SUM(IF(rangecondition, 1, 0))) in Googlese.Anyway, it made me happy, and I thought I'd share it.
