Wijmo 5 [Flex Grid]

Merge Column rows based on other column value

by Manish Gupta

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)" child-items-path="abc"  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++) {
                    if (flex.rows[i].dataItem.country == flex.rows[i + 1].dataItem.country) {
                        count++;
                        var isContain = false;
                        for (var j = 0; j < mrgRng.length; j++) {
                            if (mrgRng[j].country == flex.rows[i].dataItem.country) {
                                mrgRng[j].count = count;
                                isContain = true;
                            }
                        }
                        if (!isContain) {
                            mrgRng.push({ row1: i, country: flex.rows[i].dataItem.country, count: count });
                        }

                    }
                    else {
                        count = 0;
                    }
                }

                // 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...