Questions on UI for WPF Forum

1 answer

4 views

Using Telerik Export the data grid value into excel.

Summarize the problem: In the WPF grid, data is displayed using value converters (IValueConverter). When exporting with TelerikDataGrid.Export(), Telerik uses the raw bound values instead of the converted display values. This causes a mismatch: what you see in the grid is different from what appears in the exported Excel file.

Tried Method:
Identified the root cause of the issue, the grid shows converted values (via IValueConverter).
But after export uses raw bound values, will exported. I need to export the Grid displayed value into the Excel.

M_DataGrid_ElementExporting

private void M_DataGrid_ElementExporting(object sender, Telerik.Windows.Controls.GridViewElementExportingEventArgs e)
{
if (e.Element == Telerik.Windows.Controls.ExportElement.Cell)
{
var cellExportingArgs = e as GridViewCellExportingEventArgs;

if (e.Context is Telerik.Windows.Controls.GridViewDataColumn dataColumn)
{
var col = e.Context as Telerik.Windows.Controls.GridViewDataColumn;
if (col != null && col.UniqueName == "MomentOfInertia")
{

var binding = dataColumn.DataMemberBinding;
var propertyValue = TelerikDataVis_Doc.GetPropertyValue(e.DataContext, binding.Path.Path);
if (binding != null)
{
object rawValue = e.Value;

if (binding.Converter != null)
{
rawValue = binding.Converter.Convert(
propertyValue,
typeof(string),
binding.ConverterParameter,
System.Globalization.CultureInfo.CurrentCulture);
}

if (!string.IsNullOrEmpty(binding.StringFormat))
{
e.Value = string.Format(binding.StringFormat, rawValue);
}
else
{
e.Value = rawValue?.ToString();
}
}
}
}
}
}

GridView

answered on 02 Sep 2025

0 answers

11 views

Filtering bug

There appears to be a bug in the column filter popup. Whenever I change one filter operator, the second filter operator changes to the same value. So I can't do something like GreaterThan X and LessThan Y.

See a video here: https://share.cleanshot.com/6Bn9FwlJ

GridView

asked on 20 Aug 2025

1 answer

16 views

Bug: NullReferenceException raised by IGridViewEditor.SetText in DateTimePickerGridViewEditor when typing a key into a GridViewDataColumn that contains a collapsed RadDateTimePicker

Is this the best place to report bugs?

This is with 2024.4.1213.462.

To duplicate the issue:

With VS 2022, create a WPF (.NET Framework) application,
Delete MainWindow.xaml and MainWindow.xaml.cs
Unzip the attached file, place MainWindow.xaml and MainWindow.xaml.cs from the zip where the old files were or use the pasted text below
Build and run the application
Put focus on a cell in a row in the grid and type a letter

Expect the following exception to be raised

	Name	Value	Type
◢	$exception	{"Object reference not set to an instance of an object."}	System.NullReferenceException

at Telerik.Windows.Controls.DateTimePickerGridViewEditor.Telerik.Windows.Controls.GridView.IGridViewEditor.SetText(String text) in Telerik.Windows.Controls\DateTimePickerGridViewEditor.cs:line 56

In case the zip doesn't work:

MainWindow.xaml.cs:

namespace WpfApp14
{
    using System;
    using System.ComponentModel;
    using System.Windows;
    using System.Collections.ObjectModel;

    public sealed class GridValueViewModel : INotifyPropertyChanged
    {
        private string someValue = string.Empty;

        public GridValueViewModel(string someValue)
        {
            this.SomeValue = someValue;
        }

        public event PropertyChangedEventHandler PropertyChanged;

        public string SomeValue
        {
            get
            {
                return this.someValue;
            }

            set
            {
                value = value ?? string.Empty;
                if (this.SomeValue != value)
                {
                    this.someValue = value;
                    this.PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(nameof(this.SomeValue)));
                }
            }
        }

        public DateTime? DateValue
        {
            get
            {
                if (DateTime.TryParse(this.SomeValue, out var value))
                {
                    return value;
                }

                return null;
            }

            set
            {
                if (value == null)
                {
                    this.SomeValue = string.Empty;
                    return;
                }

                this.SomeValue = value.ToString();
            }
        }

