Hidden: Boolean;
Hidden: boolean;
The Hidden property determines whether a series is hidden in the workbook.
Available values:
True. The series is hidden, but is contained in the workbook and its height is equal to 0.
False. The series is displayed in the workbook.
Executing the example requires that the repository contains a workbook with the WORKBOOK_HIDDEN identifier that contains several data series.
Add links to the Express, Laner and Metabase system assemblies.
Sub UserProc;
Var
mb: IMetabase;
WbkObj: IMetabaseObject;
EaxAn: IEaxAnalyzer;
Laner: ILaner;
Serie: ILanerSerie;
Begin
// Get workbook
mb := MetabaseClass.Active;
WbkObj := mb.ItemById("WORKBOOK_HIDDEN").Edit;
EaxAn := WbkObj As IEaxAnalyzer;
// Get object for executing operations with workbook
Laner := EaxAn.Laner;
// Get the first series in the workbook
Serie := Laner.Series.Item(0);
// Hide the first series
Serie.Hidden := True;
// Save changes
WbkObj.Save;
End Sub UserProc;
After executing the example the first series is hidden in the workbook.
The requirements and result of the Fore.NET example execution match with those in the Fore example.
Imports Prognoz.Platform.Interop.Express;
Imports Prognoz.Platform.Interop.Laner;
…
Public Shared Sub Main(Params: StartParams);
Var
mb: IMetabase;
WbkObj: IMetabaseObject;
EaxAn: IEaxAnalyzer;
Laner: ILaner;
Serie: ILanerSerie;
Begin
// Get workbook
mb := Params.Metabase;
WbkObj := mb.ItemById["WORKBOOK_HIDDEN"].Edit();
EaxAn := WbkObj As IEaxAnalyzer;
// Get object for executing operations with workbook
Laner := EaxAn.Laner;
// Get the first series in the workbook
Serie := Laner.Series.Item[0];
// Hide the first series
Serie.Hidden := True;
// Save changes
WbkObj.Save();
End Sub;
See also: