ITabOptions.CopyFormulasOnRowColumnInsertion

Syntax

CopyFormulasOnRowColumnInsertion: Boolean;

Description

The CopyFormulasOnRowColumnInsertion property determines the status of the Copy formulas on pasting rows or columns option.

Example

Sub Main;

Var

MB: IMetabase;

MObj: IMetabaseObject;

Rep: IPrxReport;

Tab: ITabSheet;

Opt: ITabOptions;

Begin

MB:=MetabaseClass.Active;

MObj:=MB.ItemById("Reg_rep").Edit;

Rep:=MObj As IPrxReport;

Tab:=Rep.ActiveSheet.Table;

Opt:=Tab.Options;

Opt.CopyFormulasOnRowColumnInsertion:=True;

MObj.Save;

End Sub Main;

As a result the Copy Formulas on pasting rows or columns option of the active sheet of a regular report will be enabled. The identifier of the regular report is Reg_rep.