Addenda and Errata

Features added since documentation printed

Toolbar

Most of the toolbar buttons have been added since the documentation was printed; simply point at them when interactive Help is active and it will tell you what they can do. There is more information in the Toolbar section.

Spreadsheet functions added since documentation printed

Mathematical functions

BASE

Converts a number to a specified base.

Added in 4.57.

CEILING

Rounds a number to a given multiple towards +infinity (or away from zero, if both are negative).

Added in 4.53.

DECIMAL

Converts a number in a given base to its corresponding decimal value.

Added in 4.57.

FLOOR

Rounds a number to a given multiple towards -infinity (or towards zero, if both are negative).

Added in 4.53.

SERIESSUM

Returns the sum of the given power series for a given value.

Added in 4.56.

Statistical functions

COUNTA

Returns the number of all the values in a list regardless of their type.

Added in 4.54.

LISTCOUNT

Returns an array containing a sorted list of unique entries in a list and their associated count.

Added in 4.52/06.

Spreadsheet functions behaviour and interface changes since documentation printed

Financial functions

DDB

Starting with 4.56, this function will accept an extra parameter, factor (optional).

Starting with 4.57, this function may now use a non-integer period for calculation.

Lookup functions

INDEX

Starting with 4.56, this function will now accept zero for the column and/or row number.
If the column number is zero, the whole of the specified row(s) is returned.
If the row number is zero, the whole of the specified column(s) is returned.

Starting with 4.56, this function will now accept zero for the optional column and/or row size.
If the column size is zero, the rest of the specified row(s) beginning at the given column number is returned.
If the row size is zero, the whole of the specified column(s) beginning at the given row number is returned.