IEaxTableStyle.VirtualCellsStyle

Fore Syntax

VirtualCellsStyle: ITabCellStyle;

Fore.NET Syntax

VirtualCellsStyle: Prognoz.Platform.Interop.Tab.ITabCellStyle;

Description

The VirtualCellsStyle property determines style of the cells obtained as a result of splicing series with different calendar frequencies.

Comments

This style is applied for the cells, for which the ILanerTable.IsVirtualCell property returns True.

Fore Example

Executing the example requires a form with the Button1 button, the LanerBox component and the UiErAnalyzer component named UiErAnalyzer1 that is a data source for LanerBox. The workbook of time series database is to be loaded to the UiErAnalyzer1.

Add links to the Metabase and Drawing system assemblies.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    Eax: IEaxAnalyzer;
    Style: IEaxTableStyle;
    CellStyle: ITabCellStyle;
Begin
    Eax := UiErAnalyzer1.ErAnalyzer;
    Style := Eax.Grid.Style;
    CellStyle := Style.VirtualCellsStyle;
    CellStyle.BackgroundColor := GxColor.FromName("LightBlue");
    Eax.Grid.Refresh;
    (Eax As IMetabaseObject).Save;
End Sub Button1OnClick;

After clicking this button, workbook cells obtained as the result of splicing series having different calendar frequency, are highlighted in blue.

Fore.NET Example

The requirements and result of the Fore.NET Example execution match with those in the Fore Example. Use Fore.NET analogs instead of Fore components.

Imports Prognoz.Platform.Interop.Drawing;
Imports Prognoz.Platform.Interop.Express;
Imports Prognoz.Platform.Interop.Tab;

Private Sub button1_Click(sender: System.Object; e: System.EventArgs);
Var
    Eax: IEaxAnalyzer;
    Style: IEaxTableStyle;
    CellStyle: ITabCellStyle;
Begin
    Eax := uiErAnalyzerNet1.ErAnalyzer.ErAnalyzer;
    Style := Eax.Grid.Style;
    CellStyle := Style.VirtualCellsStyle;
    CellStyle.BackgroundColor := (New GxColorClassClass()).FromName("LightBlue");
    Eax.Grid.Refresh();
    (Eax As IMetabaseObject).Save();
End Sub;