We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

Custom Ribbon Tab in Spreadsheet

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


7 Replies

SK Shanmugaraja K Syncfusion Team October 4, 2017 07:29 AM UTC

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. 
 
 
Regards, 
Shanmugaraja K 



YK yogesh kumar July 5, 2019 03:08 PM UTC

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.


VK Vinoth Kumar Sundara Moorthy Syncfusion Team July 8, 2019 12:13 PM UTC

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, 
 
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 



YK yogesh kumar July 8, 2019 02:36 PM UTC

it's working fine. Thank you Vinod.


VK Vinoth Kumar Sundara Moorthy Syncfusion Team July 9, 2019 05:11 AM UTC

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 



YK yogesh kumar July 10, 2019 11:05 AM UTC

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


VK Vinoth Kumar Sundara Moorthy Syncfusion Team July 11, 2019 10:46 AM UTC

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 


Loader.
Live Chat Icon For mobile
Up arrow icon