Filtering Workbook Data

Executing the example requires that the repository contains a workbook with the OBJ123 identifier the series of which are filtered to hide empty values. Add links to the system assemblies:

Express.
Laner.
Metabase.

Example

Sub UserProc;
Var
    MB: IMetabase;
    CrInfo: IMetabaseObjectCreateInfo;
    MObj: IMetabaseObject;
    Exp: IEaxAnalyzer;
    WB: ILaner;
    Filter: ILanerFilter;
Begin
    MB := MetabaseClass.Active;
    //Open a workbook to edit
    MObj := MB.ItemById("OBJ123").Edit;
    Exp := MObj As IEaxAnalyzer;
    WB := Exp.Laner;
    Filter := WB.Filter;
    //Set filter used to hide empty values
    Filter.SuppressEmpty := True;
    //The cells are hidden both from the series ends and within the series data
    Filter.SuppressEmptyArea := LnSuppressEmptyArea.FullSerie;
    MObj.Save;
End Sub UserProc;

After executing the example the workbook series are filtered to hide empty values. Empty values in the series ends and within the series are hidden.