Steppers enable users to quickly increase or decrease numbers using dedicated
buttons, displayed next to the value. A variety of properties are available
for customizing steppers, including minimum and maximum values.
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