CODEWITHSUNDEEP
jqueryslickgrid
user1040259
user1040259

Reputation: 6509

SlickGrid excel type functionality - simple

Using the SlickGrid editing example to divide duration1 / duration2. Can this be done on keyup change for each row on change? 

$(function()
    {


        for (var i=0; i<500; i++) {
            var d = (data[i] = {});

            d["title"] = "Task " + i;
            d["duration1"] = "";
            d["duration2"] = "";
            d["percentComplete"] = (d["duration1"] / d["duration2"]);
            d["start"] = "01/01/2009";
            d["finish"] = "01/05/2009";
            d["effortDriven"] = (i % 5 == 0);
        }

        grid = new Slick.Grid("#myGrid", data, columns, options);

        //grid.registerPlugin(new Slick.CellRangeSelector());

        grid.setSelectionModel(new Slick.CellSelectionModel());

        grid.onAddNewRow.subscribe(function(e, args) {
            var item = args.item;
            var column = args.column;
            grid.invalidateRow(data.length);
            data.push(item);
            grid.updateRowCount();
            grid.render();
        });
    })

Upvotes: 0

Views: 582

Answers (1)

Tin
Tin

Reputation: 9082

grid.onCellChange.subscribe(function(e, args) {
  args.item["percentComplete"] = args.item["duration1"] / args.item["duration2"];
  this.updateRow(args.row);
});

Upvotes: 1

Related Questions