ICFP 2022
Sun 11 - Fri 16 September 2022 Ljubljana, Slovenia
Fri 16 Sep 2022 14:00 - 14:30 at E3 - Session 3 Chair(s): Arthur Gleckler

In this lightning talk, we demonstrate Visual Scheme for Applications(tm) (VSA) as both an Excel formula language and a general-purpose scripting feature of Microsoft 365, comparing VSA’s first-class lambda support to the new LET and LAMBDA functions in Excel’s built-in formula expression language, and highlighting its extrinsic value as an interoperability aid for Office solutions at multiple levels. VSA breaks out of Excel’s deterministic calculation model with integrated logic programming, making direct database access transparent such that storing data “in Excel” is no longer an antipattern but architecturally supported with minimal conceptual fuss for the end-user. For example, the ability to use a lambda defined in Scheme both as a spreadsheet function and as an extension of ANSI SQL using the “custom function” API of the popular SQLite engine, with full access to the .NET runtime under the hood in both contexts, makes it possible to do many things in Excel that were previously unimaginable. Finally, we show a preview of Clojure and Scheme “tag teaming” the task of modernizing legacy Office solutions to the latest cross-platform microservices patterns and practices.

Fri 16 Sep

Displayed time zone: Belgrade, Bratislava, Budapest, Ljubljana, Prague change

14:00 - 15:30
Session 3Scheme at E3
Chair(s): Arthur Gleckler SRFI Editor
Industry talk
Introducing Visual Scheme for Applications: Modernizing Office Solutions on the CLRVirtual
Bob Calco Apex Data Solutions, LLC
An FFI between Gambit Scheme and CPythonVirtual
Marc-André Bélanger Université de Montréal, Marc Feeley Université de Montréal
R7RS Large Status ReportVirtual