
I am experiencing an issue and I am not sure it is a bug or just is an expected behavior from MS Excel.
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 think MS Excel did re-apply the default date format for my date column (?)
I want to keep displaying my date format "dd/MM/yyyy" in the Excel file after exporting the grid data, is there a way to do that?
Here is my code.
Default.aspx
01.<asp:LinkButton ID="linkBtnExportToExcel" runat="server" OnClick="linkBtnExportToExcel_Click">Export to Excel</asp:LinkButton>02. 03. <telerik:RadGrid AutoGenerateColumns="false" ID="rgInvoices"04. AllowFilteringByColumn="false" AllowSorting="True"05. EnableLinqExpressions="false"06. ClientSettings-EnableAlternatingItems="false"07. GroupingSettings-CaseSensitive="false"08. AllowPaging="true" AllowCustomPaging="true" PageSize="20" runat="server"09. 10. OnNeedDataSource="rgInvoices_NeedDataSource"11. OnItemDataBound="rgInvoices_ItemDataBound"12. OnItemCommand="rgInvoices_ItemCommand"13. OnSortCommand="rgInvoices_SortCommand">14. 15. <GroupingSettings CaseSensitive="false"></GroupingSettings>16. <ClientSettings EnableRowHoverStyle="true"></ClientSettings>17. 18. <MasterTableView AutoGenerateColumns="false" AllowFilteringByColumn="false" ShowFooter="false" DataKeyNames="EmployeeID,HiredDate,Employee">19. 20. <Columns>21. <telerik:GridBoundColumn UniqueName="Employee" DataField="Employee" HeaderText="Employee" ShowFilterIcon="false" AllowFiltering="false" AutoPostBackOnFilter="true" DataFormatString="{0:@}">22. 23. </telerik:GridBoundColumn>24. <telerik:GridBoundColumn UniqueName="HiredDate" DataField="HiredDate" HeaderText="Hired Date"25. DataFormatString="{0:dd/MM/yyyy}" ShowFilterIcon="false" AllowFiltering="false" AutoPostBackOnFilter="true">26. </telerik:GridBoundColumn> 27. </Columns>28. 29. <HeaderStyle CssClass="RadGrid-HeaderStyle" Font-Bold="true" />30. <ItemStyle CssClass="RadGrid-ItemStyle" />31. <AlternatingItemStyle CssClass="RadGrid-AlternatingItemStyle" />32. </MasterTableView>33. </telerik:RadGrid>
And Default.aspx.vb
01.Public Class _Default02. Inherits System.Web.UI.Page03. Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load04. 05. End Sub06. 07. Protected Sub rgInvoices_NeedDataSource(sender As Object, e As Telerik.Web.UI.GridNeedDataSourceEventArgs)08. rgInvoices.DataSource = GetGridSource()09. End Sub10. 11. Protected Sub rgInvoices_ItemDataBound(sender As Object, e As Telerik.Web.UI.GridItemEventArgs)12. 13. End Sub14. 15. Protected Sub rgInvoices_ItemCommand(sender As Object, e As Telerik.Web.UI.GridCommandEventArgs)16. 17. End Sub18. 19. Protected Sub rgInvoices_SortCommand(sender As Object, e As Telerik.Web.UI.GridSortCommandEventArgs)20. 21. End Sub22. 23. Protected Sub linkBtnExportToExcel_Click(sender As Object, e As EventArgs)24. Me.rgInvoices.ExportSettings.Excel.Format = GridExcelExportFormat.Biff25. Me.rgInvoices.ExportSettings.IgnorePaging = True26. Me.rgInvoices.ExportSettings.ExportOnlyData = True27. Me.rgInvoices.ExportSettings.OpenInNewWindow = True28. Me.rgInvoices.ExportSettings.FileName = "ExportExcelDemo"29. Me.rgInvoices.MasterTableView.ExportToExcel()30. End Sub31. 32. Private Function GetGridSource() As DataTable33. Dim dataTable As DataTable = New DataTable()34. 35. Dim column As DataColumn = New DataColumn()36. column.DataType = Type.[GetType]("System.Int32")37. column.ColumnName = "EmployeeID"38. dataTable.Columns.Add(column)39. 40. column = New DataColumn()41. column.DataType = Type.[GetType]("System.DateTime")42. column.ColumnName = "HiredDate"43. dataTable.Columns.Add(column)44. 45. column = New DataColumn()46. column.DataType = Type.[GetType]("System.String")47. column.ColumnName = "Employee"48. dataTable.Columns.Add(column)49. 50. Dim PrimaryKeyColumns As DataColumn() = New DataColumn(0) {}51. PrimaryKeyColumns(0) = dataTable.Columns("EmployeeID")52. dataTable.PrimaryKey = PrimaryKeyColumns53. 54. 55. Dim row As DataRow = dataTable.NewRow()56. row("EmployeeID") = 257. row("HiredDate") = New Date(2019, 7, 1)58. row("Employee") = "Tina Bush"59. dataTable.Rows.Add(row)60. 61. Return dataTable62. End Function63. 64.End Class
Thanks for your support!

