En

Text Search#

Text search.

Document P7[Link] Document P7, which was obtained when creating, opening a file, or connecting to the document.
Sheet

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

Numbering starts from 1.

Range

[Text] The upper left cell from which the search begins.

For example: "A1".

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

The order of the search is specified.

Possible values:

  • ByColumns - search is performed by columns;
  • ByRows - search is performed by rows.
Whole 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" - by 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" - by 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" - by default;
  • "Release" - output is disabled;
  • "Debug" - main information output;
  • "Detailed" - detailed information output.

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.