INTERSECTION performance

From tonight's build of 2.8, the INTERSECTION, UNION and INVERSE functions now perform as well as the older SUBSET functions and can be used instead in all cases.

So, for example, rather than use the somewhat convoluted:

SUBSET3(field1, field2, field3, value1, value2, value3,
operator1, operator2, operator3)

you can now use the much simpler format:

INTERSECTION(
SUBSET(field1, value1, operator1),
SUBSET(field2, value2, operator2),
SUBSET(field3, value3, operator3)
)

as well as using more complex logic such as:

UNION(
INVERSE(SUBSET(...)),
INTERSECTION(
SUBSET(...), SUBSET(...), ROWINDEXSUBSET(...)
)
)


Formula editing

Additionally, the formula editor now has improved UI performance and is easier to read, with contextual highlighting of relevant parts of a formula immediately surrounding the cursor position, allowing you to visualise the formula structure better.

Simplify and Reformat

Two new buttons have been added to the formula editor:

"Simplify" converts complex SUBSET2 to SUBSET5 variants into INTERSECTION-based formulae. In future it may also change use of other legacy functions into their recommended alternatives.

"Reformat" reformats all whitespace in your formula for readability.

Neither of these commands will affect the formula result, but "Simplify" may yield better performance in future.