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
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
Rank 1
[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> <base href="http://demos.telerik.com/kendo-ui/spreadsheet/datasource"> <style>html { font-size: 14px; font-family: Arial, Helvetica, sans-serif; }</style> <title></title> <link rel="stylesheet" href="http://kendo.cdn.telerik.com/2015.3.1111/styles/kendo.common-material.min.css" /> <link rel="stylesheet" href="http://kendo.cdn.telerik.com/2015.3.1111/styles/kendo.material.min.css" /> <script src="http://kendo.cdn.telerik.com/2015.3.1111/js/jquery.min.js"></script> <script src="http://kendo.cdn.telerik.com/2015.3.1111/js/jszip.min.js"></script> <script src="http://kendo.cdn.telerik.com/2015.3.930/js/kendo.all.min.js"></script></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>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