Overview

Release 11.00, updated 2024-10-20, "Jørn Utzon"
Architect of the Sydney Opera House inaugurated and opened on 20.10.1973 by Queen Elizabeth II

Bugfixes

• Color code for 'dark blue' used in entitites returned light blue. Has been fixed.
• Outputting blank dates will alway be an empty string. In the past, "0000-00-00" was occasionally returned.
• table save excel file(): Did not format any Excel sheet if the 1st shet contains no formatting info. Resolved.
• table load excel file(): If Excel table is empty, an error message was generated in the past. Has been resolved.
• table load excel file(): Entities were displayed on ampersand, greater and less than symbols for calculated string contents. Has been fixed.
• table load excel file(): Missed time of day in some date formats. Fixed.
• table load excel file(): Under certain conditions, some dates are read as integers. Fixed.
• Error messages: Location of indentation of contents with marker where the error is assumed was not always correct
• Error messages: Association to type of code was sometimes wrong. Has been fixed
• Ranges: Ranges between 2 non-numeric values did not work, e.g. {a .. a } -> {a}. Has been resolved
• table merge() function family: If source table is wider than destination table, the consolidation actions are ignored. Fixed.
• str(): When calling to convert numbers into formatted text, the option 'swiss' is now supported for Swiss 1000 separators

New Functions

• flip horizontally(), flip vertically(__): Flips matrices
• rotate left(), rotate right(__): Rotates matrices
• table flip rows(), table flip columns(), table flip selected rows()
• table flip horizontally(), table flip vertically(__)
• table rotate left(), table rotate right()
• identity(): Returns identiy matrix of specified size
• characters(): Splits string into set of characters
• for all parameters() is replaced by for all()
• repeat(): A simple loop function
• for all characters(): Loops through characters in a string
• table insert cells in columns(), table insert cells selected rows()
• cbrt(): Cube root
• histogram(): Creates one- and multi-dimensional histograms
• table assign(): Allows assigning values into multiple table entries in a single statement
• print matrix(), compose matrix(), echo_matrix(__): Outputs 2-dimensional sets as matrices onto the console
• pad(), align() and additional string functions
• vmin(), vmax(__): Vectorizable min and max functions
• limit(): Squeezes the numeric value into given lower and upper boundaries
• include if(), include if any(): Filters out the set with matches on other parameters, columns, etc.
• table find cells() function family
• table write cells() function family
• table read cells() function family
• table write cells() function family
• table replace cells() function family
• table add calculated columns(), table insert calculated columns() are smart variants of table insert columns().
• replace if(): Replaces values if condition is true. This function is vectorizable and the condition check is done for every element covered.

Improvements in Existing Functions

• Function reschedule(): Added options like "Next Monday", "This Monday", "Previous Monday"; applicable for all weekdays
• table delete selected rows(): Supports negative numbers. If -1 is chosen, then delete rest of table (... and stop).
• assign(): Allows assigning a value or expression into mulitple variables in a single statement
• set() renamed to variable members() to make function namings more plausible
• set names() changed to variable names() to make function namings more plausible
• parameter set() changed to set() to make function namings more plausible

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

• Vectorization: Ability to pass sets of values (such as vectors, matrices, etc.) into various mathematical, string and other functions for powerful execution

Other new Features

• Improved web documentation
• B4P Extension available for Visual Studio Code

Clean-ups and Streamlining

• Implementation of the function reschedule() has been cleaned up.

Performance Improvements

• Function calls returning sets with large contents run faster

Depreciated and retired features

• for all parameters() is replaced by for all()