Wijmo 5 [Flex Grid]
Merge Column rows based on other column value
HTML
<link rel="stylesheet" href="http://cdn.wijmo.com/5.latest/styles/wijmo.min.css">
<script src="http://cdn.wijmo.com/5.latest/controls/wijmo.min.js"></script>
<script src="http://cdn.wijmo.com/5.latest/controls/wijmo.input.min.js"></script>
<script src="http://cdn.wijmo.com/5.latest/controls/wijmo.grid.min.js"></script>
<script src="http://cdn.wijmo.com/5.latest/interop/angular/wijmo.angular.min.js"></script>
<div ng-app="app" ng-controller="appCtrl">
<h3>
Merge Column rows based on other column value
</h3>
This fiddle implement how we can merge another column row based on another column rows value
<wj-flex-grid items-source="data" cell-edit-ended="cellEditEnded(s,e)" control="flex">
</wj-flex-grid>
</div>
JavaScript
var app = angular.module('app', ['wj']);
app.controller('appCtrl', function ($scope) {
var data = [{ country: "India", id: 91 },
{ country: "US", id: 0 },
{ country: "US", id: 5 },
{ country: "US", id: 8 },
{ country: "China", id: 9 },
{ country: "UK", id: 3},
{ country: "UK", id: 4 }];
$scope.data = new wijmo.collections.CollectionView(data);
$scope.cellEditEnded = function (s,e) {
mergeColumn(s);
};
$scope.$watch('flex', function () {
if ($scope.flex) {
mergeColumn($scope.flex);
}
});
function mergeColumn(flex) {
var mrgRng = [], count = 0;
// for loop for getting range for merging column
for (var i = 0; i < flex.rows.length - 1; i++) {
}
// creating cell range based on mergernage
var mrgClRng = [];
for (var i = 0; i < mrgRng.length; i++) {
var mergeMngr = new wijmo.grid.MergeManager(flex),
clRng = new wijmo.grid.CellRange(mrgRng[i].row1, 1, mrgRng[i].row1 + mrgRng[i].count, 1);
mrgClRng.push(clRng);
}
// calling custom merge manager
mergeMngr.__proto__.getMergedRange = function (panel, r, c) {
if (panel.cellType == wijmo.grid.CellType.Cell) {
for (var i = 0; i < mrgClRng.length; i++) {
if (r >= 0 && mrgClRng[i].contains(r, c)) {
return mrgClRng[i];
}
}
}
return null;
};
flex.mergeManager = mergeMngr;
}
});