We have a problem with the RadGrid DetailTables when using the Bootstrap skin.

When changing the background colour using the code behind with every other skin everything works perfectly, however, when using the Bootstrap skin, the alternative background colour of the skin seems to overwrite our set colour to the bootstrap alternative. This only affects the detail tables. The main Grid renders as expected.

The code for the ItemDataBound is working correctly. Everything works exactly as expected with ALL the other skins, just not the one I want to use!

Has anyone else come up against this issue? Any suggestions of a fix?

We are currently using Telerik UI for ASP.NET_AJAX 2017.3.913

Thanks

Chris

Hello!

I'm trying to use a pre formatted xlsx file as a starting point for my spreadsheet, and then trying to load data from my webservice (using a DropDownList to select a year) into some of its cells, so that the user can change the value of those cells and then hit the save button so that I can retrieve both the values and the formulas of the edited cells. However, I'm having trouble finding a solution that covers all the steps required for my program to work:

1) I tried using the SpreadsheetDocumentProvider to load my xlsx document, but then I don't know how to both load the data into the resulting spreadsheet, and also overriding its save function so that I can retrieve the values and formulas of the cells.

2) I tried overriding the SpreadsheetDataBaseProvider, which lets me load info from my webservice and into the cells I want, however I don't know how to load the format of my xlsx file, tell it which value is selected in the "Year" DropDownList so that I can load the correct values, or how I can send a parameter to the SaveWorkbook Method so that I save only certain cells.

Is it possible to do what I need with this control? Is there an example project I could use to learn more about it or should I use another controller entirely?

Thanks.

Is there a way to Export a RadGrid to PDF and have the PDF content fill more of the page? I have an output set for Letter Landscape. Here is the setup i'm using in the ItemCommand event.

                grdScoreCardDashboard.ExportSettings.Pdf.BorderType = GridPdfSettings.GridPdfBorderType.AllBorders
                grdScoreCardDashboard.ExportSettings.OpenInNewWindow = True
                grdScoreCardDashboard.ExportSettings.IgnorePaging = True
                grdScoreCardDashboard.ExportSettings.Pdf.PageHeight = Unit.Parse("162mm")
                grdScoreCardDashboard.ExportSettings.Pdf.PageWidth = Unit.Parse("600mm")
                grdScoreCardDashboard.ExportSettings.Pdf.PageRightMargin = Unit.Parse("10mm")
                grdScoreCardDashboard.ExportSettings.Pdf.PageLeftMargin = Unit.Parse("10mm")
                grdScoreCardDashboard.ExportSettings.Pdf.Title = "Score Card"
                grdScoreCardDashboard.ExportSettings.Pdf.PaperSize = GridPaperSize.Letter
                grdScoreCardDashboard.ExportSettings.FileName = String.Format("ScoreCardOutput-{0}", DateTime.Now.ToString("yyyyMMddhhmmss"))
                grdScoreCardDashboard.ExportSettings.Pdf.AllowPrinting = True
                grdScoreCardDashboard.ExportSettings.Pdf.AllowModify = True
                grdScoreCardDashboard.ExportSettings.Pdf.AllowCopy = True
                grdScoreCardDashboard.ExportSettings.ExportOnlyData = False
                grdScoreCardDashboard.ExportSettings.Pdf.FontType = Telerik.Web.Apoc.Render.Pdf.FontType.Embed

Hello guys,

We have a ComboBox with checkboxes that is populated in the server-side. Also there it is determined which items should be checked. AutoPostBack for the component is set to false and we trigger a postback through other means.

When the dropdown is closed (OnClientDropDownClosing or OnClientDropDownClosed event), we need to retain the items that were checked at the last postback.

Here is an example:

Let's say we have the items a,b,c,d in the ComboBox:

a and b are set to checked at the last postback. On the client-side the user makes some changes so that yet c and d are checked. Now he decides to close the dropdown. We want that yet a and b are left checked.

Currently we have that implemented through a "hack", but we have some cases with massive thata(2000 items+) where it takes several seconds before the dropdown closes, and this is a major performance issue. So is there any way to implement that behaviour?

