Hi,

I have create a webgrid with ColumnSet as attached, but after using copy row funciton in context menu and paste into Excel, the row setting is difference.

Please explain if it is a bugs that I suppore it should be the same format after pasting into Excel. Or is there any other way to export to Excel with the same formatting?

Also, the following would be the snytax for the webgrid as a reference

<ISWebGrid:WebGrid ID="WebGrid1" runat="server" Height="450px" UseDefaultStyle="True"
Width="100%" DefaultStyleMode="Win7"
>
<LayoutSettings
AlwaysShowHelpButton="false"
AllowSorting="Yes"
>
<ClientSideEvents OnRowContextMenu="WebGrid1_OnRowContextMenu" />
</LayoutSettings>
<RootTable RowLayout="ColumnSet">
<ColumnSets>
<ISWebGrid:WebGridColumnSet Caption="Staff Information" ColumnCount="4"
Name="ColumnSet0" Width="436px">
<Layout>
<ISWebGrid:WebGridRowLayout ColumnMember="Effective Date" RowSpan="2"
Width="112" />
<ISWebGrid:WebGridRowLayout Col="1" ColumnMember="Employee ID" RowSpan="2"
Width="112" />
<ISWebGrid:WebGridRowLayout Col="2" ColumnMember="Name" RowSpan="2"
Width="112" />
<ISWebGrid:WebGridRowLayout Col="3" ColumnMember="Reason" RowSpan="2" />
<ISWebGrid:WebGridRowLayout Row="1" Spanned="Row" Width="112" Height="21" />
<ISWebGrid:WebGridRowLayout Col="1" Row="1" Spanned="Row" Width="112"
Height="21" />
<ISWebGrid:WebGridRowLayout Col="2" Row="1" Spanned="Row" Width="112"
Height="21" />
<ISWebGrid:WebGridRowLayout Col="3" Row="1" Spanned="Row" Height="21" />
</Layout>
<HeaderStyle HorizontalAlign="Center" />
</ISWebGrid:WebGridColumnSet>
<ISWebGrid:WebGridColumnSet Caption="Promotion Information" ColumnCount="2"
Name="ColumnSet1" Width="200px">
<Layout>
<ISWebGrid:WebGridRowLayout ColumnMember="em_posi" />
<ISWebGrid:WebGridRowLayout Col="1" ColumnMember="em_grad" />
<ISWebGrid:WebGridRowLayout ColumnMember="Promote Position" Height="21"
Row="1" />
<ISWebGrid:WebGridRowLayout Col="1" ColumnMember="Promote Grading" Height="21"
Row="1" />
</Layout>
<HeaderStyle HorizontalAlign="Center" />
</ISWebGrid:WebGridColumnSet>
<ISWebGrid:WebGridColumnSet Caption="Misc" ColumnCount="1" Name="ColumnSet2"
Width="300px">
<Layout>
<ISWebGrid:WebGridRowLayout ColumnMember="errText"
RowSpan="2" Width="300" />
<ISWebGrid:WebGridRowLayout
Width="300" Height="21" Row="1" Spanned="Row" />
</Layout>
</ISWebGrid:WebGridColumnSet>
</ColumnSets>
<ColumnSetSettings GridLineColor="DarkGray" GridLines="Both" RowCount="2" ShowHeaders="Yes" />
<Columns>
<ISWebGrid:WebGridColumn Caption="Effective Date"
DataMember="Effective Date" DataFormatString="yyyy-MM-dd"
DataType="System.DateTime" Name="Effective Date" Width="100px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Employee ID" Name="Employee ID" DataMember="Employee ID" Width="100px" />
<ISWebGrid:WebGridColumn Caption="Name" DataMember="Employee ID" Name="Name" Width="100px"
EditType="WebComboNET" WebComboID="wcEmpl" >
<ValueList DataSourceID="objEmpl" DataTextField="em_name" DataValueField="em_no" />
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Reason" DataMember="Reason" Name="Reason" Width="200px" />
<ISWebGrid:WebGridColumn Caption="Curr Company" DataMember="compcode" Name="compcode" Width="100px" />
<ISWebGrid:WebGridColumn Caption="Curr Division" DataMember="em_cat3" Name="em_cat3" Width="100px" />
<ISWebGrid:WebGridColumn Caption="Curr Deaprtment" DataMember="em_dept" Name="em_dept" Width="100px"
EditType="WebComboNET" WebComboID="wcDept" >
<ValueList DataSourceID="ObjDept" DataTextField="de_desc" DataValueField="de_code" />
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Curr District" DataMember="em_cat1" Name="em_cat1" Width="100px" />
<ISWebGrid:WebGridColumn Caption="Curr Branch_Section" DataMember="em_cat2" Name="em_cat2" Width="100px" />
<ISWebGrid:WebGridColumn Caption="Curr Position" DataMember="em_posi" Name="em_posi" Width="100px"
EditType="WebComboNET" WebComboID="wcPosi" >
<ValueList DataSourceID="ObjPosi" DataTextField="po_desc" DataValueField="po_code" />
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Curr Posi Category" DataMember="em_cat4" Name="em_cat4" Width="100px" />
<ISWebGrid:WebGridColumn Caption="Curr Grading" DataMember="em_grad" Name="em_grad" Width="100px" />
<ISWebGrid:WebGridColumn Caption="Curr Leave Plan" DataMember="em_lplan" Name="em_lplan" Width="100px" />
<ISWebGrid:WebGridColumn Caption="Curr Supervisor" DataMember="em_super" Name="em_super" Width="100px" />
<ISWebGrid:WebGridColumn Caption="Curr Cost Center" DataMember="costcenter" Name="costcenter" Width="100px" />

