Add steppers to number fields to make it easy to change their values using
plus and minus buttons. Sliders take up more space, but make it even easier to
experiment. There are also new formula functions, improved support for
embedding apps in web sites and a rewritten tour template.
If only some users need to use a large number of fields, start off by showing
only a few and give users the ability to add or remove fields using plus and
minus buttons. That way, you'll present an uncluttered user interface to most
users and only show lots of fields to users that really need them.
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.