Thanks,

Simeon

A lot of your stuff is available this way, and it makes upkeep much more convenient.  Yet some, like Telerik.Web.Spreadsheet.dll do not appear to be available that way. I am just curious what the reasoning behind that is. 

This causes us to have to maintain a binary folder with the DLLs being checked into source control so that our build server can access it.  So now instead of just updating a nuget package, we have to install any updates and remember to copy them over to our binary folder.

It is not universe ending or anything, but I just don't understand why you put some tools in your nuget server and some (in the same software package) you do not.

     Hello,

I am trying to display text next to export to excel button on the grid. However, it is not visible on the UI.

 <telerik:RadGrid RenderMode="Lightweight" ID="RadGrid2"   Width="100%"   AllowFilteringByColumn="True"
            AllowSorting="True" AllowPaging="True" PageSize="7" runat="server" AutoGenerateColumns="False"   OnItemCommand="RadGrid1_ItemCommand"
            ShowStatusBar="false" EnableLinqExpressions="false">
<GroupingSettings CaseSensitive="false"></GroupingSettings>
            <MasterTableView CommandItemDisplay="Top"    CommandItemStyle-HorizontalAlign="Left"  DataKeyNames="InstitutionID" TableLayout="Fixed">
  <CommandItemSettings       ExportToExcelText="Export to Excel"   ShowExportToExcelButton="true" AddNewRecordText="Add new program" ShowAddNewRecordButton="true" ShowRefreshButton="false" />
                <Columns>
<%--<telerik:GridTemplateColumn AllowFiltering="false">
<ItemTemplate>
<asp:LinkButton ID="btnlnk" runat="server" OnClientClick="document.forms[0].target = '_blank';"    Text='Edit' OnClick="btnlnk_Click"/>
</ItemTemplate>
</telerik:GridTemplateColumn> --%>

                    <telerik:GridHyperLinkColumn FooterText="HyperLinkColumn footer" DataTextFormatString="Edit" DataNavigateUrlFields="InstPrgID,DegreeCode" UniqueName="InstPrgID1" DataNavigateUrlFormatString="/heirs/programinventory/editinventory.aspx?&PrgId={0}&DegCode={1}" AllowFiltering="false"   DataTextField="InstPrgID"></telerik:GridHyperLinkColumn>
<telerik:GridBoundColumn FilterDelay="2000" AllowFiltering="true"      AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="false" DataField="InstPrgID" UniqueName="InstPrgID"  HeaderText="Identifier"/>  
<telerik:GridBoundColumn FilterDelay="2000" AllowFiltering="true" ShowFilterIcon="false" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains"  DataField="programTitle" UniqueName="programTitle"   HeaderText="Program Title"/>  
<telerik:GridBoundColumn FilterDelay="200" AllowFiltering="false" UniqueName="PrgDegree"  DataField="PrgDegree" HeaderText="Program Degree"/>
<telerik:GridBoundColumn UniqueName="PrgOffStatus"  DataField="PrgOffStatus" HeaderText="Program Offering Status" 
                        HeaderStyle-Width="200px">
                        <FilterTemplate>
                            <telerik:RadComboBox RenderMode="Lightweight" ID="RadComboBoxTitle"   DataSourceID="SqlDataSource2"  DataTextField="STATUS" DataValueField="STATUS"
                                  Width="200px" AppendDataBoundItems="true" SelectedValue='<%# TryCast(Container, GridItem).OwnerTableView.GetColumn("PrgOffStatus").CurrentFilterValue %>'
                                runat="server" OnClientSelectedIndexChanged="TitleIndexChanged">
                            <Items>
                                            <telerik:RadComboBoxItem Text="All" Value="" />
                                                                                      
                                        </Items> 
                            </telerik:RadComboBox>
                            <telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">
                                <script type="text/javascript">
