Styling Multiple sheets

  1. I am working on multiple sheets . I want to style them like background color , border. How it can be done. As my all sheets are dynamic , values to spreadsheet are coming from database. here I am sharing my code for json array which I am passing to webix UI.

2.Also, How to disable or change only 2 columns of the sheet to readonly. I don't want user to enter anything to these 2 columns. Following is my json array.

var data= {
sheets: [
{
name: "Tab_1",
content:{

                            data:[
                            [1,1,"ID","disable:true"],
                            [1,2,"Value 1"],
                            [1,3,"Value 2"],
                            [1,4,"Result"],
                            <?php 
                            $r=2;
                            foreach($arr as $record){
                                echo "[".$r.",1,". $record['ID']."],";
                                echo "[".$r.",2,". $record['value1']."],";
                                echo "[".$r.",3,". $record['value2']."],";
                                echo '['.$r.',4,'. $record['result'].'],';
                                $r++;   
                            }   ?>]
                        }
                    },
                    {
                        name: "Tab_2",
                        content:{
                            data:[
                                [1,1,"7"],
                                [1,2,"8"],
                                [1,3,"=a1+b1"]
                            ]
                        }
                    },
                    {
                        name: "Tab_3",
                        content:{
                            data:[
                                [1,1,"20"]
                            ]
                        }
                    }
                ]
            };
Tagged:

Comments

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion