CreateDerivedSeries: LnOptionState;
CreateDerivedSeries: Prognoz.Platform.Interop.Laner.LnOptionState;
The CreateDerivedSeries property determines whether to display child series for calculated series.
This setting overlaps individual series visibility settings.
Executing the example requires that the repository contains a workbook with the WORKBOOK_CALC 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_CALC").Edit;
EaxAn := WbkObj As IEaxAnalyzer;
// Get object for executing operations with workbook
Laner := EaxAn.Laner;
// Hide child series of calculated series
Laner.CreateDerivedSeries := LnOptionState.offOption;
// Save changes
WbkObj.Save;
End Sub UserProc;
After executing the example child series of calculated series are 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_CALC"].Edit();
EaxAn := WbkObj As IEaxAnalyzer;
// Get object for executing operations with workbook
Laner := EaxAn.Laner;
// Hide child series of calculated series
Laner.CreateDerivedSeries := LnOptionState.lnosOffOption;
// Save changes
WbkObj.Save();
End Sub;
See also: