ILanerTable.ReleaseCellValue

Syntax

ReleaseCellValue(Row: Integer; Column: Integer);

Parameters

Row. Row index.

Column. Column index.

Description

The ReleaseCellValue method copies the calculated value of the specified cell to the original series

Comments

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

Example

Executing the example requires a form with the following components: the Button component named Button1, the LanerBox component named LanerBox1, and the UiErAnalyzer component named UiErAnalyzer1. UiErAnalyzer1 is a data source for LanerBox1. A workbook of the time series database should be loaded to UiErAnalyzer1.

The example is a handler of the OnClick event for the Button1 component.

Add links to the Drawing, Express, ExtCtrls, Forms, Laner, and Tab system assemblies.

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 the example the calculated values are copied to the original series for the workbook cells.

See also:

ILanerTable