CSV files produced by report buttons can now be customized to make
them compatible with more apps and services. Change the decimal
separator and the delimiter separating values and lay out values
vertically instead of horizontally.
If a function isn't returning the value you expect, you need to look
at the parameters it receives by creating new temporary fields
visualizing the parameters. To do so with an array, you need to
convert it to a text string first using the TEXTJOIN function.
Ranges are an effective means of creating arrays containing many
elements. However, it is easy to lose track of what elements they
contain, which can have surprising results. This tip explores this
topic in depth.
We work hard to ensure that your apps continue working, even as we
add features to Calcapp. With our new formula engine, we have made
some minor changes, but they should not affect your existing apps.
Colors can now be referenced with no risk of typos, thanks to
"enums." XLOOKUP, XMATCH and FORMATDATE also support enums, which
help warn you of errors early.