ActiveReports Developer 7
RemoveVerticalSpace Property
See Also  Example
GrapeCity.ActiveReports.Export.Excel.v7 Assembly > GrapeCity.ActiveReports.Export.Excel.Section Namespace > XlsExport Class : RemoveVerticalSpace Property

Glossary Item Box

Sets or returns a value that indicates whether completely empty vertical spacing will be removed from the output.

Syntax

Visual Basic (Declaration) 
Public Property RemoveVerticalSpace As System.Boolean
C# 
public System.bool RemoveVerticalSpace {get; set;}

Property Value

Boolean. The default value is False.

Remarks

This may improve pagination if you wish to print the output from Excel.

Example

C#Copy Code
GrapeCity.ActiveReports.Export.Excel.Section.XlsExport docexp = new GrapeCity.ActiveReports.Export.Excel.Section.XlsExport();
docexp.AutoRowHeight = true;
docexp.DisplayGridLines = true;
docexp.FileFormat = GrapeCity.ActiveReports.Export.Excel.Section.FileFormat.Xls95; //or Xls97Plus or Xlsx
docexp.MinColumnWidth = 3;
docexp.MinRowHeight = 1;
docexp.MultiSheet = true;
docexp.RemoveVerticalSpace = true;
docexp.UseCellMerging = false;
docexp.Export(this.viewer1.Document, Application.StartupPath + "\\x.xls");
Visual BasicCopy Code
Dim docexp As New GrapeCity.ActiveReports.Export.Excel.Section.XlsExport()
docexp.AutoRowHeight=True
docexp.DisplayGridLines=True
docexp.FileFormat=GrapeCity.ActiveReports.Export.Excel.Section.FileFormat.Xls95 'Or Xls97Plus
docexp.MinColumnWidth=3
docexp.MinRowHeight=1
docexp.MultiSheet=True
docexp.RemoveVerticalSpace=True
docexp.UseCellMerging=False
docexp.Export(Me.viewer1.Document, Application.StartupPath + "\x.xls")

See Also