"sheetsbar" property is not valid

4 posts, 0 answers
  1. ltxx
    ltxx avatar
    11 posts
    Member since:
    Oct 2015

    Posted 19 Nov 2015 Link to this post

    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?

     

     

     

  2. Alexander Popov
    Admin
    Alexander Popov avatar
    1416 posts

    Posted 23 Nov 2015 Link to this post

    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!
     
  3. Kendo UI is VS 2017 Ready
  4. ltxx
    ltxx avatar
    11 posts
    Member since:
    Oct 2015

    Posted 23 Nov 2015 in reply to Alexander Popov Link to this post

    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

    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.

  5. Alexander Popov
    Admin
    Alexander Popov avatar
    1416 posts

    Posted 25 Nov 2015 Link to this post

    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!
     
Back to Top
Kendo UI is VS 2017 Ready