Sets or returns a value indicating whether cells should be merged together where applicable.

Syntax

Visual Basic (Declaration)
Public Property UseCellMerging As Boolean

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

C#
public bool UseCellMerging {get; set;}

Return Value

Boolean. The default value is False.

Example

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")`

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");

ActiveReports.XlsExport	Request technical support
UseCellMerging Property
See Also Example

Syntax

Return Value

Example

See Also

Reference