Overview

Release 12.01, issued 2025-07-27, "The Last Duck"
On 27. July 1990, precisely 35 years ago, Citroen has assembled the very last 2CV compact car. In Germany, this car bears the nickname "Ente" (duck), probably the short form of "StudENTEnauto", a car university students could afford.

Bugfixes

• table rename() did not delete the table if a table with the same new name is existing. Has been fixed.
• column ranges: Range of same column name 'A'..'A' returned column 'A' twice and not once. Has been fixed.

New Functions

• excel list tables() lists all Excel tables by name
• excel list pivot tables() lists all Excel pivot tables, returning sheet name + "/" + pivot table name
• table summarize() generates pivot table like summaries
• table summarize selected rows() similar, able to filter on rows of interest

Improvements in Existing Functions

• table load excel file() now supports loading multiple sheets, tables and pivot tables with one function call

New Language Features (e.g. syntax and semantics)

Other new Features

Clean-ups and Streamlining

• Improved navigation bar for the online documentation

Performance Improvements

• Much faster to load multiple tables from one Excel file with table load excel file()

Depreciated and retired features

• for all parameters() is replaced by for all() (Still existing, but no longer recommended to use)