ILanerTable.ReleaseCellValue

Syntax

ReleaseCellValue(Row: Integer; Column: Integer);

Parameters

Row. Row index.

Column. Column index.

Description

The ReleaseCellValue method copies the calculated value of a defined cell to the initial series

Comments

After executing this example the highlighting of the cells, which current (displayed) value differs from the one calculated by formula, is disabled.

Example

Executing this example requires a form containing:

A button with the Button1 identifier.
The LanerBox component.
The UiErAnalyzer component with the UiErAnalyzer1 identifier that is used as data source for LanerBox. Workbook of the time series database must be loaded to UiErAnalyzer1.

Add a link to the Drawing system assembly. Example is a handler of the OnClick event for the button.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    Eax: IEaxAnalyzer;
    LanTable: ILanerTable;
    Sheet: ITabSheet;
    Range: ITabRange;
    lcol, trow, rcol, brow, i, j, hHeight, hWidth: Integer;
    HeaderSize: IGxSize;
Begin
    Eax := UiErAnalyzer1.ErAnalyzer;
    Eax.BeginUpdate;
    LanTable := Eax.Laner.Execute;
    Sheet := Eax.Grid.TabSheet;
    Range := Sheet.View.Selection.Range;
    lcol := Range.Left;
    trow := Range.Top;
    rcol := Range.Right;
    brow := Range.Bottom;
    HeaderSize := Eax.Grid.HeaderSize;
    hHeight := HeaderSize.Height;
    hWidth := HeaderSize.Width;
    For i := trow To brow Do
        For j := lcol To rcol Do
            LanTable.ReleaseCellValue(i - hHeight, j - hWidth);
        End For;
    End For;
    Eax.EndUpdate;
End Sub Button1OnClick;

After executing this example the calculated values are copied to the initial series for the workbook cells.