Functions in the Formula Editor

Mathematical operations:

+	Addition
-	Subtraction
*	Multiplication
/	Division
^	Involution
sqrt()	Rootsquaring

 

Logical comparison and selection:

==	equally
>	more
<	less
!	not
|	or
!=	not equal
>=	not less
<=	no more
||	or
&&	and

Functions:

math:

Cos, Sin, Tg - trigonometric functions, the argument given in degrees.

Acos, Asin, Atg - inverse trigonometric functions, the result is given in degrees.

Abs - absolute value of (module).

Int - rounding to whole number.

Summ - returns the sum of the values of the variables in a grouped cells.

Note:

When you type a function should pay attention to the opening and closing brackets.

For example:

Summ(Row) - returns the sum of the numbers of grouped rows..

Summ(Standartnaya_detal.L) - returns the sum of the values ??of the L parameter object "standard part" in the grouped rows.

data conversion:

Str - Data conversion to a string type.

Num - conversion of data into a numeric type.

Frm - convert a numeric value to a string formatted according to the settings of a table column.

For example:

Frm(0.001230) returns a string 0,0012, if the column containing the cell is set to zero suppression and accuracy of 0,0000

selection and comparison:

FmtText - Addition formatted strings.

FmtSub - the creation of a subscript.

FmtSuper - create superscript.

FmtDigit - transfer number in hard copy.

FmtRaw - text without formatting.

DmtDiv - creation of fractions.

If/Iff - The logical choice. Recording Format:

if (Logich_Uslovie; Esli_Istina; Esli_Lozh)

where:

Logich_Uslovie - logical condition using logical comparisons (see above);

Esli_istina - the return value when the logical condition;

Esli_Lozh - return value at default logical condition.

For example:

if(object == Marker_universalny; Marker_universalny.position; "Undefined") . If an object type, which is connected with the cell column has Marker_universalny value, the function returns the position value of the referenced object. Another type of object it returns a string Undefined .

Exist - Checks whether there is a constant: =IF(EXIST(Object.Name);Object.Name;0)

Min/Max - returns the minimum / maximum value listed in parentheses

For example:

Min(maskimalnoe_znachenie; MinValue ) - nourishes MinValue;

Max(maskimalnoe_znachenie; MinValue) - returns maskimalnoe_znachenie.

Count - returns the number of objects (for grouped rows in the table).

For example:

Count() - returns the number of objects associated with cells grouped rows.

Avg - Calculates the arithmetic mean of the arguments. Takes an arbitrary number of arguments understand ranges. Empty arguments are ignored.

Off - returns the value of the cell, given the relative index. The index is written in the format:

Off(string; column)

For example:

Off(-1;2) - returns the value of cell in the table on one line above (-1) and two columns to the right (2) of the current

Cell - the cell returns the value specified absolute index.

Merge (Cells,Expression) - brings together a range of Cells, if Expression is not equal to 0. Returns the value of Expression.

For example:

=merge(A5:C5; "Title") – integrates cell A5 to C5, in the summary displays the text "Title".

SetHeight() – reference line height. In brackets the height value.

Val() - computes the value of the argument.

For example:

=val("A"+"1") - calculates the "A1", and then uses it as another expression (obtained by the value in cell A1). If the argument - not a string, then he comes back, ie =val(10+2) - the same thing =10+2.

=val("summ(A"+Str(off(0;-1))+":D"+Str(off(0;-1))+")") - the amount of cells from rows A to D, the number which is introduced into the cell to the left of the current one. In most cases you can do without val. The classic example, when without it - no way: in a custom form, enter the cell address, then to take the value out of it. Create a variable Addr, associate it with an input field on a form and in the table do so: = val (Addr) function allows recursion: = val (val ("A" + "1")) - to take the value of the cell whose address is recorded in cell A1. Nesting depth is limited to 64.

Geometry(Object) - works as Implement object. Height embedded object shrinks to the line height. Object is taken from the report, or attached to the cell.

SUMM(Section(-1)) - Sum of cells in the current column of the section next to the current.

COUNT(Section(A3)) - The number of rows in the section containing the cell A3.

Reserved variables:

Pi - pi.

Row - for each cell in the column it returns the number of rows (rows are numbered starting with 1, excluding the header lines).

Col - for all cells in a column returns the column number of the table (column "A" is number 1).

Object - returns the type of the object, which is associated with the cell line.

Object1, Object2, … - objects attached to the cell.

Title - the name of the table.

RowCount - total number of rows.

ColCount - the total number of columns.