VP MOVE CELLS

Historique

Release	Modifications
19 R4	Ajout

VP MOVE CELLS ( originRange : Object ; targetRange : Object ; options : Object )

Paramètres	Type		Description
originRange	Object	->	Cell range to copy from
targetRange	Object	->	Target range for the values, formatting and formulas
options	Object	->	Options supplémentaires

Description

The VP MOVE CELLS command moves or copies the values, style and formulas from originRange to targetRange.

originRange and targetRange can refer to different View Pro areas.

In originRange, pass a range object containing the values, style, and formula cells to copy or move. If originRange is a combined range, only the first one is used.

In targetRange, pass the range of cells where the cell values, style, and formulas will be copied or moved.

The options parameter has several properties:

Propriété	Type	Description
copy	Boolean	Determines if the values, formatting and formulas of the cells in originRange are removed after the command executes: False (default) to remove them True to keep them
pasteOptions	Integer	Specifies what is pasted. Possible values: Value Description vk clipboard options all (default) Pastes all data objects, including values, formatting, and formulas. vk clipboard options formatting Pastes only the formatting. vk clipboard options formulas Pastes only the formulas. vk clipboard options formulas and formatting Pastes the formulas and formatting. vk clipboard options values Pastes only the values. vk clipboard options value and formatting Pastes the values and formatting.

The paste options defined in the workbook options are taken into account.

Exemple

Pour copier le contenu, les valeurs, le formatage et les formules d'une plage d'origine :

var $originRange; $targetRange; $options : Object

$originRange:=VP Cells("ViewProArea"; 0; 0; 2; 5)

$targetRange:=VP Cells("ViewProArea"; 4; 0; 2; 5)

$options:=New object
$options.copy:=True
$options.pasteOptions:=vk clipboard options all

VP MOVE CELLS($originRange; $targetRange; $options)

Voir également

VP Copy to object
VP PASTE FROM OBJECT
VP SET WORKBOOK OPTIONS