Build 2.1.0.58 adds the ability to read and write array formulas and array constants. This is a long overdue, and I have thought it was time to enable it.

Array formulas is a somewhat abstract concept in Excel : it allows to define formulas based on references that are intentionally larger than usual (for instance areas instead of cells) which are then projected depending on the context. Array formulas can return multiple values. One can create an array formula in Excel by entering a formula and hitting Ctrl+Shift+Enter. It adds braces around the formula, as in {=SUM(D3:E3*D4:E4)}

Array constants are simply a way to put multiple constant values in the same place. Constants are either numbers or strings, not cell references. An example of array constant is =SUM({1;2}). Note the position of braces.

How to create array formulas and array constants? As usual (here in C++),

// an example of array-formula
worksheet->Formula[8][4] = L"{=SUM(1;2)}";

// an example of array constant
worksheet->Formula[8][4] = L"=SUM({\"euro €\";1.0123;4;\"\"})";