I am using ExportToExcel and successfully generate an XLSX file from a RadGrid. Here is my event handler that is triggered from a custom button, not the built-in export button:
lvSearchResults.ExportSettings.FileName = "bla";lvSearchResults.ExportSettings.IgnorePaging = true;lvSearchResults.ExportSettings.OpenInNewWindow = true;lvSearchResults.ExportSettings.Excel.Format = GridExcelExportFormat.Xlsx;lvSearchResults.ExportSettings.Excel.FileExtension = "xlsx"; lvSearchResults.MasterTableView.ExportToExcel();
My problem is that date columns are displayed correctly in the browser, but they are wrong and also changing in the resulting Excel file. I set the data format for my date columns as follows (as I generate all columns programmatically):
GridBoundColumn colEintritt = new GridBoundColumn();lvSearchResultsMasterTableView.Columns.Add( colEintritt );colEintritt.HeaderText = Glo.EwdFields.Eintritt;colEintritt.DataField = "Eintrittsdatum"; colEintritt.DataFormatString = "{0:dd.MM.yyyy}";
The Excel file has dates with a "wrong german" formatting, MM.dd.yyyy, and also MM/dd/yyyy. I cannot see why it formats one line like this and one like that. I'd be glad for a hint on how to get this correct.
Thanks and best regards,
Helge

I have a change password page on which I am using a RadTextBox in password mode. I want to show a checklist of all the constraints and show a green check sign next to it as the user enters the respective character similar to the attached image.
How can I achieve that?

I understand that a Ajax grid exporting to excel must be handled differently. In my research I found there are two ways to accomplish this. The only the remotely works is this
Adding this Javascript to the aspx page
Sys.WebForms.PageRequestManager.getInstance().add_initializeRequest(initRequest);
function initRequest(sender, args) {
if (args.get_postBackElement().id.indexOf("btnExportGrid") != -1) {
args.set_cancel(true); //stop async request
sender._form["**EVENTTARGET"].value = args.get_postBackElement().id.replace(/\_/g, "$");
sender._form["**EVENTARGUMENT"].value = "";
sender._form.submit();
return;
}
}
The problem is I get the following Javascript error
0x800a138f - JavaScript runtime error: Unable to set property 'value' of undefined or null reference
If I hit continue the grid exports. if I comment line out I get same error on the next line. I comment that out the export does not work.