        public ObservableCollection<string> SomeValueItems { get; } = new ObservableCollection<string>(
            new[]
            {
                "cat",
                "dog",
                "bird"
            });
        
    }

    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            this.InitializeComponent();
            this.DataContext = this;
        }

        public ObservableCollection<GridValueViewModel> Values { get; } = new ObservableCollection<GridValueViewModel>(
            new[]
            {
                new GridValueViewModel("cat"),
                new GridValueViewModel("dog"),
                new GridValueViewModel("bird")
            });
    }
}

MainWindow.xaml:

<Window x:Class="WpfApp14.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
        xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
        xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation"
        mc:Ignorable="d"
        Title="MainWindow" Height="450" Width="800">
    <telerik:RadGridView
        AutoGenerateColumns="False"
        ItemsSource="{Binding Values, Mode=OneWay}">
        <telerik:RadGridView.Columns>
            <telerik:GridViewDataColumn
                Header="Column 1">
                <telerik:GridViewDataColumn.CellTemplate>
                    <DataTemplate>
                        <Label
                            Content="{Binding SomeValue}" />
                    </DataTemplate>
                </telerik:GridViewDataColumn.CellTemplate>
                <telerik:GridViewDataColumn.CellEditTemplate>
                    <DataTemplate>
                        <Grid>
                            <Grid.ColumnDefinitions>
                                <ColumnDefinition
                                    Width="*" />
                            </Grid.ColumnDefinitions>
                            <TextBox
                                Grid.Column="0"
                                Text="{Binding SomeValue, UpdateSourceTrigger=PropertyChanged, ValidatesOnDataErrors=True}"
                                Visibility="Collapsed" />
                            <telerik:RadComboBox
                                Grid.Column="0"
                                HorizontalAlignment="Stretch"
                                IsEditable="False"
                                ItemsSource="{Binding SomeValueItems}"
                                SelectedItem="{Binding SomeValue}" />
                            <telerik:RadDateTimePicker
                                Grid.Column="0"
                                HorizontalAlignment="Stretch"
                                InputMode="DatePicker"
                                DateTimeWatermarkContent="{x:Null}"
                                SelectedValue="{Binding DateValue, UpdateSourceTrigger=PropertyChanged, ValidatesOnDataErrors=True}"
                                Visibility="Collapsed" />
                        </Grid>
                    </DataTemplate>
                </telerik:GridViewDataColumn.CellEditTemplate>
            </telerik:GridViewDataColumn>
        </telerik:RadGridView.Columns>
    </telerik:RadGridView>
</Window>

DateTimePicker

GridView

answered on 07 Aug 2025

1 answer

26 views

How to set custome date display format in WPF

I using the <telerik:RadDatePicker>

DisplayFormat = (Long or short) only there I need a customer format how we archive.

Example : 1 July 2025, 1 JUL 2025

DatePicker

DateTimePicker

GridView

answered on 14 Jul 2025

0 answers

23 views

Removing Outside Grid Border

I've been trying to remove the thin white border line with no luck, Any help?

                            <telerik:RadGridView
                                Margin="0,5,0,0" AutoGenerateColumns="False" BorderThickness="0" BorderBrush="{StaticResource LaGrey12}"
                                ColumnBackground="{StaticResource LaGrey12}"
                                GridLinesVisibility="None" IsReadOnly="True"
                                ItemsSource="{Binding ContactActivityNote.ContactActivityParticipants}"
                                ShowColumnHeaders="False">
                                <telerik:RadGridView.Columns>
                                    <telerik:GridViewDataColumn
                                        Width="Auto"
                                        DataMemberBinding="{Binding ParticipationTypeId}"
                                        Header="Type" />
                                    <telerik:GridViewDataColumn
                                        Width="*"
                                        DataMemberBinding="{Binding AddressedTo}"
                                        Header="Addressed To" />
                                </telerik:RadGridView.Columns>
                            </telerik:RadGridView>

GridView

asked on 07 Jul 2025

0 answers

20 views

RadGridView - Constrain Autosizing of Columns and Rows

I have a RadGridview displaying data from a datatable using autogenerated columns. I have EnableColumnVirtualization="True" and EnableRowVirtualization="True". When I scroll through the grid, columns and rows are autosizing to display data and everything looks good for the most part.

However, I have some columns that can be excessively wide, easily twice the width of the screen. The same for rows, I occasionally have a cell where the row is excessively high.

How can I set a max width for column and row to prevent excessively wide columns or tall rows? I tried setting MaxHeight and MaxWidth, but that also constrains the user to those settings if they do intentionally want to increase those values.

