The expression syntax for the functions Evaluate Expression As Double, Evaluate Expression As String and Evaluate Expression By Row follows standard Java syntax and includes these operators and functions:

 

Operators	Precedence
unary	+   -   !
multiplicative	*   /   %
additive	+   -
relational	<   >    <=   >=
equality	==   !=
logical	&&  ||

 

The following operators are not supported:

·         bitwise NOT, AND, OR, XOR

·         arithmetic shift

All operators may be applied to double variables. In addition the relational and equality operators may be applied to string variables, and the addition operator may be used to concatenate strings.

 

The following arithmetic functions are supported:

·         abs

·         acos

·         asin

·         atan

·         atan2

·         ceil

·         cos

·         exp

·         floor

·         IEEEremainder

·         log

·         max

·         min

·         pow

·         random

·         rint

·         round

·         sin

·         sqrt

·         tan

·         toDegrees

·         toRadians

The following string functions are supported:

·         charAt

·         compareTo

·         compareToIgnoreCase

·         concat

·         condExpr

·         endsWith

·         equals

·         equalsIgnoreCase

·         indexOf

·         lastIndexOf

·         length

·         replace

·         startsWith

·         substring

·         toLowerCase

·         toUpperCase

·         trim

---

 

Definitions of Math Functions (per Java.Math)

 

double abs(double a)

          Returns the absolute value of a double value.

 

double acos(double a)

          Returns the arc cosine of an angle, in the range of 0.0 through pi.

 

double asin(double a)

          Returns the arc sine of an angle, in the range of -pi/2 through pi/2.

 

double atan(double a)

          Returns the arc tangent of an angle, in the range of -pi/2 through pi/2.

 

double atan2(double y, double x)

          Converts rectangular coordinates (x, y) to polar (r, theta).

 

double ceil(double a)

          Returns the smallest (closest to negative infinity) double value that is greater than or equal to the argument and is equal to a mathematical integer.

 

double cos(double a)

          Returns the trigonometric cosine of an angle.

 

double exp(double a)

          Returns Euler's number e raised to the power of a double value.

 

double floor(double a)

          Returns the largest (closest to positive infinity) double value that is less than or equal to the argument and is equal to a mathematical integer.

 

double IEEEremainder(double f1, double f2)

          Computes the remainder operation on two arguments as prescribed by the IEEE 754 standard.

 

double log(double a)

          Returns the natural logarithm (base e) of a double value.

 

double max(double a, double b)

          Returns the greater of two double values.

 

double min(double a, double b)

          Returns the smaller of two double values.

 

double pow(double a, double b)

          Returns the value of the first argument raised to the power of the second argument.

 

double random()

          Returns a double value with a positive sign, greater than or equal to 0.0 and less than 1.0.

 

double rint(double a)

          Returns the double value that is closest in value to the argument and is equal to a mathematical integer.

 

long round(double a)

          Returns the closest long to the argument.

 

double sin(double a)

          Returns the trigonometric sine of an angle.

 

double sqrt(double a)

          Returns the correctly rounded positive square root of a double value.

 

double tan(double a)

          Returns the trigonometric tangent of an angle.

 

double toDegrees(double angrad)

          Converts an angle measured in radians to an approximately equivalent angle measured in degrees.

 

double toRadians(double angdeg)

          Converts an angle measured in degrees to an approximately equivalent angle measured in radians.

         

 

---

 

Definitions of String Functions (per Java.String)

 

char charAt(int index)

          Returns the char value at the specified index.

 

int compareTo(String anotherString)

          Compares two strings lexicographically.

 

int compareToIgnoreCase(String str)

          Compares two strings lexicographically, ignoring case differences.

 

String condExpr(String expression, String value1, String value2)

Evaluated as true or false, returns value1 if true or value2 if false.

 

boolean endsWith(String suffix)

          Tests if this string ends with the specified suffix.

 

boolean equals(Object anObject)

          Compares this string to the specified object.

 

boolean equalsIgnoreCase(String anotherString)

          Compares this String to another String, ignoring case considerations.

 

int indexOf(String str, int fromIndex)

          Returns the index within this string of the first occurrence of the specified substring, starting at the specified index.

 

int lastIndexOf(int ch, int fromIndex)

          Returns the index within this string of the last occurrence of the specified character, searching backward starting at the specified index.

         

int length()

          Returns the length of this string.

 

String replace(char oldChar, char newChar)

          Returns a new string resulting from replacing all occurrences of oldChar in this string with newChar.

         

boolean startsWith(String prefix, int toffset)

          Tests if this string starts with the specified prefix beginning a specified index.

         

String substring(int beginIndex, int endIndex)

          Returns a new string that is a substring of this string.

 

String toLowerCase()

          Converts all of the characters in this String to lower case using the rules of the default locale.

 

String toUpperCase()

          Converts all of the characters in this String to upper case using the rules of the default locale.

 

String trim()

          Returns a copy of the string, with leading and trailing white