This is a migrated thread and some comments may be shown as answers.

"sheetsbar" property is not valid

3 Answers 75 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
ltxx
Top achievements
Rank 1
ltxx asked on 19 Nov 2015, 06:00 AM

I have two questions: 

(1)when I set "sheetsbar" property is 'false', but the sheetsbar is still visible at the bottom. How can I solve this problem?

(2)Addtionally, I want to have only one sheet in the spreadsheet at the same time, i.e., remove the "insert sheet" function. What should I do?

 

 

 

3 Answers, 1 is accepted

Sort by
0
Alexander Popov
Telerik team
answered on 23 Nov 2015, 08:16 AM
Hello,

I tried reproducing the behavior described in your first point, however everything seems to work as expected. Would you please check this example and let me know if I am missing something?
Regarding your second question - disabling the insertSheet method however is not supported out of the box, although removing the sheets bar should prevent the users from adding more than one sheet.

Regards,
Alexander Popov
Telerik
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
0
ltxx
Top achievements
Rank 1
answered on 24 Nov 2015, 01:53 AM

[quote]Alexander Popov said:Hello,

I tried reproducing the behavior described in your first point, however everything seems to work as expected. Would you please check this example and let me know if I am missing something?
Regarding your second question - disabling the insertSheet method however is not supported out of the box, although removing the sheets bar should prevent the users from adding more than one sheet.

Regards,
Alexander Popov
Telerik

[/quote]

For the first question, I checked your example, It is OK! After trying to test, I found the cau

<!DOCTYPE html>
<html>
<head>
    <style>html { font-size: 14px; font-family: Arial, Helvetica, sans-serif; }</style>
    <title></title>
 
</head>
<body>
<div id="example">
    <div id="spreadsheet" style="width: 100%"></div>
    <script>
        $(function() {
            var crudServiceBaseUrl = "http://demos.telerik.com/kendo-ui/service";
 
            var dataSource = new kendo.data.DataSource({
                transport: {
                    read:  {
                        url: crudServiceBaseUrl + "/Products",
                        dataType: "jsonp"
                    },
                },
                schema: {
                    model: {
                        id: "ProductID"
                    }
                }
            });
 
            $("#spreadsheet").kendoSpreadsheet({
                columns: 20,
                rows: 100,
                toolbar: false,
                sheetsbar: false,
                sheets: [{
                    name: "Products",
                    dataSource: dataSource,
                    rows: [{
                        height: 40,
                        cells: [
                        {
                            bold: "true",
                            background: "#9c27b0",
                            textAlign: "center",
                            color: "white"
                        },{
                            bold: "true",
                            background: "#9c27b0",
                            textAlign: "center",
                            color: "white"
                        },{
                            bold: "true",
                            background: "#9c27b0",
                            textAlign: "center",
                            color: "white"
                        },{
                            bold: "true",
                            background: "#9c27b0",
                            textAlign: "center",
                            color: "white"
                        },{
                            bold: "true",
                            background: "#9c27b0",
                            textAlign: "center",
                            color: "white"
                        }]
                    }],
                    columns: [
                        { width: 100 },
                        { width: 415 },
                        { width: 145 },
                        { width: 145 },
                        { width: 145 }
                    ]
                }]
            });
    });
    </script>
</div>
 
 
</body>
</html>
se of the problem. My kendoUI version is "2015.3.930", while your version "2015.3.1111". In your example, replace your kendo.all.min.js  by “http://kendo.cdn.telerik.com/2015.3.930/js/kendo.all.min.js”, the behavior described will be appeared.

0
Alexander Popov
Telerik team
answered on 25 Nov 2015, 01:16 PM
Hi,

Thank you for clarifying.
Indeed, the sheetsbar is not being hidden when the older version of Kendo UI is used. The Spreadsheet is a new widget, and this issue among others is fixed in the 2015 Q3 SP1 release, so I would suggest upgrading.

Regards,
Alexander Popov
Telerik
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
Tags
Spreadsheet
Asked by
ltxx
Top achievements
Rank 1
Answers by
Alexander Popov
Telerik team
ltxx
Top achievements
Rank 1
Share this question
or