Executing the example requires that the repository contains a workbook with the OBJ123 identifier for which the data display period and calendar order are changed.
Add links to the following system assemblies:
Express.
Metabase.
Sub UserProc;
Var
MB: IMetabase;
CrInfo: IMetabaseObjectCreateInfo;
MObj: IMetabaseObject;
Exp: IEaxAnalyzer;
WB: ILaner;
CalDim: ICalendarDimension;
Begin
MB := MetabaseClass.Active;
//Open a workbook to edit
MObj := MB.ItemById("OBJ123").Edit;
Exp := MObj As IEaxAnalyzer;
WB := Exp.Laner;
//Change calendar display period
WB.StartDate := DateTime.Parse("1990.02.01");
WB.EndDate := DateTime.Parse("2015.05.01");
//Set inverse order of calendar display
WB.ReverseOrder := True;
MObj.Save;
End Sub UserProc;
After executing the example a new period of data display is set, that is from February 1, 1990 to May 1, 2015. The inverse order of calendar display will be set.
See also: