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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

View-only spreadsheet

Thread ID:

Created:

Updated:

Platform:

Replies:

128897 Feb 14,2017 05:37 PM UTC Feb 15,2017 12:41 PM UTC JavaScript 1
loading
Tags: ejSpreadSheet
Gabriel Axel
Asked On February 14, 2017 05:37 PM UTC

Greetings,

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?

Thanks.

Shanmugaraja K [Syncfusion]
Replied On 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, 
 
[JS] 
 
 
        $(function () { 
            $("#Spreadsheet").ejSpreadsheet({ 
                scrollSettings: 
                { 
                    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, 
 
 
Regards, 
Shanmugaraja K 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;