or
Hi,
I'm exporting a RadGridview to excel, the only thing that I need is add a new line inside some cells,
the value inside the cell has \t \n but when I export the excel I get something like this <br> inside my excel file.
I'm using the following to change from \t \n to <br> but It doesn't work
if (e.Element == ExportElement.Cell )
{
e.Value = e.Value.ToString().Replace("\t \n", " <br> ");
}
what is the corret way to do it.
Thanks in advance

Hello,
I have a radGrid that populates with groups collapsed by default. The group header displays the group header title and aggregate count as expected. When a header is dragged to the GridGroupPanel, the new subgroup still has a header title, but the aggregate is lost for the new sub-group.
Here is a sample of my initial grouping:
Dim expression As GridGroupByExpression = New GridGroupByExpression Dim gridGroupByField As GridGroupByField = New GridGroupByField gridGroupByField = New GridGroupByField gridGroupByField.FieldName = "DGDesc" gridGroupByField.HeaderText = " " gridGroupByField.HeaderValueSeparator = " " gridGroupByField.FormatString = " <strong>{0}</strong> " expression.SelectFields.Add(gridGroupByField) expression.GroupByFields.Add(gridGroupByField) gridGroupByField = New GridGroupByField gridGroupByField.FieldName = "ProspectusLnNo" gridGroupByField.HeaderText = " " gridGroupByField.HeaderValueSeparator = " " gridGroupByField.FormatString = " (Records: {0})" gridGroupByField.Aggregate = GridAggregateFunction.Count expression.SelectFields.Add(gridGroupByField) radGridDocuments.MasterTableView.GroupByExpressions.Add(expression)I had to add the GroupByFields first before adding the SelectField with the aggregate function or it would not work. Anyway:
When I try to modify the GroupsChanging event, the best I get is a blank subgroup:
If e.Action = GridGroupsChangingAction.Group Then If e.Expression.GroupByFields(0).FieldName <> "ImgSRC" Then If Not IsGroupedByImgSRC(radGridDocuments.MasterTableView.GroupByExpressions) Then Dim customerGroupField As GridGroupByField = New GridGroupByField() customerGroupField.FieldName = "ImgSRC" customerGroupField.HeaderText = " " customerGroupField.HeaderValueSeparator = " " customerGroupField.FormatString = " (Records: {0})" customerGroupField.Aggregate = GridAggregateFunction.Count e.Expression.SelectFields.Add(customerGroupField) 'e.Expression.GroupByFields.Insert(1, customerGroupField) radGridDocuments.MasterTableView.GroupByExpressions.Add(e.Expression) End If End If End If
Thank you for any assistance.