function TitleIndexChanged(sender, args) {
var tableView = $find("<%# TryCast(Container, GridItem).OwnerTableView.ClientID %>");
tableView.filter("PrgOffStatus", args.get_item().get_value(), "EqualTo");
                                }
                                </script>
                            </telerik:RadScriptBlock>
                        </FilterTemplate>
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn Visible="false"  FilterDelay="200" AllowFiltering="false" UniqueName="InstitutionID"   DataField="InstitutionID"  HeaderText="Identifier"/>
    
<%--<telerik:GridBoundColumn Visible="false"   DataField="PrgOffStatus" UniqueName="PrgOffStatus"  HeaderText="Program Offering Status"/>--%>
<telerik:GridBoundColumn Visible="false"   DataField="CIPCode" UniqueName ="CIPCode"  HeaderText="CIP Code"/>
<telerik:GridBoundColumn Visible="false"   DataField="CIPDesc" UniqueName="CIPDesc" HeaderText="CIP Description"/>
<telerik:GridBoundColumn Visible="false"   DataField="ProgramTyp" UniqueName="ProgramTyp"  HeaderText="Program Type"/>
<telerik:GridBoundColumn Visible="false"   DataField="PrgOffStatus" UniqueName="PrgOffStatus"  HeaderText="Program Offering Status"/>
<telerik:GridBoundColumn Visible="false"   DataField="RequiredHours" UniqueName="RequiredHours"  HeaderText="Credit Or Contact Hours"/>
<telerik:GridBoundColumn Visible="false"   DataField="ProgramFocus" UniqueName="ProgramFocus"  HeaderText="Program Focus"/>
<telerik:GridBoundColumn Visible="false"   DataField="EduIndicator" UniqueName="EduIndicator"  HeaderText="Distance Education"/>
    <telerik:GridBoundColumn UniqueName="ProgramClass" DataField="ProgramClass" HeaderText="Classification" 
                        HeaderStyle-Width="200px">
                        <FilterTemplate>
                            <telerik:RadComboBox RenderMode="Lightweight" ID="RadComboBoxClass" DataSourceID="SqlDataSource1"  DataTextField="BHE_PROG_TYPE_LONG_DESC" DataValueField="BHE_PROG_TYPE_LONG_DESC"
                                  Width="200px" AppendDataBoundItems="true" SelectedValue='<%# TryCast(Container, GridItem).OwnerTableView.GetColumn("ProgramClass").CurrentFilterValue %>'
                                runat="server" OnClientSelectedIndexChanged="ClassIndexChanged">
                             <Items>
                                            <telerik:RadComboBoxItem Text="All" Value="" />
                                             
                                        </Items> 
                            </telerik:RadComboBox>
                            <telerik:RadScriptBlock ID="RadScriptBlock2" runat="server">
                                <script type="text/javascript">
function ClassIndexChanged(sender, args) {
var tableView = $find("<%# TryCast(Container, GridItem).OwnerTableView.ClientID %>");  
tableView.filter("ProgramClass", args.get_item().get_value(), "EqualTo");
                                }
                                </script>
                            </telerik:RadScriptBlock>
                        </FilterTemplate>
                    </telerik:GridBoundColumn>
<telerik:GridBoundColumn FilterDelay="200" AllowFiltering="false" Visible="false" UniqueName="BoardApprovedPrgTitle" DataField="BoardApprovedPrgTitle" HeaderText="Board Approved Program Title"/>
<telerik:GridBoundColumn Visible="false"   DataField="YrsAppv" UniqueName="YrsAppv" HeaderText="Year Approved"/>
<telerik:GridBoundColumn Visible="false"   DataField="PublicName" UniqueName="PublicName"  HeaderText="Public Facing Name"/>
<telerik:GridBoundColumn Visible="false"   DataField="WebsiteURL" UniqueName="WebsiteURL"  HeaderText="Program URL"/>
<telerik:GridBoundColumn Visible="false"   DataField="DegreeType" UniqueName="DegreeType" HeaderText="Degree Type"/>
<telerik:GridBoundColumn Visible="false"   DataField="WIOA" UniqueName ="WIOA"  HeaderText="WIOA Eligible"/>
<telerik:GridBoundColumn Visible="false"   DataField="Duration" UniqueName="Duration" HeaderText="Duration"/>
<telerik:GridBoundColumn Visible="false"   DataField="OpenPublic" UniqueName="OpenPublic"  HeaderText="Open to Public"/>
<telerik:GridBoundColumn Visible="false"   DataField="SOCGrpID" UniqueName="SOCGrpID"  HeaderText="Program Group"/>
                    <telerik:GridBoundColumn Visible="false"   DataField="SOC1" UniqueName="SOC1"  HeaderText="SOC1"/>                    
                    <telerik:GridBoundColumn Visible="false"   DataField="SOC1DESC" UniqueName="SOC1DESC"  HeaderText="SOC1 DESC"/>