Hello,
We have this issue in our developpement on WebForms ASP.NET 4.5.2 (VS2015 Update 3) with last version 2019.2 with this configuration :
In master.page :
<script>
function RadPan_ItemClicking(sender, eventArgs)
{
var oItem = eventArgs.get_item();
if (oItem.get_expanded()) {
oItem.collapse();
}
else
oItem.expand();
var sUrl = "";
var aAttributes = oItem._attributes;
if (aAttributes.get_count())
sUrl = aAttributes.getAttribute("URL");
if (IsDefined(sUrl))
{
if (sUrl!="")
{
var oPanelBar = oItem.get_panelBar();
oPanelBar._postback();
eventArgs.set_cancel(false);
return;
}
}
eventArgs.set_cancel(true);
}
</script>
<telerik:RadPanelBar runat="server" ID="RadPan" ExpandMode="SingleExpandedItem" PersistStateInCookie="True"
onclientitemclicking="RadPan_ItemClicking"
ViewStateMode="Enabled">
<CollapseAnimation Duration="100" Type="None" />
<ExpandAnimation Duration="100" Type="None" />
</telerik:RadPanelBar>
--------------------------
It's a manual binding with 3 level of RadPanelItem,
We don't use NavigateUrl property but we use OnItemClick event to check data in session before redirect
All RadPanelItems have URL Attribute that is read from OnItemClick event
The behind Code IS NOT in master page BUT in child Page named BasePage (it's inherit WebPage for all pages of project)
Sample of BasePage.aspx.cs
protected override void OnLoad(EventArgs e)
{
_masterPage = Master as MyMaster;
RadPanelBar oRadPan = _masterPage.FindControl("RadPan") as RadPanelBar;
..... (Manual Binding without datasource)
}
To solve this issue temporarely, we use this Javascript code below BUT it's not clean :
$(function () {
if (Telerik.Web.Browser.edge) {
with (window)
if (!location.href.contains("#") && !location.href.contains("?")) {
open(location.href + "?", "_blank");
close();
}
}
else {
if (sPathname.contains("index.aspx"))
with (window.location)
if (!href.contains("#")) {
replace(href + "#");
reload();
}
}
});

Hello
We have a requirement to do the following. Can you please tell me whether it is doable (or how much of it is doable) at the moment using Telerik Diagram. If it is, can you please point me to a starting point?
So we need to --
- allow user to drag and drop blocks into a canvas
- be able to relate blocks
- have a popup appear when relating two blocks to allow input of one or more attributes
- allow editing of relationship by may be double clicking on the relational lines
- save diagram on a web page
- export diagram to excel
- have an auto-layout button option or allow user to manually move boxes around
- allow user to color code blocks based on some attribute
I did find a page
https://demos.telerik.com/aspnet-ajax/diagram/examples/interactions/defaultcs.aspx
that does some of what we want but not everything.
Any help will be appreciated.
Thank you
Sandhia

Hi,
Is there a way to chose chart culture depending on session value.
Something in Jquery, such as:
<script type="text/javascript" src="cul/kendo.culture.sv-SE.min.js"></script> <script type="text/javascript" src="cul/kendo.culture.en-US.js"></script> <script> function getit() { var lang =$('#<%=hfv.ClientID%>').html(); if (lang = "sv-SE") { kendo.culture("sv-SE"); alert("sv"); } else { kendo.culture("en-US"); alert("en"); } } onload=getit; </script>
The problem with the above, is that it dos not work.
Any idea how to do that.
Regards,
Omar
Good morning,
I am using radScheduler to schedule appointments for employees. Employees have different work schedules each day so I am highlighting their available slots using TimeSlotCreated. Everything works perfectly except for when I try to edit an appointment, all the highlighting disappears. Attached are some images of the process. You can see Jim Bergland is available from 9:00AM to 5:00PM and the light blue background is displaying for him but as soon as I try to edit any of the two existing appointments the background color in the slots is removed.
I know this fact about TimeSlotCreated: "The TimeSlotCreated event is not fired after the advanced edit form is opened (it fires before that, and rendering the advanced form renders the scheduler anew). Thus, customizations for the time slots made in the handler are not rendered while the advanced edit form is visible."
Is there any other way to achieve the time slot shading during the appointment edits?

Not sure if this is a RadWindow or RagGrid issue, but issue is affecting the RagGrid, however this issue is limited to viewing the page in Internet Explorer only (Chrome and Edge work).
When I open a URL with a RadGrid in a RadWindow, the embedded icons (add, refresh, edit, delete, etc.) are not visible. If I open the exact URL directly in the browser I see the icons. I understand these images are actually fonts and there may be issues with these fonts in IE, but this only happens when the URL is displayed in a RadWindow.
Is there a solution or work-around?

When I enable lightweight render globally within my app, it appears my page CSS which controls layout seems to be ignored.
How do I force the controls to use the CssClass settings I have set?
