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.
Unfortunately, activation email could not send to your email. Please try again.

View-only spreadsheet

Thread ID:

Created:

Updated:

Platform:

Replies:

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

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 07:41 AM

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.

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.

;