The new formula functions TONUMBER, TOLOGICAL and TOTEXT make it easy to
convert values to numbers, logical values and text strings, respectively.
Converting numbers stored as text to true numbers was previously impossible if
the number had a fractional part.
The tour template shows off many of Calcapp's features and has been completely
rewritten. The new tour demonstrates steppers, sliders, number formatting,
date calculations, cross-references and more. There's even a color selector
for the background color.
To get the number of hours, minutes or seconds between two dates, subtract one
date from the other and use the HOUR, MINUTE or SECOND formula functions.
HOUR won't return a number greater than 23 and MINUTE and SECOND won't return
a number greater than 59. Read on to learn how to fix this.
Reset buttons enable users to conveniently wipe out all data entered in an
app, but pressing them accidentally can ruin days of data entry. This tip
explores a number of techniques for making it harder to press them
accidentally, including hiding them unless the user confirms that they should
You can now use formatted text, including bold, italic and bulleted and
numbered lists. Include links to not just web sites, but also e-mail addresses
and phone numbers. Finally, reports can now be opened directly from apps.