Hi ,
I have a grid and i'm exporting the records of which to an excel sheet with the following code....
I have a column which displays color in it's cell template and I need to export it's hexadecimal code to the excel sheet..
The code of the grid is as follows,
<
telerik:RadGridView
Name
=
"radGridViewTaskStatus"
telerik:StyleManager.Theme
=
"Office_Blue"
AutoGenerateColumns
=
"False"
IsReadOnly
=
"True"
RowHeight
=
"17"
ShowColumnFooters
=
"True"
FontSize
=
"11"
FontFamily
=
"Arial"
Margin
=
"41,0,39,10"
Grid.Row
=
"2"
VerticalAlignment
=
"Top"
AddingNewDataItem
=
"radGridViewTaskStatus_AddingNewDataItem"
ItemsSource
=
"{Binding}"
FieldFilterEditorCreated
=
"radGridViewTaskStatus_FieldFilterEditorCreated"
SelectionChanged
=
"radGridViewTaskStatus_SelectionChanged"
DataLoaded
=
"radGridViewTaskStatus_DataLoaded"
>
<
telerik:RadGridView.Columns
>
<
telerik:GridViewDataColumn
Header
=
"Status"
Width
=
"*"
IsReadOnly
=
"True"
DataMemberBinding
=
"{Binding Path=Status,Mode=TwoWay,Converter={StaticResource TrimConverter}}"
>
<
telerik:GridViewDataColumn.AggregateFunctions
>
<
telerik:CountFunction
Caption
=
"Count: "
/>
</
telerik:GridViewDataColumn.AggregateFunctions
>
</
telerik:GridViewDataColumn
>
<
telerik:GridViewDataColumn
Header
=
"Order"
DataMemberBinding
=
"{Binding Path=Order,Mode=TwoWay,Converter={StaticResource TrimConverter}}"
/>
<
telerik:GridViewCheckBoxColumn
Header
=
"Complete"
DataMemberBinding
=
"{Binding Path=Complete,Mode=TwoWay,Converter={StaticResource YesNoStringToBooleanConverter}}"
EditTriggers
=
"CellClick"
AutoSelectOnEdit
=
"True"
/>
<
telerik:GridViewDataColumn
Header
=
"Colour"
Width
=
"100"
>
<
telerik:GridViewColumn.CellTemplate
>
<
DataTemplate
>
<
StackPanel
Height
=
"17"
Background
=
"{Binding Path=Colour,Mode=TwoWay,Converter={StaticResource IntegerToColourConverter}}"
Width
=
"Auto"
>
</
StackPanel
>
</
DataTemplate
>
</
telerik:GridViewColumn.CellTemplate
>
<
telerik:GridViewColumn.CellEditTemplate
>
<
DataTemplate
>
<
StackPanel
Background
=
"{Binding Path=Colour,Mode=TwoWay,Converter={StaticResource IntegerToColourConverter}}"
Width
=
"Auto"
>
<
Button
Width
=
"Auto"
Height
=
"Auto"
Content
=
"..."
Margin
=
"2"
Name
=
"radBtnSetColor"
Click
=
"radBtnSetColor_Click"
HorizontalAlignment
=
"Right"
></
Button
>
</
StackPanel
>
</
DataTemplate
>
</
telerik:GridViewColumn.CellEditTemplate
>
</
telerik:GridViewDataColumn
>
</
telerik:RadGridView.Columns
>
</
telerik:RadGridView
>
But when I export to excel, the color is beign displayed as taskstatus1, taskstatus15 and so on..
Is there any way to format this into a hexadecimal or an integer color code... ?
Thanks in Advance,
Ramya