Nikis predefined spreadsheet functions

If a function fails it returns the value #error.

• numerical functions

• abs (value) : value is a numerical value, result is the absolute value

• int (value) : value is a numerical value, result is the integer part of value

• round (value) : value is a numerical value, result is the rounded value with 2 decimal places

• round (value, places) : value is a numerical value, result is the rounded value with places decimal places

• numeric (string) : takes the first numerical value from string or #error

• cos(x), sin(x), atan2(x, y) : trigonometric functions, atan2(x, y) yields atan(x/y)

• string functions

• . (dot) operator : like $A4 . '$ max ' . $A5 . '$'

• lc (string) : the lower case of string

• uc (string) : the upper case of string

• ucfirst (string) : capitalize string

• substr ($A1, offset) : the substring of $A1 from offset the end

• substr ($A1, offset, length) : the next length characters of $A1 from offset

• date functions. If the functions are called with no argument () the current time is used.

• day(time) : time is a time value, result is the day of time

• month(time) : time is a time value, result is the month of time

• year(time) : time is a time value, result is the year of time

• minute(time) : time is a time value, result is the minute of time

• hour(time) : time is a time value, result is the hour of time

• localtime(time) : time is a time value, result is current date and time string

• time() : the current time (call alwas without argument)

• timeof (day, month, year, hour, minute) : the time value of the parameters. The parameters minute, hour, year and month my be omitted. The the values of the current time are used.

• decisions using value1 < value2 ? result1 : result2

If value1 is < value2 then use result1 otherwise result2

< may be

• numerical comparisons like <, >, >=, <=, ==, !=

• string comparisons like lt, gt, ge, lt, eq, ne and

• $A1 =~ m/a.*b/