Hi,
I have tested the following configuration and the currency symbols are exported correctly on my end:
<
telerik:RadGrid
RenderMode
=
"Lightweight"
ShowGroupPanel
=
"true"
AutoGenerateColumns
=
"false"
ID
=
"RadGrid1"
DataSourceID
=
"SqlDataSource1"
AllowFilteringByColumn
=
"True"
AllowSorting
=
"True"
ShowFooter
=
"True"
runat
=
"server"
GridLines
=
"None"
AllowPaging
=
"true"
EnableLinqExpressions
=
"false"
>
<
PagerStyle
Mode
=
"NextPrevAndNumeric"
EnableAllOptionInPagerComboBox
=
"true"
></
PagerStyle
>
<
ExportSettings
HideStructureColumns
=
"true"
>
<
Excel
Format
=
"Biff"
/>
</
ExportSettings
>
<
MasterTableView
ShowGroupFooter
=
"true"
AllowMultiColumnSorting
=
"true"
CommandItemSettings-ShowExportToExcelButton
=
"true"
CommandItemSettings-ShowExportToPdfButton
=
"true"
CommandItemDisplay
=
"Top"
>
<
Columns
>
<
telerik:GridBoundColumn
Aggregate
=
"Count"
DataField
=
"ProductID"
HeaderText
=
"Product ID"
FooterText
=
"Total products: "
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"ProductName"
HeaderText
=
"Product name"
SortExpression
=
"ProductName"
UniqueName
=
"ProductName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
Aggregate
=
"Sum"
DataField
=
"UnitPrice"
HeaderText
=
"Unit price"
DataType
=
"System.String"
DataFormatString
=
"{0:C2}"
FooterText
=
"Total price: "
>
</
telerik:GridBoundColumn
>
<
telerik:GridTemplateColumn
DataField
=
"UnitsInStock"
HeaderText
=
"Units in stock"
FooterText
=
"All units in stock: "
UniqueName
=
"UnitsInStock"
Aggregate
=
"Sum"
GroupByExpression
=
"UnitsInStock Group By UnitsInStock"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblUnitsInStock"
runat
=
"server"
Text='<%#Eval("UnitsInStock") %>'>
</
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
telerik:RadNumericTextBox
RenderMode
=
"Lightweight"
ID
=
"txtUnitsInStock"
runat
=
"server"
text='<%#Bind("UnitsInStock") %>'>
</
telerik:RadNumericTextBox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridCalculatedColumn
HeaderText
=
"Total Price"
UniqueName
=
"TotalPrice"
DataType
=
"System.Double"
DataFields
=
"UnitPrice, UnitsInStock"
Expression
=
"{0}*{1}"
FooterText
=
"Total : "
Aggregate
=
"Sum"
>
</
telerik:GridCalculatedColumn
>
</
Columns
>
</
MasterTableView
>
<
ClientSettings
AllowDragToGroup
=
"true"
>
</
ClientSettings
>
</
telerik:RadGrid
>
<
asp:SqlDataSource
ID
=
"SqlDataSource1"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT * FROM Products Where UnitPrice > 9.50" runat="server"></
asp:SqlDataSource
>
Can you please elaborate if there are any differences in regards of the export configuration in your project?
Regards,
Konstantin Dikov
Telerik by Progress