<ISWebGrid:WebGridColumn Caption="Promote Company" DataMember="Promote Company"
Name="Promote Company" Width="100px" >
<CellStyle BackColor="Yellow">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Promote Division"
DataMember="Promote Division" Name="Promote Division" Width="100px" >
<CellStyle BackColor="Yellow">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Promote Deaprtment" DataMember="Promote Deaprtment" Name="Promote Deaprtment" Width="100px"
EditType="WebComboNET" WebComboID="wcDept" >
<CellStyle BackColor="Yellow">
</CellStyle>
<ValueList DataSourceID="ObjDept" DataTextField="de_desc" DataValueField="de_code" />
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Promote District"
DataMember="Promote District" Name="Promote District" Width="100px" >
<CellStyle BackColor="Yellow">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Promote Branch_Section" DataMember="Promote Branch_Section" Name="Promote Branch_Section" Width="100px"
EditType="WebComboNET" WebComboID="wcCat2" >
<CellStyle BackColor="Yellow">
</CellStyle>
<ValueList DataSourceID="ObjCat2" DataTextField="site_desc" DataValueField="site_code" />
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Promote Position" DataMember="Promote Position" Name="Promote Position" Width="100px"
EditType="WebComboNET" WebComboID="wcPosi" >
<CellStyle BackColor="Yellow">
</CellStyle>
<ValueList DataSourceID="ObjPosi" DataTextField="po_desc" DataValueField="po_code" />
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Promote Posi Category"
DataMember="Promote Posi Category" Name="Promote Posi Category" Width="100px" >
<CellStyle BackColor="Yellow">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Promote Grading" DataMember="Promote Grading"
Name="Promote Grading" Width="100px" >
<CellStyle BackColor="Yellow">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="New Leave Plan" DataMember="New Leave Plan"
Name="New Leave Plan" Width="100px" >
<CellStyle BackColor="Yellow">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="New Supervisor" DataMember="New Supervisor"
Name="New Supervisor" Width="100px" >
<CellStyle BackColor="Yellow">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="New Cost Center" DataMember="New Cost Center"
Name="New Cost Center" Width="100px" >

<CellStyle BackColor="Yellow">
</CellStyle>
</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="Is Using Fix Commission" DataMember="Is Using Fix Commission" Name="Is Using Fix Commission" Width="100px" />
<ISWebGrid:WebGridColumn Caption="Import Error" DataMember="errText" Name="errText" Width="600px" />
</Columns>
</RootTable>
</ISWebGrid:WebGrid>

Thank a lot!