Copy Cells#

Copy the value from one cell to another.

From: sheet

[Number/Text] ID (index number) or name of the sheet from which to copy the cell value.

Numbering starts from 1.

From: range

[Text] Range of cells whose values need to be copied.

Example: "A1:A1" or "A1:B2".

If the value is empty, the entire page will be copied.

To: sheet

[Number/Text] ID (index number) or name of the sheet to which the cell value needs to be copied.

Numbering starts from 1.

To: range

[Text] Range of cells where the copied data needs to be pasted.

Example: "A1:A1" or "A1:B2".

If the value is empty, the data will be pasted across the entire page.

Copy type

Type of data copying.

The property works only with the COM file opening mode.

Possible values:

  • All - Everything will be pasted;
  • Values - Values are pasted;
  • Formulas - Formulas are pasted.
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 from the "Start" block of this diagram will be used.

Message level

Select the message level that 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 from 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.