GridView

asked on 30 Jun 2025

1 answer

30 views

RadGridView - Grid with 2 or more Footers

I currently have a function grid similar to:

<telerik:RadGridView Grid.Row="2" Grid.ColumnSpan="2" x:Name="MyGridView"
                     ItemsSource="{Binding MyItems}"
                     RowIndicatorVisibility="Collapsed"
                     ShowColumnFooters="True"
                     ShowGroupPanel="False"
                     IsReadOnly="True"
                     HorizontalContentAlignment="Stretch"
                     VerticalAlignment="Top">
    <telerik:RadGridView.Columns>
        <telerik:GridViewDataColumn DataMemberBinding="{Binding MonthDisplay}" Header="Month" Width="65">
            <telerik:GridViewDataColumn.Footer>
                <TextBlock Text="Totals:"/>
            </telerik:GridViewDataColumn.Footer>
        </telerik:GridViewDataColumn>
        <telerik:GridViewDataColumn DataMemberBinding="{Binding Column1Data}" Header="Column 1" Width="*" MinWidth="40" MaxWidth="95" DataFormatString="#,###0.##" TextAlignment="Right" FooterTextAlignment="Right">
            <telerik:GridViewDataColumn.AggregateFunctions>
                <telerik:SumFunction/>
            </telerik:GridViewDataColumn.AggregateFunctions>
        </telerik:GridViewDataColumn>
        <telerik:GridViewDataColumn DataMemberBinding="{Binding Column2Data}" Header="Column 2" Width="*" MinWidth="40" MaxWidth="95" DataFormatString="#,###0.##" TextAlignment="Right" FooterTextAlignment="Right">
            <telerik:GridViewDataColumn.AggregateFunctions>
                <telerik:SumFunction/>
            </telerik:GridViewDataColumn.AggregateFunctions>
        </telerik:GridViewDataColumn>
        <telerik:GridViewDataColumn DataMemberBinding="{Binding Column3Data}" Header="Column 3" Width="*" MinWidth="40" MaxWidth="95" DataFormatString="#,###0.##" TextAlignment="Right" FooterTextAlignment="Right">
            <telerik:GridViewDataColumn.AggregateFunctions>
                <telerik:SumFunction/>
            </telerik:GridViewDataColumn.AggregateFunctions>
        </telerik:GridViewDataColumn>
        <telerik:GridViewDataColumn DataMemberBinding="{Binding Column4Data}" Header="Column 4" Width="*" MinWidth="40" MaxWidth="95" DataFormatString="#,###0.##" TextAlignment="Right" FooterTextAlignment="Right">
            <telerik:GridViewDataColumn.AggregateFunctions>
                <telerik:SumFunction/>
            </telerik:GridViewDataColumn.AggregateFunctions>
        </telerik:GridViewDataColumn>
    </telerik:RadGridView.Columns>
</telerik:RadGridView>

So the grid would show results like:

Month	Column1	Column2	Column3	Column4
Jan	1	2	3	4
Feb	1	2	3	4
March	1	2	3	4
Totals:	3	6	9	12

What I now want to do is add another footer row so that the grid would look like:

Month	Column1	Column2	Column3	Column4
Jan	1	2	3	4
Feb	1	2	3	4
March	1	2	3	4
Totals:	3	6	9	12
Average:1	2	3	4

Is it possible to add a 2nd footer row and if so how can I accomplish that?

GridView

answered on 26 May 2025

0 answers

19 views

Filter and Select on RadGridview

Hi,

I have rad grid view with Grouping along with Select checkbox (GridviewCheckboxcolum). I need below help

I need to know how we can achieve Select all functionality on Grid as well ex: If i select check box column in header it has to select all the rad Gridview groups as well
I also need to know how can achieve group filtering as well
How we can achieve sorting with Group Names?

Thanks in advance

GridView

asked on 22 May 2025

2 answers

69 views

RadGridView: Change color of Row selector

Hello everybody,

in my WPF Application I am using Telerik's RadGridView. Everything is working fine so far.

But there is a little design issue, I am facing with.

In my App I am using Windows11Theme, if I use this, every row in my GridView is starting with a blue column. Sadly I am not able to find out, how to change this color.

Previously, I was using Windows8Theme and there I used "StrongColor" property to change this color. But I am not able to find out, how to change it in Windows11Theme.

Attached is an image, which shows the row, I want to change.