Sliders enable users to rapidly change the value of a number field within a
defined range. On mobile devices with cumbersome on-screen keypads, we expect
sliders to become the preferred way of experimenting with numeric inputs.
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.