Difference between revisions of "Documentation/BASIC Guide/Operators"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Mathematical Operators: "rest"->"remainder")
(Mathematical Operators)
Line 16: Line 16:
 
{|
 
{|
 
|<tt>+</tt>||Addition of numbers and date values, linking of strings
 
|<tt>+</tt>||Addition of numbers and date values, linking of strings
 +
|-
 +
|<tt>&</tt>||Link strings
 
|-
 
|-
 
|<tt>-</tt>||Subtraction of numbers and date values
 
|<tt>-</tt>||Subtraction of numbers and date values
Line 29: Line 31:
 
|<tt>MOD</tt>||modulo operation (calculation of the remainder of a division)
 
|<tt>MOD</tt>||modulo operation (calculation of the remainder of a division)
 
|}
 
|}
 +
 +
Although you can use the + operator to link strings, the + operator can become confused when linking a number to a string. The & operator is safer when dealing with strings because it assumes that all arguments should be strings, and converts the arguments to strings if they are not strings.
  
 
== Logical Operators ==
 
== Logical Operators ==

Revision as of 02:04, 21 January 2009


Apache OpenOffice Basic understands common mathematical, logical, and comparison operators.

Mathematical Operators

Mathematical operators can be applied to all numbers types, whereas the + operator can also be used to link strings.

+ Addition of numbers and date values, linking of strings
& Link strings
- Subtraction of numbers and date values
* Multiplication of numbers
/ Division of numbers
\ Division of numbers with a whole number result (rounded)
^ Raising the power of numbers
MOD modulo operation (calculation of the remainder of a division)

Although you can use the + operator to link strings, the + operator can become confused when linking a number to a string. The & operator is safer when dealing with strings because it assumes that all arguments should be strings, and converts the arguments to strings if they are not strings.

Logical Operators

Logical operators allow you to link elements according to the rules of Boolean algebra. If the operators are applied to Boolean values, the link provides the result required directly. If used in conjunction with integer and long integer values, the linking is done at the bit level.

AND And linking
OR Or linking
XOR Exclusive or linking
NOT Negation
EQV Equivalent test (both parts True or False)
IMP Implication (if the first expression is true, then the second must also be true)

Comparison Operators

Comparison operators can be applied to all elementary variable types (numbers, date details, strings, and Boolean values).

= Equality of numbers, date values and strings
<> Inequality of numbers, date values and strings
> Greater than check for numbers, date values and strings
>= Greater than or equal to check for numbers, date values and strings
< Less than check for numbers, date values and strings
<= Less than or equal to check for numbers, date values and strings

Template:Documentation/Note


Content on this page is licensed under the Public Documentation License (PDL).
Personal tools