Problems toaccess to columnhesders and stacked columnheader

[Helmut]

Hello,

I'm working on a Windows WPF application.

I' m using 6 Syncfusion WPF SfDataGrid on a Window and have the following problems:

As the user can set 32 different languages (all European), I must be able to

change the texts (Translations) of the column headers in the DataGrids at runtime.

This actually works as planned, but I still have a few remaining problems that I have not been able to solve even after a few days of research:

1. I have not yet been able to set the top row of a stacked grid header.   

    Neither the height nor the colors. It looks as if the setting of the column header below, also affects the     setting of the top row in the header (height, color does not react at all)

2. In the hierarchical grid on the right, I can only set the height of the top row statically; a dynamic setting is         impossible,  because the grid does not fire the QueryRowHeight event. Is there a suggestion for a workaround?

3. In the detail view of the hierarchical grid, I can't set anything regarding the header.

   Example: column width, header background color, header text.

   Neither in XAML nor in the code. There are no errors, but no changes either.

   Attached are a few pictures to visualize my problems.

   I apologize, but this is the first time I've worked with the Syncfusion WPF SFDataGrid.

   I hope , I can get some advices from you.

   Regards

Helmut

Attachment: Sync_datagrid_5134c583.zip

[Sreemon Premkumar Muthukrishnan]

Hi Helmut,

Thank you for sharing the images and details of your implementation. We’ve reviewed the images and noted that you have successfully implemented localization for the column headers, and it appears to be working as expected.

Regarding Your First Query:

You inquired about changing the height, background, or foreground color of the stacked header. Based on the provided information, we are not entirely clear about the exact issue you are facing. However, from our understanding, you are facing the issue that any changes made to the column headers (such as height or color) is reflected to the stacked headers, or vice versa.

Here are some clarifications:

1. To style the Stacked Header, you need to write style by targeting the GridStackedHeaderCellControl.
2. To style the Column Header, you need to target the GridHeaderCellControl.

Please note that applying styles to the stacked header will not affect the column header, and vice versa. Below is the code snippet to adjust the height and color of the stacked header

Code Snippet: Setting the stacked header height:

var visualContainer = dataGrid.GetVisualContainer();

int count = dataGrid.StackedHeaderRows.Count;

for (int i = 0; i < count; i++)

{

    visualContainer.RowHeights[i] = 100;

}

visualContainer.InvalidateMeasure();

Code Snippet: Setting the stacked header background/foreground color:

<Style TargetType="syncfusion:GridStackedHeaderCellControl">

    <Setter Property="FontWeight" Value="ExtraBold"/>

    <Setter Property="FontSize" Value="14"/>

    <Setter Property="Background" Value="LightBlue"/>

    <Setter Property="Foreground" Value="Green"/>

</Style>

For more information, please refer to the user guide documentation on styling stacked headers and changing row height.

If we have misunderstood your requirement, could you please provide more detailed information to help us better understand your needs?

Regarding Your Second Query:

You mentioned that setting a static value for the height of top row works fine, but dynamic adjustment is not possible because the QueryRowHeight event is not triggered.

We have a few questions to better understand your query. Please note that if the hierarchical grid you are referring to is an SfDataGrid with DetailsViewDefinitions, the QueryRowHeight event is not supported. This limitation is documented in our user guide.

1. What do you mean by the "top row"? Could you please clarify it with image reference?
2. How are you setting the height statically, and could you clarify the approach you’re using?
3. How are you expecting to set the height dynamically? Should the height adjust automatically based on the cell content, or are you manually providing a specific height value at runtime?

Regarding Your Third Query:

For changing the column width, column header text, or column header background in the DetailsView grid, you can access and configure the DetailsViewDataGrid inside the SfDataGrid.DetailsViewLoading event. Below is a sample code snippet to demonstrate this:

Code Snippet: Adjusting column width, header text, and background color for the DetailsViewDataGrid:

<Style TargetType="syncfusion:GridHeaderCellControl" x:Key="DetailsViewHeaderStyle">

    <Setter Property="FontWeight" Value="Bold"/>

    <Setter Property="FontSize" Value="14"/>

    <Setter Property="Foreground" Value="White"/>

    <Setter Property="Background" Value="Green"/>

</Style>

private void DataGrid_DetailsViewLoading(object sender, Syncfusion.UI.Xaml.Grid.DetailsViewLoadingAndUnloadingEventArgs e)

{

    // Changed the column widths, header texts and header styles for the DetailsViewDataGrid.

    e.DetailsViewDataGrid.HeaderStyle = (Style)this.FindResource("DetailsViewHeaderStyle");

    foreach(var column in e.DetailsViewDataGrid.Columns)

    {

        switch (column.MappingName)

        {

            case "OrderID":

                column.HeaderText = "M.Order ID";

                break;

            case "SalesID":

                column.HeaderText = "M.Sales ID";

                break;

            case "ProductName":

                column.HeaderText = "M.Product Name";

                break;

            case "Quantity":

                column.HeaderText = "M.Quantity";

                break;

        }

        column.Width = 120;

    }

}

Final output:

We have created a sample based on your requirement, please find it in the attachment. 

We look forward to your response with additional details to help us provide precise assistance. Let us know if you have any further questions!

Regards,

Sreemon Premkumar M.

Attachment: WPF_SfDataGrid_Demo_711e7d62.zip