Disable column selector in datagrid

[Safan]

Hello,

Do we have an option to disable column selector/rearrange in data grid.

Any help would be highly appreciated. Thank in advance.

[Lance | Senior Manager Technical Support]

Hi Safan,

The DataGridColumn has a set of common properties you can set to disable certain features like sorting, filtering, etc. Take a look at the documentation for DataGrid Column Properties (e.g. CanUserSort="False").

You can also set this for all columns on the DataGrid object:

<telerikGrid:RadDataGrid
    UserEditMode="None"
    UserFilterMode="Disabled"
    UserGroupMode="Disabled"
    UserSortMode="None" ...>

You can also style parts of the column header to make the buttons transparent. Take a look at the Filter Indicator, Sort Indicator and other related sections in the DataGrid Column Styling documentation.

If you have any trouble or additional DataGrid questions, feel free to open a Support Ticket and share the code that you're using so we can assist directly.

Regards,
Lance | Technical Support Engineer, Principal
Progress Telerik

[Safan]

Hi Lance,

Thanks for your reply.

I am looking for disabling column selector.

Steps:

• Once the grid is loaded 
• Click on 3 dots (option) on the column
• Click on More

Here you can choose the columns to show on the grid. I am looking to disable this feature.

Thank you

~Mohamed Safan

[Lance | Senior Manager Technical Support]

Hello Safan,

Thank you for clarifying what you're looking for. At this time, there are no customization options modify that modify the Options button (in the filter UI popup) functionality.

We do have this request on our backlog. You can add your vote and follow it here - DataGrid: Provide an easy way to show/hide/remove the OptionsButton (Filtering UI)

In the meantime, you can follow this KB article that will show you how to hide the column's options button - How to hide the three dots in column header. For your convenience, here's the snippet:

<dataGrid:DataGridTextColumn.HeaderStyle>
    <dataGrid:DataGridColumnHeaderStyle OptionsButtonTextColor="Transparent" OptionsButtonFontSize="0" BorderColor="#D9D9D9" BorderThickness="1" />
    </dataGrid:DataGridTextColumn.HeaderStyle>
</dataGrid:DataGridTextColumn>

Regards,
Lance | Technical Support Engineer, Principal
Progress Telerik