Hello,
I have the following configuration for a GridBoundColumn where I wont user to filter out values of"0". RadGrid is bound to a DataTable in code-behind, where value comes as integer. This filtering does not seem to work.
<telerik:GridBoundColumn DataField="Net" AllowFiltering="true" HeaderText="Net" UniqueName="Net" FilterControlWidth="30px" Aggregate="None" ReadOnly="true">
<HeaderStyle Width="35px" />
<FilterTemplate>
<telerik:RadComboBox ID="RadComboBoxNet" DataTextField="Net"
DataValueField="Net" Height="200px" Width="90px" AppendDataBoundItems="true" SelectedValue='<%# TryCast(Container, GridItem).OwnerTableView.GetColumn("Net").CurrentFilterValue%>'
runat="server" OnClientSelectedIndexChanged="NetIndexChanged">
<Items>
<telerik:RadComboBoxItem Text="All" />
<telerik:RadComboBoxItem Text="0" />
</Items>
</telerik:RadComboBox>
<telerik:RadScriptBlock ID="RadScriptBlockNet" runat="server">
<script type="text/javascript">
function NetIndexChanged(sender, args) {
var tableView = $find("<%# TryCast(Container, GridItem).OwnerTableView.ClientID %>");
tableView.filter("Net", args.get_item().get_value().trim(), "GreaterThan");
}
</script>
</telerik:RadScriptBlock>
</FilterTemplate>
</telerik:GridBoundColumn>
Can somebody or support please point to the right direction.
Thank you !
I have the RadMenu below and i am selecting the RadMenuItem from Code behind. the menu is only 2 Levels.
I would like to Expand the Root Level of the Selected Menu
Please can you advise?
Thanks
<telerik:RadMenu runat="server" RenderMode="Auto" ID="RadMenu" ExpandAnimation-Type="None" CssClass="RadMenu_MyMenU" EnableRoundedCorners="true" EnableShadows="true"> <Items> <telerik:RadMenuItem Text="Home" ID="Home" runat="server" ToolTip="Home" NavigateUrl="../Admin/Default.aspx" /> <telerik:RadMenuItem Text="Front Page" ID="Frontpage" runat="server" ToolTip="FrontPage"> <Items> <telerik:RadMenuItem Text="Slider" ID="slider" runat="server" ToolTip="Slider" NavigateUrl="../Admin/Manage_Slider.aspx" /> <telerik:RadMenuItem Text="Links" ID="Links" runat="server" ToolTip="Links" NavigateUrl="../Admin/Manage_Links.aspx" /> </Items> </telerik:RadMenuItem> <telerik:RadMenuItem Text="Menu & Pages" ID="menuandpages" ToolTip="Menu & Pages" runat="server"> <Items> <telerik:RadMenuItem Text="Menu Items" ID="menuitems" runat="server" ToolTip="Menu Items" NavigateUrl="../Admin/Manage_Menu.aspx" /> <telerik:RadMenuItem Text="Pages" ID="pages" runat="server" ToolTip="Pages" NavigateUrl="../Admin/Manage_Page.aspx" /> </Items> </telerik:RadMenuItem> <telerik:RadMenuItem Text="Media" ToolTip="Media" ID="media" runat="server"> <Items> <telerik:RadMenuItem Text="Announcements" id="Announcements" runat="server" ToolTip="Announcements" NavigateUrl="../Admin/Manage_Announcement.aspx" /> <telerik:RadMenuItem Text="News" ID="News" runat="server" ToolTip="News" NavigateUrl="../Admin/Manage_News.aspx" /> <telerik:RadMenuItem Text="E-Magazine" id="EMagazine" runat="server" ToolTip="E-Magazine" NavigateUrl="../Admin/Manage_EMagazine.aspx" /> </Items> </telerik:RadMenuItem> <telerik:RadMenuItem Text="Courses" ToolTip="Courses" ID="coursesmodule" runat="server"> <Items> <telerik:RadMenuItem Text="Course Collections" ID="CourseCollections" ToolTip="Course Collections" NavigateUrl="../Admin/Manage_CourseCollections.aspx" /> <telerik:RadMenuItem Text="Courses" ToolTip="Courses" ID="Courses" NavigateUrl="../Admin/Manage_Courses.aspx" /> <telerik:RadMenuItem Text="Course Chapters" ID="CourseChapters" ToolTip="Course Chapters" NavigateUrl="../Admin/Manage_CourseChapters.aspx" /> <telerik:RadMenuItem Text="Course Materials" ID="CourseMaterials" ToolTip="Course Materials" NavigateUrl="../Admin/Manage_CourseMaterials.aspx" /> </Items> </telerik:RadMenuItem> <telerik:RadMenuItem Text="Administration" ToolTip="Administration"> <Items> <telerik:RadMenuItem Text="Users" ToolTip="Users" NavigateUrl="../Admin/Manage_Users.aspx" /> <telerik:RadMenuItem Text="Roles" ToolTip="Roles" NavigateUrl="../Admin/Manage_Roles.aspx" /> <telerik:RadMenuItem Text="Permissions" ToolTip="Permissions" NavigateUrl="../Admin/Manage_Permissions.aspx" /> <telerik:RadMenuItem Text="User Roles" ToolTip="User Roles" NavigateUrl="../Admin/Manage_UserRoles.aspx" /> </Items> </telerik:RadMenuItem> <telerik:RadMenuItem Text="Logout" NavigateUrl="../Admin/LogOut.aspx" /> </Items> </telerik:RadMenu>Hello
I I have the following column setup ( it is part of the radgrid, this particular configuration provides necessary visual appearance . Other columns on the grid are filterable.)
<telerik:GridTemplateColumn AllowFiltering="true" HeaderText='Select' >
<FilterTemplate>
<asp:CheckBox ID="chkSelectAll" runat="server" OnClientClick ="CheckUncheckAll(this)" />
</FilterTemplate>
<ItemTemplate>
<asp:CheckBox ID="chkStatus" runat="server" />
</ItemTemplate>
<HeaderStyle Width="30px" HorizontalAlign="Center" />
</telerik:GridTemplateColumn>
When I click on filter bar checkbox, I want to catch this event and process it in client-side javascript. It does not fire in this configuration. It does fire in <headertemplate> , but I need this setup for specific appearance.
Can somebody from telerik support point to the right combination of attributes/tags/events ? Thank you.
Is there a way to hide tree lines for top level items in a tree list? See the attached picture - I'm hoping to only show the tree lines for the items highlighted.
We have a standard in our application that all grids should have ClientSettings-AllowScroll to be set to Yes so that the grid container always resides within the bounds of the viewport. We would like to implement a feature that would allow users to click on a "Full Screen" button that would expand the grid container to be full screen and disable the internal scrolling.
Has anyone ever implemented a feature similar to this? There's nothing in the client-side API that would allow us to just disable the scrolling so our UI team is considering trying to modify the CSS to alter the vertical and horizontal overflow, but we're concerned this would have potentially disastrous side effects.
If anyone has any creative ideas for how this might be accomplished, we're completely open to whatever approach might fulfill this requirement.
I have users in China that access my application hosted internally. I'm getting timeout errors pulling down the Radcontrol javascript files. Is it possible to redirect the javascript that the controls use to a local source? Specifically these:
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Common/Core.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Common/jQuery.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Common/jQueryInclude.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Common/Popup/PopupScripts.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Common/jQueryPlugins.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Common/TouchScrollExtender.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Common/Helpers/IETouchActionManager.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Common/Widgets/Draggable.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Common/Widgets/Resizable.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Common/ShortCutManager/ShortCutManagerScripts.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Common/MaterialRipple/MaterialRippleScripts.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Common/AnimationFramework/AnimationFramework.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Common/Animation/AnimationScripts.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Window/RadWindowScripts.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Window/RadWindowManager.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/FormDecorator/RadFormDecorator.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Common/Scrolling/ScrollingScripts.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Common/Navigation/OData/OData.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Common/Navigation/NavigationScripts.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Common/Navigation/OverlayScript.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Menu/RadMenuScripts.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Menu/MenuItem/RadMenuItem.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Menu/Views/ClassicView.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/ComboBox/RadComboBoxScripts.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/ComboBox/Views/ClassicView.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/TabStrip/RadTabStripScripts.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/TabStrip/Views/ClassicView.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/TabStrip/MultiPage/RadMultiPageScripts.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Input/TextBox/RadInputScript.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Button/RadButtonScripts.js"
type="text/javascript"></script>
<script src="https://d2i2wahzwrm1n5.cloudfront.net/ajaxz/2017.1.118/Grid/RadGridScripts.js"
type="text/javascript"></script>
When using the jscript function as this post http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/client-side-programming/gridcolumn-object/methods/resizetofit- with a editable grid in form type cause "InvalidAccessError: A parameter or an operation is not supported by the underlying object" with build 2017.1.213.40.
The edit mode enables correctly but the form moves near the last columns of the grid, so scrolling is needed to rearch the edit form.
When the script is removed the jscript error disappear but the columns are not visible as the width of each one is too much small.
Is there any other way to auto fit columns? this error did not happen with previous version
