ILanerTable.ReleaseCellValue

Fore Syntax

ReleaseCellValue(Row: Integer; Column: Integer);

Fore.NET 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.

Fore 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.

Fore.NET Example

Executing the example requires a .NET form containing:

A button with the Button1 identifier.
The LanerBoxNet component.
The UiErAnalyzerNet component with the uiErAnalyzerNet1 identifier that is a data source for LanerBoxNet. Workbook of the time series database must be loaded to uiErAnalyzerNet1.

Example is a handler of the Click event for the button.

Imports Prognoz.Platform.Interop.Drawing;
Imports Prognoz.Platform.Interop.Tab;
Imports Prognoz.Platform.Interop.Express;
Imports Prognoz.Platform.Interop.Laner;
…
Private Sub button1_Click(sender: System.Object; e: System.EventArgs);
Var
    Eax: IEaxAnalyzer;
    LanTable: ILanerTable;
    Sheet: ITabSheet;
    Range: ITabRange;
    lcol, trow, rcol, brow, i, j, hHeight, hWidth: Integer;
    HeaderSize: IGxSize;
Begin
    Eax := uiErAnalyzerNet1.ErAnalyzer.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;

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