Custom Ribbon Tab in Spreadsheet

[Landy]

I cannot not find any doucmentation on creating a custom Ribbon Tab in Asp.Net MVC Spreadsheet. Is it possible?

[Shanmugaraja K]

Hi LANDRUM, 

 

Thanks for using Syncfusion products, 

 

We would like to let you know that we can achieve your requirement by using addTab client method. Please refer the below code example, 

 

[CSHTML] 

 

 

    <div class="control"> 

        @(Html.EJ().Spreadsheet<object>("Spreadsheet") 

      .ClientSideEvents(events => events.LoadComplete("loadComplete")) 

        ) 

    </div> 

    <div class="clear-fix"></div> 

    <script type="text/javascript"> 

        function loadComplete(args) { 

            var tabGroup = [{ 

                alignType: ej.Ribbon.AlignType.Rows, text: "Custom Tab Group", content: 

                [{ 

                    groups: [{ 

                        id: "new", text: "Custom", toolTip: "Cut", 

                        buttonSettings: { 

                            contentType: ej.ContentType.TextAndImage, 

                            imagePosition: ej.ImagePosition.ImageTop, 

                            prefixIcon: "e-icon e-ssr-cut", 

                            click: "executeAction" 

                        } 

                    }],  

              defaults: { type: ej.Ribbon.Type.Button, width: 60, height: 70    } 

                }] 

            }]; 

            xlObj.XLRibbon.addTab("Custom Tab", tabGroup, 2); // To add the tab in the ribbon. 

        } 

    </script> 

 

 

We have created MVC sample with these code examples and the same can be downloaded from the below location. 

 

Sample: http://www.syncfusion.com/downloads/support/forum/133003/ze/CustomTab_Spreadsheet1771268482  

UG: https://help.syncfusion.com/api/js/ejspreadsheet#methods:xlribbon-addtab  

 

Regards, 

Shanmugaraja K 

[yogesh kumar]

How to activate a tab in  ribbon by using jQuery in Spreadsheet control.

spreadsheet control has file,home,inset,pagelayout..........i want activate insert tab by default when onloadcomplete is executed.

[Vinoth Kumar Sundara Moorthy]

Hi Landrum, 

 

Good day to you. 

 

We have checked your requirement “To set insert tab in Spreadsheet ribbon as active” and it can be achieved using selectedItemIndex in Ribbon as like in the below code example, 

 

Code Example 

@(Html.EJ().Spreadsheet<object>("Spreadsheet") 

    .ClientSideEvents(events => events.LoadComplete("loadComplete")) 

)  

<script type="text/javascript"> 

    function loadComplete(args) { 

        var rObj = $("#Spreadsheet_Ribbon").data('ejRibbon'); 

        rObj.option({ selectedItemIndex: 2 }); // To set Insert Tab as active  

    } 

</script> 

 

For more details, please refer the below demo sample to set the active item in Ribbon, 

https://mvc.syncfusion.com/demos/web/ribbon/methods 

 

Could you please check the above details and get back to us with more information if you need any further assistance on this? 

 

Regards, 

Vinoth Kumar S 

[yogesh kumar]

it's working fine. Thank you Vinod.

[Vinoth Kumar Sundara Moorthy]

Hi Yogesh, 

  

Thank you for the update. We are happy to hear that your issue has been resolved. Please feel free to contact us if you need any further assistance on Syncfusion components. 

  

Regards, 

Vinoth Kumar S 

[yogesh kumar]

Hi Vinoth,

viewing an excel file in jquery based asp.net MVC spreadsheet control is not working in Internet Explorer 11.

it is showing below error message and i have attached error screenshot also.

SCRIPT438: Object doesn't support property or method 'assign'

ej.web.all.min.js (10,6295862)

Attachment: spreadsheet_2_ba5f05e.zip

[Vinoth Kumar Sundara Moorthy]

Hi Yogesh,  

  

Thank you for contacting syncfusion support.  

  

We have checked your reported issue by importing the excel file in spreadsheet and the data loaded properly in our end in IE browser. Before that we would like to know the following details to proceed further.  

  

1. Please share dummy issue replicable excel file.  

  

2. If you have done any customization in sample, please share us the code snippet.  

  

3. If possible please share us the issue replicable sample.  

  

4. Share your Essential Studio product version and IE browser details.  

  

Could you please get back to us with the above requested details? Based on that we will check and provide you a better solution quickly.  

  

Regards,  

Vinoth Kumar S