In this release:
- New: Confluence 11 support. The app is now a transformerless plugin, as Confluence 11 requires. Tested on Confluence 9.2, 10.2 and 11.0.
- New: VLOOKUP and HLOOKUP accept Excel's fourth argument: FALSE() gives an exact match, as before, and TRUE() an approximate match in a sorted range.
- Fix: IF, CHOOSE and SWITCH evaluate only the branch they return: IF(B2=0; 0; A2/B2) now returns 0 when B2 is 0 instead of failing with "Division by zero".
- Fix: results are shown with at most 15 significant digits, as in Excel: 0.1+0.2 is shown as 0.3, not 0.30000000000000004. The same applies to sums of decimal table values.
- Fix: concatenation (&, CONCAT) writes numbers as Excel does: "Total: " & (2*3) gives "Total: 6", not "Total: 6.0".
- Fix: ROUND, ROUNDUP, ROUNDDOWN and TRUNC round the decimal value: ROUND(1.005;2) = 1.01 and ROUNDDOWN(0.29;2) = 0.29.
- Fix: SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIFS, MAXIFS, MINIFS and INDEX accept arrays such as MAKEARRAY(...); before, the IFS functions returned 0.
- Fix: Correct results for RATE, NETWORKDAYS with the end date before the start date, DATEVALUE("2026/02/28") and VALUE("1,234.5"); DELTA accepts its second argument.
- Fix: Division by zero shows a readable message.
- Compatibility: Confluence Data Center 9.2 – 11.0. Load macro dynamically works on Confluence 10.x and 11.x; on 9.x such formulas are calculated with the page. See the Math documentation.