In this release:
- Fix: Filter and Highlight when: a comparison that cannot be evaluated – a number against text such as 0 > "TBD", or an empty Jira field – no longer counts as a match. Before, CurrentItem.properties.Budget > 10000 kept every page whose Budget was text.
- Fix: Page Properties Data Provider: Max results counts report lines, as the native Page Properties Report does – pages without a Page Properties table no longer use up the limit. With Value format: Typed, "-$1,500" is read as a number.
- Fix: formulas in columns, Filter and Highlight when get the formula-engine fixes of Math 27.0.0: IF, CHOOSE and SWITCH evaluate only the branch they return, so IF(x=0; 0; y/x) works; "Total: " & (2*3) gives "Total: 6"; decimal-exact ROUND, ROUNDUP, ROUNDDOWN and TRUNC; MAKEARRAY arrays in the IFS functions and INDEX; correct RATE, NETWORKDAYS, DATEVALUE and VALUE; VLOOKUP and HLOOKUP accept a fourth argument.
- Compatibility: Confluence Data Center 9.2 – 11.0. Load macro dynamically works on Confluence 10.x and 11.x; on 9.x such reports are rendered with the page. See the Reporting documentation.