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.
Panels have been renamed to screens to better reflect the
expectations of app authors. There are other name changes, which
better reflect how Calcapp is used today and how we expect it to be
used tomorrow.
Our next release will add a brand new formula engine, which will
support decimal commas in addition to decimal points in formulas. It
will also come with much-improved formula documentation and more than
100 new functions.
Ranges will enable authors to easily and concisely refer to multiple
values in formulas. Ranges, combined with the new function SUMIF,
will make conditionally summing values much easier than before.