Create function for populate

[newerton]

This popular feature table dynamically with new values.

var sheetData = [
        [1,1,1,0,1,0,1,1,1,1,1,0,1,1,1,0,0,0,0,0,0,0,0,0],
        [0,1,0,0,1,0,1,0,1,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0],
        [0,1,0,0,1,0,1,0,1,0,1,0,1,1,1,0,0,0,0,0,0,0,0,0],
        [0,1,0,0,1,0,1,0,1,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0],
        [0,1,0,0,1,0,1,0,1,0,1,0,1,1,1,0,0,0,0,0,0,0,0,0],
        [0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],
        [1,1,1,0,1,0,1,0,1,1,1,0,1,1,1,0,1,1,1,0,0,0,0,0],
        [1,0,0,0,1,0,1,0,1,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0],
        [1,1,1,0,1,1,1,0,1,1,1,0,1,1,1,0,0,1,0,0,0,0,0,0],
        [0,0,1,0,1,0,1,0,1,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0],
        [1,1,1,0,1,0,1,0,1,1,1,0,1,1,1,0,0,1,0,0,0,0,0,0],
        [0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
    ];

sheet.setSheetData(sheetData);

[lbbc1117]

@newerton
Sorry I don't get this one

[newerton]

@lbbc1117
I did a primary adaptation! :)

var CSheet = function (opt) {
...
    this.setSheetData = function (cellIndex) {
        var rowCount = cellIndex.length;
        var colCount = cellIndex[0] ? cellIndex[0].length : 0;
        var settingArea;

        for (var row = 0; row < rowCount; ++row) {
            for (var col = 0; col < colCount; ++col) {
                if (cellIndex[row][col] === 1) {
                    settingArea = {
                        startCell: [row, col],
                        endCell: [row, col]
                    };
                    sheetPrivate.areaOperate(settingArea, {type: "set", state: 1});
                }
            }
        }
    };
...
}
...
var publicAPI = {
...
    setSheetData: function (cellIndex) {
        sheetModel.setSheetData(cellIndex);
        removeSelecting();
        repaintSheet();
        return;
    },
...
};

 var sheetData = [
    [1,1,1,0,1,0,1,1,1,1,1,0,1,1,1,0,0,0,0,0,0,0,0,0],
    [0,1,0,0,1,0,1,0,1,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0],
    [0,1,0,0,1,0,1,0,1,0,1,0,1,1,1,0,0,0,0,0,0,0,0,0],
    [0,1,0,0,1,0,1,0,1,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0],
    [0,1,0,0,1,0,1,0,1,0,1,0,1,1,1,0,0,0,0,0,0,0,0,0],
    [0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],
    [1,1,1,0,1,0,1,0,1,1,1,0,1,1,1,0,1,1,1,0,0,0,0,0],
    [1,0,0,0,1,0,1,0,1,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0],
    [1,1,1,0,1,1,1,0,1,1,1,0,1,1,1,0,0,1,0,0,0,0,0,0],
    [0,0,1,0,1,0,1,0,1,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0],
    [1,1,1,0,1,0,1,0,1,1,1,0,1,1,1,0,0,1,0,0,0,0,0,0],
    [0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
];

$('#J_timingPopulate').click(function(){
    sheet.setSheetData(sheetData);
});

[lbbc1117]

@newerton
Yeah right. A dynamic data setter for all cells.

[newerton]

@lbbc1117
It would be great to create a function to add 1 cell.

setSheetCell([2,3]);
setSheetCell([8,1]);

[lbbc1117]

@newerton
Good advices friend. As I'm busy learning deep learning recently, I may do some modification if I get time.