En

Text Search#

Text search in an ODS document. To find the next cell with the specified text, the block can be reused.

ODS Document[Link] The ODS document that was obtained when creating or opening the file.
Sheet

[Number/Text] ID (serial number) or name of the sheet where the required cell is located.

Numbering starts from 1.

Text[Text] The string to be found.
Search Order

Specifies the search order.

Possible values:

  • ByColumns - searches by columns;
  • ByRows - searches by rows.
From Row

[Number] The row number from which the search begins.

Numbering starts from 1.

If the value is empty, the number will be equal to the minimum value.

From Column

[Number] The column number from which the search begins.

Numbering starts from 1.

If the value is empty, the number will be equal to the minimum value.

Entire CellIf enabled, the content of the cell must match the entire search text.
Row

[Number] If the text is found, the property returns the row number.

Numbering starts from 1.

Column

[Number] If the text is found, the property returns the column number.

Numbering starts from 1.

Cell Address[Text] The address of the cell.
Error Handling Level

Select the error handling level.

Possible values:

  • "Default" - default;
  • "Ignore" - errors are ignored;
  • "Handle" - errors are handled.

If "Default" is selected, the value of the "Start" block of this diagram will be used.

Exit Direction

Select the exit direction from the block in case of an error.

Possible values:

  • "Default" - default;
  • "Right" - to the right;
  • "Bottom" - down.

This property allows you to determine the exit direction in case of errors for blocks that do not contain the "If Error" connector (for example, the "Condition" block).

If "Default" is selected, the value of the "Start" block of this diagram will be used.

Message Level

Select the message level that the blocks will output during operation.

Possible values:

  • "Default" - default;
  • "Release" - output is disabled;
  • "Debug" - outputs main information;
  • "Detailed" - outputs detailed information.

If "Default" is selected, the value of the "Start" block of this diagram will be used.

Error Text[Text] Returns detailed information about the error in case of incorrect execution of the block's work.