I have a Telerik RadGrid, and there is a date column on the grid layout. The date format I am using to display date values is "dd/MM/yyyy". Then, I export that grid data to Excel file with GridExcelExportFormat.Biff type. The problem here is when I open the newly exported Excel file, the date format is changed to "MM/dd/yyyy".
I want to keep displaying my date format "dd/MM/yyyy" in the Excel file after exporting the grid data.
Issue seems to happen with RadGrid with Bootstrap Skin, RenderMode Lightweight when RequireFieldValidator is enabled in combination with Batch Editing.
Unexpected look (Bootstrap skin):
Other skins seems to have it right.
Expected look (Default skin):
Expected look (Silk skin):
If the Page culture is set to anything other than "en-US", RadDatePicker in the HeaderContextMenu will loose the correct format and swaps the Day with the Month after filtering.
To replicate the problem:
Clicking on the Edit button fires the RowClick event of the Grid instead of Edit/Save/Cancel.
When virtualization is enabled for RadGrid, NeedDataSource is called at every Post back with RebindReason = ExplicitRebind, regardless of the event target.
Steps to reproduce:Use the following Code snippets for the runnable sample and debug the NeedDataSource event while doing post backs using other controls. For instance, you can use the RadButton1 from these snippets to make a standard Post Back.