View-only spreadsheet

[Gabriel Axel]

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]

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, 

 

http://jsplayground.syncfusion.com/0ran0tqs  

 

Regards, 

Shanmugaraja K