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
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 Basic | Copy 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") |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also