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

Glossary Item Box

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

Syntax

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

Property Value

Boolean.  The default value is False.

Remarks

Since Excel95 does not support cell merging this property is not applicable when Version is set to Excel 95.

Example

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

See Also