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

View-only spreadsheet


I'm trying to implement a view-only spreadsheet. I used the following configurations:

showRibbon: false,
allowFormulaBar: false,
allowEditing: false,
enableContextMenu: false,

and I'm missing how to prevent adding new sheets using the circled plus icon in the sheets tabs bar and how to prevent dragging images and charts. How can I disable these?


1 Reply

SK Shanmugaraja K Syncfusion Team February 15, 2017 12:41 PM UTC

Hi Gabriel, 
Thanks for using Syncfusion products, 
We have checked your requirement and we suggest you to set “allowInsert” as false, to prevent adding new sheets and use dragShape client side event then set args.cancel as false to disable chart and image dragging. Please refer the below code examples, 
        $(function () { 
                    width: "100%", 
                    height: 470, 
                    isResponsive: true 
                showRibbon: false, 
                allowFormulaBar: false, 
                allowEditing: false, 
                enableContextMenu: false, 
                allowInsert: false, 
                dragShape: "onDragShape" 
        function onDragShape(args) { 
            args.cancel = true; // to disable shape(chart, picture) dragging.  
We have demonstrated this in js playground. Please refer the below link for further details, 
Shanmugaraja K 

Live Chat Icon For mobile
Up arrow icon