Build 4.5.0.92 of xlsgen adds read, write and calc support for the new LET() function.

Microsoft announced earlier in march that they would add the LET() function to the arsenal of Excel functions. Announcement is here.

The point of the LET() function is to able to name expressions that are often used multiple times in the formula and use the name instead of the expressions, improving the readability of the formula not just for the person who wrote the formula, but also for everyone else who will be tasked to update the Excel spreadsheet.

Microsoft made clear that this LET() function will only be made available on a subscription basis to Office 365 and none of the existing Excel versions out there will obtain it (we are talking about Excel 2019, 2016, 2013, ... none of which will ever get it).

xlsgen ships with support for the LET() function so you can write and calculate those formulas.

Here is an example :

LET( name1, expression1,
name2, expression2,
...
expression)

this function calculates expression where a number of smaller expressions appear, namely expression1, expression2, ... Instead of using the expression, this function lets the formula writer use name1, name2, ...

The ability to use names instead of literal expressions may improve the readability of the formula. And in addition to this, if a smaller expression is used multiple times in the global expression, using names instead improves the readability as well. And it improves the performance of calculations by caching (internally) smaller expression evaluations.