[FIXED] [#1491] [4.3.0] Jump Grids and Oddity

  1. #1

    [FIXED] [#1491] [4.3.0] Jump Grids and Oddity

    I update my example to show the complexity of our grids.
    Simply load this up (IE11). Then grab the scroll bar, drag to the bottom and let go. You will find that the screen "jumps" back up and down.

    Then try to click on any of the editable combo boxes and then it goes crazy and scrolls up an down, and then chooses a cell.

    it is really odd!
    please help. it is better on v3 but i have problems on v3. now that i am moving to v4, i need to get this resolved.
    Thanks,
    /Z

    <%@ Page Language="C#" %>
    
    
    <script runat="server">
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!X.IsAjaxRequest)
            {
                Stt.DataSource = new object[]
                {
                    new object[] { 1, "test1"},
                    new object[] { 2, "test2"},
                    new object[] { 3, "test3"},
                    new object[] { 4, "test4"},
                    new object[] { 5, "test5"},
                    new object[] { 6, "test6"}
                };
    
    
                Stt.DataBind();
                
                this.GridPanel1.Store.Primary.DataSource = new object[]
                {
                    new object[] { "[9/1/2017 2:00a] 3m777", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:00a]666 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:05550a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 4442:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2033317 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1222/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[1119/1/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:00a] jkl3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:00hjka] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2ghj:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/201fgh7 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/dfg2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9sdf/1/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "asd[9/1/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:00a] 3ppm", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:00a]oo 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:00iia] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:uu00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 yy2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/201tt7 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2rr017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1ee/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9ww/1/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "qq[9/1/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:00a] 3..m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:00a],, 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:00mma] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2nnn:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017bb 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/20vv17 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/cc2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/xx1/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[zz9/1/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:00a]i 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:00au] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:00ya] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:0t0a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:r00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2e:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 w2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/201qw7 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/20m17 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2n017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/b2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1v/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/c1/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9x/1/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[z9/1/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/201lc7 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/20k17 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2j017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/h2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1g/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/f1/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9d/1/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[s9/1/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "a[9/1/2017 2:00a] 38m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:00a] 73m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:00a]6 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:00a5] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:004a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:030a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:200a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 21:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 -2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/20170 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/20197 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/20817 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/27017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/62017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/15/20127 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/41/20127 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[93/1/20127 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[92/1/20127 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[19/1/20127 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[19/134/20127 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:900a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:800a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:700a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:600a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:500a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:400a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:300a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:200a] 3m", "[9/1/2017 2:00] 3m",29.01, 0.42, 1.47, new DateTime(2017, 9, 1, 8, 0, 0) },
                    new object[] { "[9/1/2017 2:100a] 3m", "[9/1/2017 2:00] 3m", 83.81, 0.28, 0.34, new DateTime(2017, 9, 1, 14, 0, 0) },
                    new object[] { "[9/1/2017 8:00a] Starbucks","[9/1/2017 8:00] Starbucks", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 8:00a] Starbucks","[9/1/2017 8:00] Starbucks", 29.01, 0.42, 1.47, new DateTime(2017, 9, 1, 8, 0, 0) },
                    new object[] { "[9/1/2017 8:00a] Starbucks","[9/1/2017 8:00] Starbucks", 83.81, 0.28, 0.34, new DateTime(2017, 9, 1, 14, 0, 0) },
                    new object[] { "[9/1/2017 2:00p] Home Depot","[9/1/2017 14:00] Home Depot", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
                    new object[] { "[9/1/2017 2:00p] Home Depot","[9/1/2017 14:00] Home Depot", 29.01, 0.42, 1.47, new DateTime(2017, 9, 1, 8, 0, 0) },
                    new object[] { "[9/1/2017 2:00p] Home Depot","[9/1/2017 14:00] Home Depot", 83.81, 0.28, 0.34, new DateTime(2017, 9, 1, 14, 0, 0) }
                };
    
    
                this.GridPanel1.Store.Primary.DataBind();
            }
        }
    </script>
    
    
    <!DOCTYPE html>
    
    
    <html>
    <head id="Head2" runat="server">
        <title>GridPanel with Locking Columns - Ext.NET Examples</title>
        <link href="/resources/css/examples.css" rel="stylesheet" />
    
    
        <script>
            // this "setGroupStyle" function is called when the GroupingView is refreshed.     
            var setGroupStyle = function (view) {
                var colors = ['olive', 'orange', 'purple', 'red', 'blue', 'fuchsia', 'gray', 'green', 'maroon', 'navy', 'silver', 'teal', 'black']
                // get an instance of the Groups
                var groups = view.el.query(App.groupRoster.eventSelector);
    
    
                for (var i = 0; i < groups.length; i++) {
                    // Set the "background-color" of the original Group node.
                    Ext.get(groups[i]).parent().select('.x-grid-group-hd').setStyle("background-color", colors[i % colors.length]);
                }
            };
    
    
            var count = 0;
            var template = '<span style="color:{0};">{1}</span>';
    
    
            var change = function (value) {
                return Ext.String.format(template, (value > 0) ? "green" : "red", value);
            };
    
    
            var editRecordComplete = function (editor, context) {
                var store = context.grid.getStore();
                var record = context.record;
            };
    
    
    
    
            var pctChange = function (value) {
                return Ext.String.format(template, (value > 0) ? "green" : "red", value + "%");
            };
    
    
            var alertResponsehift = function (curSelection) {
                count = 4;
                curSelection.beginEdit();
                curSelection.set('price', 1);
                curSelection.endEdit();
            };
    
    
            var myRenderer = function (value, metaData, record, rowIndex, colIndex, store) {
                var result = "";
                for (i = 0; i < count; i++) {
                    result += "<div><span>TEST</span><BR/></div>";
                }
                return result;
            };
    
    
            var commandHandler = function (cmd, record, obj, grid) {
                alertResponsehift(record);
            };
        </script>
    </head>
    <body>
    
    
            <ext:Store ID="Stt" runat="server" AutoLoad="true">
                <Model>
                    <ext:Model ID="Model1" IDProperty="id" runat="server">
                        <Fields>
                            <ext:ModelField Name="id" />
                            <ext:ModelField Name="description" />
                        </Fields>
                    </ext:Model>
                </Model>
            </ext:Store>
        <ext:ResourceManager ID="ResourceManager2" runat="server" />
    
    
            <ext:Viewport ID="Viewport1" runat="server" Layout="VBoxLayout">          
                <LayoutConfig>
                    <ext:VBoxLayoutConfig Align="Stretch" />
                </LayoutConfig>
                <Items>
    
    
    
    
                <ext:GridPanel
                    ID="GridPanel1"
         runat="server"
                        TitleCollapse="true"
                        LeadingBufferZone="5"
                        TrailingBufferZone="5"
                        ColumnLines="true"
                        ContextMenuID="MenuRightClickMasterSchedule"
                        Flex="1">
    
    
                    <Store>
                        <ext:Store ID="Store2" runat="server" PageSize="3000">
                            <Model>
                                <ext:Model ID="Model2" runat="server">
                                    <Fields>
                                        <ext:ModelField Name="company" />
                                        <ext:ModelField Name="companySort" />
                                        <ext:ModelField Name="price" Type="Float" />
                                        <ext:ModelField Name="change" Type="Float" />
                                        <ext:ModelField Name="pctChange" Type="Float" />
                                        <ext:ModelField Name="lastChange" Type="Date" />
                                    </Fields>
                                </ext:Model>
                            </Model>
                            <Grouper Property="company" SortProperty="company" Direction="ASC" />
                            <Sorters>
                                <ext:DataSorter Property="lastChange" Direction="DESC" />
                            </Sorters>
                        </ext:Store>
                    </Store>
                    <Plugins>
                        <ext:CellEditing ID="CellEditing1" ClicksToEdit="1" runat="server">
                            <Listeners>
                                <Edit Fn="editRecordComplete"  />
                            </Listeners>
                        </ext:CellEditing>
                    </Plugins>
                    <View>
                        <ext:GridView ID="GridView1" runat="server">
                            <Listeners>
                                <Refresh Fn="setGroupStyle" />
                                <ViewReady Handler="this.on('scroll', setGroupStyle, this, { buffer: 50 });" />
                            </Listeners>
                        </ext:GridView>
                    </View>
                    <Features>
                        <ext:GroupingSummary 
                            ID="groupRoster" 
                            runat="server" 
                            GroupHeaderTplString='<span style="color:white">{name} ({[values.rows.length]} {[values.rows.length > 1 ? "Employees" : "Employee"]})</span>'
                            HideGroupedHeader="true" 
                            EnableGroupingMenu="true" 
                            StartCollapsed="false">
                        </ext:GroupingSummary>
                    </Features>
    
    
                    <ColumnModel>
                        <Columns>
                            <ext:RowNumbererColumn Locked="true" ID="RowNumbererColumn1" runat="server" Width="30" />
                            <ext:Column Locked="true" ID="Column5" runat="server" Text="Company<br>Name" DataIndex="company" Width="200" Sortable="false" />
                            <ext:Column ID="Column8" Locked="true" runat="server" Text="% Change" DataIndex="pctChange" Width="125">
                                <Renderer Fn="pctChange" />
                            </ext:Column>
                            <ext:Column ID="Column1" Locked="true" DataIndex="lastChange" Text="Date" runat="server" Width="50"/>
                            <ext:Column ID="stset" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="test1"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column2" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox1"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column3" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox2"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column4" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox3"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column6" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox4"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column7" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox5"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column9" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox6"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column10" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox7"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column11" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox8"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column12" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox9"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column13" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox10"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column14" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox11"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column15" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox12"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column16" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox13"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column17" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox14"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column18" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox15"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column19" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox16"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column20" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox17"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column21" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox18"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column22" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox19"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column23" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox20"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column24" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox21"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column25" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox22"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column26" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox23"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column27" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox24"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column28" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox25"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column29" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox26"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column30" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox27"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column31" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox28"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column32" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox29"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column33" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox30"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                        </Columns>
                    </ColumnModel>
                </ext:GridPanel>
                    </Items>
                </ext:Viewport>
    </body>
    </html>
  2. #2
    Hello @Z! By reading the first few lines of your message I'm pretty confident that you are not using Ext.NET 4.2.1 nor latest sources from github.

    Please confirm that, a bug very similar to this has been handled on GridPanel Vertical Scrollbar Resets When Clicking Horizontal Scrollbar.
    Fabrício Murta
    Developer & Support Expert
  3. #3
    You are correct!

    i am using v4.2.0. However, it appears the v4.2.1 build is broken.

    I will post a new thread on that since it is a new issue.

    thanks!
  4. #4
    Hello @Z! Thanks for making the separate thread. We already handled that and you should be able to get rid of the issue reported here.
    Fabrício Murta
    Developer & Support Expert
  5. #5
    ok, installed 4.2.1 and now i tested on 4.2.1. the fix fails for locking grids..

    I did the testing. a regular editable grid works. a locking grid is badly broken still.

    load up the example. then scroll ALL the way to the bottom. then click any cell (non-locked editable combo). watch it jump to the left and the headers and cells will be misaligned.

    now reload it. scroll to the bottom (hold let mouse entire way and release at bottom). then hold mouse and scroll back to the middle somewhere. release the mouse. then scroll to the right and click anywhere on the editable combos. watch it jump like crazy.

    I tested all browsers and it is a bug on all of them. in some, i cant even scroll down, it just jumps up and down. this is a critical issue for us.

    Thanks,
    /Z


    <%@ Page Language="C#" %>
    
    
    <script runat="server">
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!X.IsAjaxRequest)
            {
                Stt.DataSource = new object[]
                {
                    new object[] { 1, "test1"},
                    new object[] { 2, "test2"},
                    new object[] { 3, "test3"},
                    new object[] { 4, "test4"},
                    new object[] { 5, "test5"},
                    new object[] { 6, "test6"}
                };
    
    
                Stt.DataBind();
                
                this.GridPanel1.Store.Primary.DataSource = new object[]
                {
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) },
    new object[] { "1","1", 71.72, 0.02, 0.03, new DateTime(2017, 9, 1, 2, 0, 0) }
    
    
    
    
                };
    
    
                this.GridPanel1.Store.Primary.DataBind();
            }
        }
    </script>
    
    
    <!DOCTYPE html>
    
    
    <html>
    <head id="Head2" runat="server">
        <title>GridPanel with Locking Columns - Ext.NET Examples</title>
        <link href="/resources/css/examples.css" rel="stylesheet" />
    
    
        <script>
            // this "setGroupStyle" function is called when the GroupingView is refreshed.     
            var setGroupStyle = function (view) {
                var colors = ['olive', 'orange', 'purple', 'red', 'blue', 'fuchsia', 'gray', 'green', 'maroon', 'navy', 'silver', 'teal', 'black']
                // get an instance of the Groups
                var groups = view.el.query(App.groupRoster.eventSelector);
    
    
                for (var i = 0; i < groups.length; i++) {
                    // Set the "background-color" of the original Group node.
                    Ext.get(groups[i]).parent().select('.x-grid-group-hd').setStyle("background-color", colors[i % colors.length]);
                }
            };
    
    
            var count = 0;
            var template = '<span style="color:{0};">{1}</span>';
    
    
            var change = function (value) {
                return Ext.String.format(template, (value > 0) ? "green" : "red", value);
            };
    
    
            var editRecordComplete = function (editor, context) {
                var store = context.grid.getStore();
                var record = context.record;
            };
    
    
    
    
            var pctChange = function (value) {
                return Ext.String.format(template, (value > 0) ? "green" : "red", value + "%");
            };
    
    
            var alertResponsehift = function (curSelection) {
                count = 4;
                curSelection.beginEdit();
                curSelection.set('price', 1);
                curSelection.endEdit();
            };
    
    
            var myRenderer = function (value, metaData, record, rowIndex, colIndex, store) {
                var result = "";
                for (i = 0; i < count; i++) {
                    result += "<div><span>TEST</span><BR/></div>";
                }
                return result;
            };
    
    
            var commandHandler = function (cmd, record, obj, grid) {
                alertResponsehift(record);
            };
        </script>
    </head>
    <body>
    
    
            <ext:Store ID="Stt" runat="server" AutoLoad="true">
                <Model>
                    <ext:Model ID="Model1" IDProperty="id" runat="server">
                        <Fields>
                            <ext:ModelField Name="id" />
                            <ext:ModelField Name="description" />
                        </Fields>
                    </ext:Model>
                </Model>
            </ext:Store>
        <ext:ResourceManager ID="ResourceManager2" runat="server" />
    
    
            <ext:Viewport ID="Viewport1" runat="server" Layout="VBoxLayout">          
                <LayoutConfig>
                    <ext:VBoxLayoutConfig Align="Stretch" />
                </LayoutConfig>
                <Items>
    
    
    
    
                <ext:GridPanel
                    ID="GridPanel1"
         runat="server"
                        TitleCollapse="true"
                        LeadingBufferZone="5"
                        TrailingBufferZone="5"
                        ColumnLines="true"
                        ContextMenuID="MenuRightClickMasterSchedule"
                        Flex="1">
    
    
                    <Store>
                        <ext:Store ID="Store2" runat="server" PageSize="3000">
                            <Model>
                                <ext:Model ID="Model2" runat="server">
                                    <Fields>
                                        <ext:ModelField Name="company" />
                                        <ext:ModelField Name="companySort" />
                                        <ext:ModelField Name="price" Type="Float" />
                                        <ext:ModelField Name="change" Type="Float" />
                                        <ext:ModelField Name="pctChange" Type="Float" />
                                        <ext:ModelField Name="lastChange" Type="Date" />
                                    </Fields>
                                </ext:Model>
                            </Model>
                            <Grouper Property="company" SortProperty="company" Direction="ASC" />
                            <Sorters>
                                <ext:DataSorter Property="lastChange" Direction="DESC" />
                            </Sorters>
                        </ext:Store>
                    </Store>
                    <Plugins>
                        <ext:CellEditing ID="CellEditing1" ClicksToEdit="1" runat="server">
                            <Listeners>
                                <Edit Fn="editRecordComplete"  />
                            </Listeners>
                        </ext:CellEditing>
                    </Plugins>
                    <View>
                        <ext:GridView ID="GridView1" runat="server">
                            <Listeners>
                                <Refresh Fn="setGroupStyle" />
                                <ViewReady Handler="this.on('scroll', setGroupStyle, this, { buffer: 50 });" />
                            </Listeners>
                        </ext:GridView>
                    </View>
                    <Features>
                        <ext:GroupingSummary 
                            ID="groupRoster" 
                            runat="server" 
                            GroupHeaderTplString='<span style="color:white">{name} ({[values.rows.length]} {[values.rows.length > 1 ? "Employees" : "Employee"]})</span>'
                            HideGroupedHeader="true" 
                            EnableGroupingMenu="true" 
                            StartCollapsed="false">
                        </ext:GroupingSummary>
                    </Features>
    
    
                    <ColumnModel>
                        <Columns>
                            <ext:RowNumbererColumn  ID="RowNumbererColumn1" runat="server" Width="30" Locked="true" />
                            <ext:Column  ID="Column5" runat="server" Text="Company<br>Name" DataIndex="company" Locked="true" Width="200" Sortable="false" />
                            <ext:Column ID="Column8"  runat="server" Text="% Change" DataIndex="pctChange" Locked="true" Width="125">
                                <Renderer Fn="pctChange" />
                            </ext:Column>
                            <ext:Column ID="Column1"  Locked="true" DataIndex="lastChange" Text="Date" runat="server" Width="50"/>
                            <ext:Column ID="stset" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="test1"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column2" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox1"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column3" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox2"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column4" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox3"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column6" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox4"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column7" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox5"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column9" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox6"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column10" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox7"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column11" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox8"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column12" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox9"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column13" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox10"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column14" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox11"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column15" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox12"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column16" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox13"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column17" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox14"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column18" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox15"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column19" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox16"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column20" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox17"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column21" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox18"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column22" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox19"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column23" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox20"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column24" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox21"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column25" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox22"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column26" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox23"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column27" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox24"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column28" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox25"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column29" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox26"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column30" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox27"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column31" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox28"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column32" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox29"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column33" runat="server">
                                <Editor>
                                    <ext:ComboBox runat="server"
                                        ID="ComboBox30"
                                        ValueField="id"
                                        DisplayField="description"
                                        QueryMode="Local"
                                        >
                                        <Items>
                                            <ext:ListItem Text="test1" Value="tes1"/>
                                            <ext:ListItem Text="test2" Value="tes2"/>
                                            <ext:ListItem Text="test3" Value="tes3"/>
                                            <ext:ListItem Text="test4" Value="tes4"/>
                                        </Items>
                                    </ext:ComboBox>
                                </Editor>
                            </ext:Column>
                        </Columns>
                    </ColumnModel>
                </ext:GridPanel>
                    </Items>
                </ext:Viewport>
    </body>
    </html>
    Last edited by Z; Jun 04, 2017 at 6:00 AM.
  6. #6
    Hello @Z!

    I have simplified your test case to this:

    <%@ Page Language="C#" %>
    
    <script runat="server">
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!X.IsAjaxRequest)
            {
                this.GridPanel1.Store.Primary.DataSource = Enumerable.Range(0, 100).Select(i => new object[]
                {
                    "Company " + i,
                    "Company Sort" + i,
                    i + 700.0 / 10,
                    (i + 5.1)/100,
                    (i + 6.5)/100,
                    (new DateTime(2017, 9, 1, 2, 0, 0)).AddDays(i)
                });
    
                this.GridPanel1.Store.Primary.DataBind();
            }
        }
    </script>
    
    <!DOCTYPE html>
    
    <html>
    <head id="Head2" runat="server">
        <title>61941 - Vertical scroll reset on edit</title>
    </head>
    <body>
        <ext:ResourceManager ID="ResourceManager2" runat="server" />
    
        <ext:Viewport ID="Viewport1" runat="server" Layout="VBoxLayout">
            <LayoutConfig>
                <ext:VBoxLayoutConfig Align="Stretch" />
            </LayoutConfig>
            <Items>
                <%-- If the grid is buffered, it will scroll back and will not render the rows there, showing a blank grid. --%>
                <ext:GridPanel
                    ID="GridPanel1"
                    runat="server"
                    BufferedRenderer="false"
                    ColumnLines="true"
                    Flex="1">
                    <TopBar>
                        <ext:Toolbar runat="server" Vertical="true">
                            <Items>
                                <ext:Toolbar runat="server" Padding="0" Margin="0">
                                    <Items>
                                        <ext:Component runat="server" Html="Vertical scroll reset: Scroll down and edit an unlocked column: " MarginSpec="0 10 0 0" />
                                        <ext:Button runat="server" Text="Scroll down" Handler="App.GridPanel1.scrollable.scrollTo(undefined, -1); App.BtnEdit.enable();" Padding="0" MarginSpec="0 10 0 0" />
                                        <ext:Button ID="BtnEdit" runat="server" Text="Trigger edit" Disabled="true" Handler="App.CellEditing1.startEdit(95, 4); App.InformationalText.setHtml('Scroll down with mouse wheel to see the editor in the row 94.');" Padding="0" />
                                        <ext:Component ID="InformationalText" runat="server" MarginSpec="0 0 0 10" />
                                    </Items>
                                </ext:Toolbar>
                                <ext:Toolbar runat="server" Padding="0" Margin="0">
                                    <Items>
                                        <ext:Component runat="server" Html="Column misalignment: edit a far-right (yet visible) cell: " MarginSpec="0 10 0 0" />
                                        <ext:Button ID="Button1" runat="server" Text="Trigger edit" Handler="App.CellEditing1.startEdit(2, 5);" Padding="0" />
                                    </Items>
                                </ext:Toolbar>
                            </Items>
                        </ext:Toolbar>
                    </TopBar>
                    <Store>
                        <ext:Store runat="server">
                            <Model>
                                <ext:Model runat="server">
                                    <Fields>
                                        <ext:ModelField Name="company" />
                                        <ext:ModelField Name="companySort" />
                                        <ext:ModelField Name="price" Type="Float" />
                                        <ext:ModelField Name="change" Type="Float" />
                                        <ext:ModelField Name="pctChange" Type="Float" />
                                        <ext:ModelField Name="lastChange" Type="Date" />
                                    </Fields>
                                </ext:Model>
                            </Model>
                        </ext:Store>
                    </Store>
                    <Plugins>
                        <ext:CellEditing ID="CellEditing1" runat="server" />
                    </Plugins>
                    <ColumnModel>
                        <Columns>
                            <ext:RowNumbererColumn runat="server" Width="30" Locked="true" />
                            <ext:Column runat="server" Text="Company<br>Name" DataIndex="company" Locked="true" Width="200" Sortable="false" />
                            <ext:Column runat="server" Text="% Change" DataIndex="pctChange" Locked="true" Width="125" />
                            <ext:Column Locked="true" DataIndex="lastChange" Text="Date" runat="server" Width="50" />
                            <ext:Column runat="server" Text="Column stset" Width="500">
                                <Editor>
                                    <ext:ComboBox runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column runat="server" Text="Column 2" Width="600">
                                <Editor>
                                    <ext:ComboBox runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox runat="server" />
                                </Editor>
                            </ext:Column>
                        </Columns>
                    </ColumnModel>
                </ext:GridPanel>
            </Items>
        </ext:Viewport>
    </body>
    </html>
    Can you confirm you can reproduce both issues you described (scrollbar reset and columns misalignment) in this test case?
    Last edited by fabricio.murta; Jun 04, 2017 at 8:53 AM.
  7. #7
    yeah. that basically does it. i increased rows from 100 to 400 and increased number of columns since that is more like my code.
    /Z



    <%@ Page Language="C#" %>
    
    
    <script runat="server">
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!X.IsAjaxRequest)
            {
                this.GridPanel1.Store.Primary.DataSource = Enumerable.Range(0, 400).Select(i => new object[]
                {
                    "Company " + i,
                    "Company Sort" + i,
                    i + 700.0 / 10,
                    (i + 5.1)/100,
                    (i + 6.5)/100,
                    (new DateTime(2017, 9, 1, 2, 0, 0)).AddDays(i)
                });
    
    
                this.GridPanel1.Store.Primary.DataBind();
            }
        }
    </script>
    
    
    <!DOCTYPE html>
    
    
    <html>
    <head id="Head2" runat="server">
        <title>61941 - Vertical scroll reset on edit</title>
    </head>
    <body>
        <ext:ResourceManager ID="ResourceManager2" runat="server" />
    
    
        <ext:Viewport ID="Viewport1" runat="server" Layout="VBoxLayout">
            <LayoutConfig>
                <ext:VBoxLayoutConfig Align="Stretch" />
            </LayoutConfig>
            <Items>
                <%-- If the grid is buffered, it will scroll back and will not render the rows there, showing a blank grid. --%>
                <ext:GridPanel
                    ID="GridPanel1"
                    runat="server"
                    BufferedRenderer="false"
                    ColumnLines="true"
                    Flex="1">
                    <TopBar>
                        <ext:Toolbar ID="Toolbar1" runat="server" Vertical="true">
                            <Items>
                                <ext:Toolbar ID="Toolbar2" runat="server" Padding="0" Margin="0">
                                    <Items>
                                        <ext:Component ID="Component1" runat="server" Html="Vertical scroll reset: Scroll down and edit an unlocked column: " MarginSpec="0 10 0 0" />
                                        <ext:Button ID="Button1" runat="server" Text="Scroll down" Handler="App.GridPanel1.scrollable.scrollTo(undefined, -1); App.BtnEdit.enable();" Padding="0" MarginSpec="0 10 0 0" />
                                        <ext:Button ID="BtnEdit" runat="server" Text="Trigger edit" Disabled="true" Handler="App.CellEditing1.startEdit(95, 4); App.InformationalText.setHtml('Scroll down with mouse wheel to see the editor in the row 94.');" Padding="0" />
                                        <ext:Component ID="InformationalText" runat="server" MarginSpec="0 0 0 10" />
                                    </Items>
                                </ext:Toolbar>
                                <ext:Toolbar ID="Toolbar3" runat="server" Padding="0" Margin="0">
                                    <Items>
                                        <ext:Component ID="Component2" runat="server" Html="Column misalignment: edit a far-right (yet visible) cell: " MarginSpec="0 10 0 0" />
                                        <ext:Button ID="Button2" runat="server" Text="Trigger edit" Handler="App.CellEditing1.startEdit(2, 5);" Padding="0" />
                                    </Items>
                                </ext:Toolbar>
                            </Items>
                        </ext:Toolbar>
                    </TopBar>
                    <Store>
                        <ext:Store ID="Store1" runat="server">
                            <Model>
                                <ext:Model ID="Model1" runat="server">
                                    <Fields>
                                        <ext:ModelField Name="company" />
                                        <ext:ModelField Name="companySort" />
                                        <ext:ModelField Name="price" Type="Float" />
                                        <ext:ModelField Name="change" Type="Float" />
                                        <ext:ModelField Name="pctChange" Type="Float" />
                                        <ext:ModelField Name="lastChange" Type="Date" />
                                    </Fields>
                                </ext:Model>
                            </Model>
                        </ext:Store>
                    </Store>
                    <Plugins>
                        <ext:CellEditing ID="CellEditing1" runat="server" ClicksToEdit="1" />
                    </Plugins>
                    <ColumnModel>
                        <Columns>
                            <ext:RowNumbererColumn ID="RowNumbererColumn1" runat="server" Width="30" Locked="true" />
                            <ext:Column ID="Column1" runat="server" Text="Company<br>Name" DataIndex="company" Locked="true" Width="200" Sortable="false" />
                            <ext:Column ID="Column2" runat="server" Text="% Change" DataIndex="pctChange" Locked="true" Width="125" />
                            <ext:Column ID="Column3" Locked="true" DataIndex="lastChange" Text="Date" runat="server" Width="50" />
                            <ext:Column ID="Column4" runat="server" Text="Column stset" Width="500">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox1" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column5" runat="server" Text="Column 2" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox2" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column6" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox3" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column7" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox4" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column8" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox5" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column9" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox6" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column10" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox7" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column11" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox8" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column12" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox9" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column13" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox10" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column14" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox11" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column15" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox12" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column16" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox13" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column17" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox14" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column18" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox15" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column19" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox16" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column20" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox17" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column21" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox18" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column22" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox19" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column23" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox20" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column24" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox21" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column25" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox22" runat="server" />
                                </Editor>
                            </ext:Column>
                            <ext:Column ID="Column26" runat="server" Text="Column 3" Width="600">
                                <Editor>
                                    <ext:ComboBox ID="ComboBox23" runat="server" />
                                </Editor>
                            </ext:Column>
                        </Columns>
                    </ColumnModel>
                </ext:GridPanel>
            </Items>
        </ext:Viewport>
    </body>
    </html>
  8. #8
    Hello @Z!

    Thanks for your feedback! We've just logged the issue as #1491 and also fixed it. The latest Ext.NET from our github repository should work fine for you now. In fact, I've just tried your "huge-ified" version of the example and it also works!

    Interesting, compare your "huge-ified" code running with and without BufferedRenderer (it currently isn't as you can read in line 46). The performance difference is really noticeable.

    Hope you appreciate the news!
    Fabrício Murta
    Developer & Support Expert
  9. #9
    Verified fixed
  10. #10
    Hello @Z!

    Thank you very much for your feedback and for reporting the issue! We're thrilled that the fix applied resolved the issue on your end!
    Fabrício Murta
    Developer & Support Expert

Similar Threads

  1. [CLOSED] Jump to grid row with paging
    By CanopiusApplications in forum 2.x Legacy Premium Help
    Replies: 2
    Last Post: Jan 20, 2014, 8:48 AM
  2. [CLOSED] GridPanel header group text oddity
    By rthiney in forum 2.x Legacy Premium Help
    Replies: 4
    Last Post: Dec 13, 2013, 6:22 PM
  3. How do press Enter key jump like Tab?
    By whs2893 in forum 1.x Help
    Replies: 6
    Last Post: Mar 23, 2011, 3:07 AM
  4. [CLOSED] ext confirmation oddity after (since yesterday)
    By dev in forum 1.x Legacy Premium Help
    Replies: 3
    Last Post: Aug 12, 2010, 9:46 AM
  5. Replies: 1
    Last Post: Mar 09, 2010, 2:27 PM

Posting Permissions