
Excel - Export - ChangingColumnsExported
----------------------------------------

https://docs.telerik.com/aspnet-mvc/html-helpers/data-management/grid/export/excel-export

https://www.telerik.com/forums/hide-column-when-exporting-to-excel-in-mvc-razor-grid


Sticky Columns
--------------
https://docs.telerik.com/aspnet-mvc/html-helpers/data-management/grid/columns/sticky

Known Limitations
The sticky columns are not supported in Microsoft Internet Explorer. It is a browser limitation due to unsupported gutters.
Sticky columns cannot work together with column virtualization.
A column cannot be both sticky and locked. If it is defined like this, it will be locked and the sticky property will be ignored.
Grid scrolling must be enabled.
The header of the first column in a grouped Grid cannot be sticky.
The autogenerated expand/collapse columns used by hierarchy and grouping cannot be sticky.
The row template and detail template are not supported together with sticky columns.
If multi-column headers are used, only a column at the topmost level can be sticky. When the Grid uses Multi-column headers - the "Set Column Position" menu will not be visible.
If the width of the Grid changes through JavaScript or resizing the page after the Grid is created, you have to call the resize method to recalculate the sticky styles.

https://www.telerik.com/kendo-angular-ui/components/grid/accessories/column-menu/#:~:text=By%20default%2C%20the%20column%20menu%20appears%20for%20all%20columns.,and%20set%20it%20to%20false%20.

https://www.telerik.com/kendo-angular-ui/components/grid/api/ColumnMenuSettings/




Telerik
=======

Download see: https://docs.telerik.com/aspnet-mvc/installation/overview-download
  Download and install the automated installeryou can find it in the downloads section of your Telerik account.

After I downloaded and installed Telerik (version), I copied the following file:
    Telerik.UI.for.AspNet.Mvc5.2022.3.1109.nupkg
to
	C:\Andys\NugetPackages

The instructions tolld me to open NuGet manager for Solution and create a 'Package Source' called TelerikUI  at location: C:\Andys\NugetPackages

Then, when I create a project in VS, I can add telerik simpley by selecting the TelerikUI 'Package Source', and when I Browse, 
'Telerik.UI.for.Aspnet.MVC' appears.



Grid - Column Sizes
===================
To remove the misalignment of the columns and headers when the Grid is resized, 
provide at least one column without a specified width so that it can freely adjust.
  https://docs.telerik.com/aspnet-mvc/html-helpers/data-management/grid/columns/widths
I proved this:
        columns.Bound(p => p.GroupCode).Stickable(true).Title("Teaching Group Code").Width("30%").Filterable(ftb => ftb.Multi(true).Search(true)); ;
        columns.Bound(p => p.GroupTitle).Stickable(true).Title("Teaching Group Title").Filterable(true);

--------------------------------------------------------------------------

When all columns have pixel widths and their sum exceeds the width of the Grid, a horizontal scrollbar appears.
I proved this using:
        columns.Bound(p => p.GroupCode).Stickable(true).Title("Teaching Group Code").Width(400).Filterable(ftb => ftb.Multi(true).Search(true)); ;
        columns.Bound(p => p.GroupTitle).Stickable(true).Title("Teaching Group Title").Width(800).Filterable(true);

When all columns have pixel widths and their sum is less than the width of the Grid, 
the column widths are ignored and the browser expands all columns.
By default, scrolling is disabled for the Grid in UI for ASP.NET MVC and UI for ASP.NET MVC. 
When scrolling is disabled:
  The table-layout style is set to auto. 
  If not explicitly defined, the column widths are determined by the browser and by the cell content, 
  which is the default behavior of HTML tables.
  The browser will try to obey all column widths that are set but might adjust the widths of some columns depending on their content.

--------------------------------------------------------------------------

Making Non-Scrollable Grids Obey Column Widths
Change the table-layout to fixed.

  #GridID > table // A header and data table.
  {
      table-layout: fixed;
  }

  https://docs.telerik.com/aspnet-mvc/html-helpers/data-management/grid/columns/widths
  --------------------------------------------------------------------------

  Remember kendo grid state (current page, current sort, filter, selected record etc) while loading back grid

  https://www.telerik.com/forums/remember-kendo-grid-state-(current-page-current-sort-filter-selected-record-etc)-while-loading-back-grid

