The spreadsheet supports a number of math functions. These functions expose the
Python interface (see chapter 11). The available functions are
as follows:
- acos(x) - Return the arc cosine (measured in radians) of x.
- asin(x) - Return the arc sine (measured in radians) of x.
- atan(x) - Return the arc tangent (measured in radians) of x.
- atan2(y,x) - Return the arc tangent (measured in radians) of y/x. Unlike atan(y/x), the signs of both x and y are considered.
- ceil(x) - Return the ceiling of x as a float. This is the smallest integral value >= x.
- cos(x) - Return the cosine of x (measured in radians).
- cosh(x) - Return the hyperbolic cosine of x.
- degrees(x) - converts angle x from radians to degrees.
- e - The numeric constant ``e'' or 2.7182818284590451.
- exp(x) - Return e raised to the power of x.
- fabs(x) - Return the absolute value of the float x.
- floor(x) - Return the floor of x as a float. This is the largest integral value <= x.
- fmod (x,y) - Return fmod(x, y), according to platform C.
- hypot(x,y) - Return the Euclidean distance, sqrt(x*x + y*y).
- ldexp(x,y) - Returns x * (2**i)
- log(x[,base]) - the logarithm of x to the given base. If the base not specified, returns the natural logarithm (base e) of x.
- log10(x) - the base 10 logarithm of x.
- pi - The numeric constant PI or 3.1415926535897931.
- pow(x,y) - Return x**y (x to the power of y).
- radians(x) - converts angle x from degrees to radians.
- sin(x) - Return the sine of x (measured in radians).
- sinh(x) - Return the hyperbolic sine of x.
- sqrt(x) - Return the square root of x.
- tan(x) - Return the tangent of x (measured in radians).
- tanh(x) - Return the hyperbolic tangent of x.