<telerik:GridBoundColumn Visible="false"   DataField="SOC2" UniqueName="SOC2"  HeaderText="SOC2"/>                    
                    <telerik:GridBoundColumn Visible="false"   DataField="SOC2DESC" UniqueName="SOC2DESC"  HeaderText="SOC2 DESC"/>
<telerik:GridBoundColumn Visible="false"   DataField="SOC3" UniqueName="SOC3"  HeaderText="SOC3"/>                    
                    <telerik:GridBoundColumn Visible="false"   DataField="SOC3DESC" UniqueName="SOC3DESC"  HeaderText="SOC3 DESC"/>
<telerik:GridBoundColumn Visible="false"   DataField="SOC4" UniqueName="SOC4"  HeaderText="SOC4"/>                    
                    <telerik:GridBoundColumn Visible="false"   DataField="SOC4DESC" UniqueName="SOC4DESC"  HeaderText="SOC4 DESC"/>
<telerik:GridBoundColumn Visible="false"   DataField="SOC5" UniqueName="SOC5"  HeaderText="SOC5"/>                    
                    <telerik:GridBoundColumn Visible="false"   DataField="SOC5DESC" UniqueName="SOC5DESC"  HeaderText="SOC5 DESC"/>
<telerik:GridBoundColumn Visible="false"   DataField="SOC6" UniqueName="SOC6"  HeaderText="SOC6"/>                    
                    <telerik:GridBoundColumn Visible="false"   DataField="SOC6DESC" UniqueName="SOC6DESC"  HeaderText="SOC6 DESC"/>
<telerik:GridBoundColumn Visible="false"   DataField="SOC7" UniqueName="SOC7"  HeaderText="SOC7"/>                    
                    <telerik:GridBoundColumn Visible="false"   DataField="SOC7DESC" UniqueName="SOC7DESC"  HeaderText="SOC7 DESC"/>
<telerik:GridBoundColumn Visible="false"   DataField="SOC8" UniqueName="SOC8"  HeaderText="SOC8"/>                    
                    <telerik:GridBoundColumn Visible="false"   DataField="SOC8DESC" UniqueName="SOC8DESC"  HeaderText="SOC8 DESC"/>
<telerik:GridBoundColumn Visible="false"   DataField="SOC9" UniqueName="SOC9"  HeaderText="SOC9"/>                    
                    <telerik:GridBoundColumn Visible="false"   DataField="SOC9DESC" UniqueName="SOC9DESC"  HeaderText="SOC9 DESC"/>
<telerik:GridBoundColumn Visible="false"   DataField="SOC10" UniqueName="SOC10"  HeaderText="SOC10"/>                    
                    <telerik:GridBoundColumn Visible="false"   DataField="SOC10DESC" UniqueName="SOC10DESC"  HeaderText="SOC10 DESC"/>
                    
                    

                
                </Columns>
<%--<CommandItemTemplate>
<div>
<table>
        <tr>
            <td width="30%">
                <asp:LinkButton ID="LinkButton8" Text="Add new program" CommandName="InitInsert" runat="server"></asp:LinkButton>
            </td>
            <td width="40%">
            </td>
            <td width="30%">
                <asp:LinkButton ID="LinkButton9" Text="Export to Excel" CommandName="ExportToExcel"  runat="server"></asp:LinkButton>
            </td>
        </tr>
    </table>
    </div>

 
</CommandItemTemplate>--%>

            </MasterTableView>
   
        </telerik:RadGrid>