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 Boolean

Visual Basic (Usage)	Copy Code
`Dim instance As XlsExport Dim value As Boolean instance.RemoveVerticalSpace = value value = instance.RemoveVerticalSpace`

C#
public bool RemoveVerticalSpace {get; set;}

Return Value

Boolean. The default value is False.

Example

C# Copy Code

C#	Copy Code
`DataDynamics.ActiveReports.Export.Xls.XlsExport docexp = new DataDynamics.ActiveReports.Export.Xls.ExcelExport(); docexp.AutoRowHeight=true; docexp.DisplayGridLines=true; docexp.FileFormat=Xls95; //or Xls97Plus docexp.MinColumnWidth=360; docexp.MinRowHeight=250; docexp.MultiSheet=true; docexp.RemoveVerticalSpace=true; docexp.UseCellMerging=false; docexp.Export(this.viewer1.Document, Application.StartupPath + "\\x.xls");`

DataDynamics.ActiveReports.Export.Xls.XlsExport docexp = new DataDynamics.ActiveReports.Export.Xls.ExcelExport();

docexp.AutoRowHeight=true;

docexp.DisplayGridLines=true;

docexp.FileFormat=Xls95; //or Xls97Plus
docexp.MinColumnWidth=360;

docexp.MinRowHeight=250;

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 DataDynamics.ActiveReports.Export.Xls.ExcelExport() docexp.AutoRowHeight=True docexp.DisplayGridLines=True docexp.FileFormat=Xls95 'Or Xls97Plus docexp.MinColumnWidth=360 docexp.MinRowHeight=250 docexp.MultiSheet=True docexp.RemoveVerticalSpace=True docexp.UseCellMerging=False docexp.Export(Me.viewer1.Document, Application.StartupPath + "\\x.xls")`

Remarks

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

ActiveReports.XlsExport	Request technical support
RemoveVerticalSpace Property
See Also Example

Syntax

Return Value

Example

Remarks

See Also

Reference