I would like to do some formatting on exported Excel spreadsheets, preferably with utilizing the BIFF export. Is it possible to do the following things with exporting via BIFF? If not, how about HTML or ExcelML?

-Scaling width to fit on one page
-Adding Header data (that will show on each page when printed)
-Adding footer data (that will show on each page when printed)
-Adjusting margins
-Looping through each row and coloring every other row a different color

Good afternoon, 
I have a problem with Telerik's controls. 
I have several drop down in a RadPanel. Within the form I have a button that opens a modal window (it's a ascx). At the same time that the modal window opens, every drop down opens or closes (just the opposite it was). 
My question is .. 
Is there any way to remain opened the dropdown RadPanel and not getting them closed automatically when opening the modal window? 

Thank you very much.

Hi Team,

I am using telerik version of

I have a grid inside that grid I have three tabs.In one tab click I am displaying the labels with some data.
I need to edit that labels.
Is it possible to edit the labels inside the grid.

aspx file:

<telerik:RadGrid ID="LoadingRadGrid" OnItemDataBound="LoadingRadGridFormat_OnItemDataBound"
                            runat="server" AutoGenerateColumns="false" CssClass="TransferGridPanel" Height="375px"
                            Width="500px" OnNeedDataSource="LoadingRadGrid_NeedDataSource"
                             OnUpdateCommand="LoadingRadGrid_UpdateCommand" OnBatchEditCommand="LoadingRadGrid_BatchEditCommand" OnInsertCommand="LoadingRadGrid_InsertCommand"
                             OnItemCommand="LoadingRadGrid_ItemCommand" OnSelectedIndexChanged="LoadingRadGrid_SelectedIndexChanged" OnCancelCommand="LoadingRadGrid_CancelCommand">
                              
                            <MasterTableView ShowHeadersWhenNoRecords="true" CommandItemDisplay="Top" EditMode="Batch" DataKeyNames="Loading_ID">
                                <CommandItemSettings ShowRefreshButton="false" AddNewRecordText="Add NewLoad" />
                            <BatchEditingSettings EditType="Cell" />
                                <NestedViewTemplate>
                                
                                    <telerik:RadTabStrip runat="server" ID="LoadTabStip" MultiPageID="LoadMultipage" ClickSelectedTab="True"
                                        SelectedIndex="0" OnTabClick="LoadTabStip_TabClick" Orientation="HorizontalTop">
                                        <Tabs runat="server">
                                            <telerik:RadTab runat="server" Text="Details" PageViewID="RadPageViewDetails">
                                            </telerik:RadTab>
                                            <telerik:RadTab runat="server" Text="Compartments" PageViewID="RadPageViewCompartments">
                                            </telerik:RadTab>
                                            <telerik:RadTab runat="server" Text="Products" PageViewID="RadPageViewProducts">
                                            </telerik:RadTab>
                                        </Tabs>
                                    </telerik:RadTabStrip>
                                    <telerik:RadMultiPage runat="server" ID="LoadMultipage" SelectedIndex="0" RenderSelectedPageOnly="false">
                                   
                                        <telerik:RadPageView runat="server" ID="RadPageViewDetails">
                                       
                                            <div class="contactWrap">
                                                <table cellpadding="0" cellspacing="0">
                                                    <tr>
                                                       <td><asp:Label ID="lbl_TerminalId" runat="server" Text='Terminal Id:' Font-Bold="true"></asp:Label></td>
                                                       <td><asp:Label ID="lbl_TerminalIdValue" runat="server"></asp:Label> </td> 
                                                    </tr>
                                                    <tr>
                                                        <td><asp:Label ID="lbl_TerminalName" runat="server" Text='TerminalName:' Font-Bold="true"></asp:Label></td>
                                                        <td><asp:Label ID="lbl_TerminalNameValue" runat="server"></asp:Label> </td>
                                                       
                                                    </tr>
                                                </table>
                                            </div>
                                        </telerik:RadPageView>
                                        <telerik:RadPageView runat="server" ID="RadPageViewCompartments">
                                       
                                            <telerik:RadGrid ID="CompartmentLevelLoadRadGrid" runat="server" AutoGenerateColumns="false" CssClass="TransferGridPanel"
                                                Height="233px" Width="475px" OnItemDataBound="CompartmentLevelLoadRadGrid_ItemDataBound" OnNeedDataSource="CompartmentLevelLoadingRadGrid_NeedDataSource"
                                                OnUpdateCommand="CompartmentLevelLoadRadGrid_UpdateCommand" OnBatchEditCommand="CompartmentLevelLoadRadGrid_BatchEditCommand" OnInsertCommand="CompartmentLevelLoadRadGrid_InsertCommand">
                                                <MasterTableView ShowHeadersWhenNoRecords="true" CommandItemDisplay="Top" EditMode="Batch">
                                                     <CommandItemSettings ShowRefreshButton="false" AddNewRecordText="Add Line Item"/>
                                                     <BatchEditingSettings EditType="Cell" />                                              
                                                    <Columns>
                                                   
                                                        <telerik:GridBoundColumn UniqueName="CompNo" DataField="CompartmentIndex" HeaderText="Comp No." ReadOnly="true">
                                                        </telerik:GridBoundColumn>
                                                        <telerik:GridBoundColumn UniqueName="PriorToLoad" DataField="PTL" HeaderText="PriorTo Load">
                                                        </telerik:GridBoundColumn>
                                                        <telerik:GridBoundColumn UniqueName="PlannedLoadProd" DataField="PlannedProductName" HeaderText="Planned Product" ReadOnly="true">
                                                        </telerik:GridBoundColumn>
                                                        <telerik:GridBoundColumn UniqueName="ActualLoadProd" DataField="ActualProductName" HeaderText="Actual Product" >
                                                        </telerik:GridBoundColumn>
                                                        <telerik:GridBoundColumn UniqueName="PlannedLoadQty" DataField="PlannedQuantity" HeaderText="Planned Quantity" ReadOnly="true">
                                                        </telerik:GridBoundColumn>
                                                        <telerik:GridBoundColumn UniqueName="ActualLoadQty" DataField="ActualQuantity" HeaderText="Actual Quantity">
                                                        </telerik:GridBoundColumn>
                                                    </Columns>
                                                </MasterTableView>
                                            </telerik:RadGrid>
                                           
                                        </telerik:RadPageView>
                                        <telerik:RadPageView runat="server" ID="RadPageViewProducts">
                                       
                                            <telerik:RadGrid ID="ProductLevelLoadRadGrid" runat="server" AutoGenerateColumns="false" CssClass="TransferGridPanel"
                                                Height="233px" Width="475px" OnItemDataBound="ProductLevelLoadRadGrid_ItemDataBound" OnNeedDataSource="ProductLevelLoadingRadGrid_NeedDataSource">
                                                <MasterTableView ShowHeadersWhenNoRecords="true">                                               
                                                    <Columns>
                                                        <telerik:GridBoundColumn UniqueName="PlannedLoadProd" DataField="PlannedProductName" HeaderText="Planned Product" Visible="false">
                                                        </telerik:GridBoundColumn>                                                    
                                                        <telerik:GridBoundColumn UniqueName="ActualLoadProd" DataField="ActualProductName" HeaderText="Product">
                                                        </telerik:GridBoundColumn>                                                       
                                                        <telerik:GridBoundColumn  UniqueName="PriorToLoadQty" DataField="PTL"  HeaderText="PriorTo Load">
                                                        </telerik:GridBoundColumn>
                                                        <telerik:GridBoundColumn UniqueName="PlannedLoadQty" DataField="PlannedQuantity" HeaderText="Planned Quantity">
                                                        </telerik:GridBoundColumn>
                                                        <telerik:GridBoundColumn UniqueName="ActualLoadQty" DataField="ActualQuantity" HeaderText="Actual Quantity">
                                                        </telerik:GridBoundColumn>
                                                    </Columns>
                                                </MasterTableView>
                                            </telerik:RadGrid>
                                           
                                        </telerik:RadPageView>
                                    </telerik:RadMultiPage>
                                 
                                </NestedViewTemplate>
                               
                                <Columns>
                                    <telerik:GridBoundColumn UniqueName="LoadId" DataField="Loading_ID" ReadOnly="true">                                       
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn UniqueName="TerminalId" DataField="Plant_ID">
                                        <ColumnValidationSettings EnableRequiredFieldValidation="true">                                           
                                            <RequiredFieldValidator ForeColor="Red" Text="Plant_ID is required" Display="Dynamic">                               
                                            </RequiredFieldValidator>
                                        </ColumnValidationSettings>
                                    </telerik:GridBoundColumn>
                                   
                                    <telerik:GridBoundColumn UniqueName="TerminalName" DataField="TerminalName" ReadOnly="true">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn UniqueName="LoadingStartTime" DataField="LoadingStartTime" ReadOnly="true">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn UniqueName="LoadingEndTime" DataField="LoadingEndTime" ReadOnly="true">
                                    </telerik:GridBoundColumn>
                                </Columns>
                            </MasterTableView>
                            <ClientSettings>
                                <Scrolling AllowScroll="true" />
                            </ClientSettings>
                        </telerik:RadGrid>

aspx.cs file:


protected void LoadTabStip_TabClick(object sender, RadTabStripEventArgs e)
    {
        //AddPageView(e.Tab.Text);
        e.Tab.PageView.Selected = true;
        string selectedtabindex = e.Tab.Text;
        Int64 shipmentID = Convert.ToInt64(ShiftTreeView.SelectedNode.Value);
        Int64 load = 0;
        load = Convert.ToInt64(Session[_lastLoadingSelect1].ToString());
        switch (selectedtabindex)
        {
            case "Details":
                {
                    RadPageView page = (RadPageView)e.Tab.PageView;
                    List<LoadingDetailExtraEntity> loadingDetails = new List<LoadingDetailExtraEntity>();
                    //loadingDetails = loadingDetailManager.GetLoadingDetailByShipmentId(shipmentID);
                    loadingDetails = loadingDetailManager.GetLoadingDetailWSListByLoadingId(load);
                    Label lblTerminalId = (Label)page.FindControl("lbl_TerminalIdValue");
                    Label lblTerminalName = (Label)page.FindControl("lbl_TerminalNameValue");
                    if (loadingDetails.Count > 0)
                    {
                       
                        lblTerminalId.Text = loadingDetails[0].Plant_ID.ToString();                       
                        lblTerminalName.Text = loadingDetails[0].TerminalName;
                    }
                    else
                    {
                        lblTerminalId.Text = MyGlobal.SDP_GUI_RADGRID_NO_RECORDS_FOUND;
                        lblTerminalName.Text = MyGlobal.SDP_GUI_RADGRID_NO_RECORDS_FOUND;
                    }
                    break;
                }
            case "Compartments":
                {
                    RadPageView page = (RadPageView)e.Tab.PageView;
                    RadGrid grdCompartment = (RadGrid)page.FindControl("CompartmentLevelLoadRadGrid");                    //List<LoadingDetailExtraEntity> CompartmentTabListinstance = new List<LoadingDetailExtraEntity>();
                    //CompartmentTabListinstance = loadingDetailManager.GetLoadingDetailWSListByLoadingId(load);
                    //Session["_storeCompartmentLoadTable"] = CompartmentTabListinstance;                    List<LoadingDetailExtraEntity> CompartmentTabListinstance = (List<LoadingDetailExtraEntity>)Session["_storeCompartmentLoadTable"];                    grdCompartment.DataSource = CompartmentTabListinstance;
                    grdCompartment.DataBind();                    //e.Tab.Controls.Add(grdLoad);
                    break;
                }
            case "Products":
                {
                    RadPageView page = (RadPageView)e.Tab.PageView;
                    RadGrid grdProduct = (RadGrid)page.FindControl("ProductLevelLoadRadGrid");
                    //List<LoadingDetailExtraEntity> ProductTabListinstance = new List<LoadingDetailExtraEntity>();
                    //ProductTabListinstance = loadingDetailManager.GetLoadingDetailByLoadIdAtProductLevel(load);
                    //Session["_storeProductLoadTable"] = ProductTabListinstance;                    List<LoadingDetailExtraEntity> ProductTabListinstance = (List<LoadingDetailExtraEntity>)Session["_storeProductLoadTable"];
                    grdProduct.DataSource = ProductTabListinstance;
                    grdProduct.DataBind();
                    break;
                }
        }
    }



​

How to get a time from Rad Time Picker with in  grid using java script function 

I have several RadDropDownLists on the same page.  I would like to bring attention to one of them programmatically, for example by changing the background or foreground color.  What is the simplest correct way to make a minor style change to a single control?  I can do this successfully with a RadTextBox on the same page by setting its CssClass property.

I have tried setting the ForeColor, BackColor, and CssClass properties of my RadDropDownList, but the specificity of built-in styles for .RadDropDownList_Default .rddlInner seems to override any changes I can make.

Hello!

I have been using Telerik ASP NET AJAX controls and love them!

I developed a little webform where I have certain items inside a radlistbox and I can drag and drop those items inside a textbox.

In localhost, it works like a charm; but when I uploded the solution to my production webserver, the darg and drop function does not work.

I have not installed anything into my production server. Do I need to install the .exe file that included the controls into my server?

Thanks a lot and sorry for the dumb question!

I have seen Drag and Drop images in Rad Editor, it's looks good. Is there any controls like Drag and drop pdf pages into Rad Editor instead of images.

I want to open a pdf document with each pages in thumbnail view and drag and drop random pages to view the content.

Hi all, I got a question, right now I face some issue about the radcombobox when using embedded script = false,
Here is my registered script.


But when I try to use it in some pages, it prompted this error behind.

Uncaught TypeError: Cannot read property 'Classic' of undefined 


Example of my code:


Can anybody guide me on this? Thanks

Hi, 
We are using RadHTMLChart Bar series in reports. In Ipad/other devices it is working fine but in mobile (iphone) few of the series label got cut off. In the attached image, under Available series the label has to be 420-> but its been cut off. I have tried using (negative) Margin property nut couldn't get the desired result. I have used ClientTemplate also, if I use Div tag, the values are shown at the bottom of the chart. Can you give me a desired solution for this?? 

Note:
Here * I cannot use "InsideEnd" because this is hiding the value 4. 
* I cannot use Margin (negative) because negative margin is also applicable in 4. 
* Can you explain what tag to use in client template. 

Eg:#if(dataItem.count >10){# <text margin-left="-10px">#= dataItem.count #</text> #} else{# <text>#= dataItem.count#</text> #}#

Here text/div/span tag doesn't give me a desired result. 

RadGrid's filter button property 'CurrentFilterFunction'  showing previous selected value

I am have gone through the below steps and facing some issues :

(1) Page load first time -> CurrentFilterFunction shows 'NoFilter' -> works fine
(2) Enter text in TextBox -> Press tab -> CurrentFilterFunction shows 'Contains'-> works fine
(3) Enter text in TextBox-> press filter button -> select 'DoesNotContains' from drop down list -> CurrentFilterFunction shows 'Contains'(wrong value, it should shows
                                                                                                                                                                                                                                                  'DoesNotContains' )
(4) Enter text in TextBox -> press filter button -> select 'StartsWith' from drop down list -> CurrentFilterFunction shows 'DoesNotContains'(wrong value, , it should
                                                                                                                                                                                                                                             shows 'StartsWith')

can anyone please tell me the reason of this behavior and what is the solution of it. 

below is the code snippet :

<telerik:RadGrid ID="gvParameterLookup" runat="server" AllowSorting="true" CellSpacing="0"
                    CellPadding="2" GridLines="none" HeaderStyle-CssClass="dnnGridHeader" AllowFilteringByColumn="true"
                    AutoGenerateColumns="false" AllowAutomaticUpdates="false" AllowPaging="false"
                    EnableEmbeddedBaseStylesheet="false" EnableEmbeddedSkins="false" >
                    <groupingsettings casesensitive="false" />
                    <mastertableview allowfilteringbycolumn="true" allowpaging="false">                          
                    <Columns>                    
                        
                        <telerik:GridTemplateColumn DataField="Subsystem" SortExpression="Subsystem" CurrentFilterFunction="Contains" 
  UniqueName="Subsystem"  AutoPostBackOnFilter="True" HeaderText="Subsystem">
                            <HeaderStyle Font-Bold="true" />
                            <HeaderTemplate>Subsystem</HeaderTemplate>
                            <ItemTemplate><%# Eval("Subsystem")%></ItemTemplate>
                        </telerik:GridTemplateColumn>

                            </Columns>
                    </mastertableview>
                    <clientsettings enablepostbackonrowclick="false" />
                </telerik:RadGrid>