ITabOptions.CopyFormulasOnRowColumnInsertion

Syntax

CopyFormulasOnRowColumnInsertion: Boolean;

Description

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

Example

Sub UserProc;
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 UserProc;

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.