[CLOSED] Gridpanel Filter column and Header Group

  1. #1

    [CLOSED] Gridpanel Filter column and Header Group

    I'm implementing the both examples in my app

    this https://examples1.ext.net/#/GridPane...Header/Filter/ and this
    https://examples1.ext.net/#/GridPane...mnHeaderGroup/

    But my grid appears weird, as you can see in the image bellow.

    How can I configure the grid to appear something like that.

    Fisrt line: GroupHeader
    Second Line: columns name
    Third line: filters

    There is a way to combine the both examples?

    Click image for larger version. 

Name:	groupHeaders.png 
Views:	693 
Size:	47.3 KB 
ID:	5546

    Code to reproduce this issue.

    <%@ Page Language="C#" %>
    
    <%@ Import Namespace="System.Collections.Generic" %>
    <%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>
    <script runat="server">
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!X.IsAjaxRequest)
            {
                var cities = new object[] { "Beijing", "Tokyo", "Berlin", "London" };
    
                var products = new string[] { "ProductX", "ProductY" };
                var grid = GridPanel1;
                var view = grid.View[0];
                var store = grid.Store[0];
                var cm = grid.ColumnModel;
                var cityGroupRow = new HeaderGroupRow();
                var data = new object[5];
                var random = new Random();
                var headerRow = new HeaderRow();
                view.ID = "gridView";
    
                view.HeaderGroupRows.Add(cityGroupRow);
                view.HeaderRows.Add(headerRow);
    
                foreach (string city in cities)
                {
                    cityGroupRow.Columns.Add(new HeaderGroupColumn
                    {
                        Header = city,
                        ColSpan = products.Length,
                        Align = Alignment.Center
                    });
                }
    
                for (int i = 0; i < 8; i++)
                {
                    store.Reader[0].Fields.Add("column" + i, RecordFieldType.Int);
    
                    Column col = new Column
                    {
                        Header = "Column " + i,
                    };
    
                    cm.Columns.Add(col);
    
                    headerRow.Columns.Add(new HeaderColumn
                    {
                        Component = { new TextField { ID = "txt" + i } }
                    });
                }
    
                for (int i = 0; i < 5; i++)
                {
    
                    var arr = new int[8];
    
                    for (int j = 0; j < 8; j++)
                    {
                        arr[j] = Convert.ToInt32((Math.Floor(random.NextDouble() * 11) + 1) * 100000);
                    }
    
                    data[i] = arr;
                }
    
                store.DataSource = data;
                store.DataBind();
            }
        }
    </script>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
        "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head runat="server">
        <title>Grid Column Header Grouping - Ext.NET Examples</title>
        <link href="../../../../resources/css/examples.css" rel="stylesheet" type="text/css" />
    </head>
    <body>
        <ext:ResourceManager runat="server" />
        <h1>
            Grid Column Header Grouping Example</h1>
        <p>
            This example shows how to achieve column grouping using a plugin.</p>
        <ext:GridPanel ID="GridPanel1" runat="server" StripeRows="true" Title="Sales By Region"
            TrackMouseOver="true" Width="1000" Height="400">
            <Store>
                <ext:Store runat="server">
                    <Reader>
                        <ext:ArrayReader />
                    </Reader>
                </ext:Store>
            </Store>
            <SelectionModel>
                <ext:RowSelectionModel runat="server" />
            </SelectionModel>
            <View>
                <ext:GridView runat="server" ForceFit="true" />
            </View>
        </ext:GridPanel>
    </body>
    </html>
    Last edited by Daniil; Feb 06, 2013 at 5:37 AM. Reason: [CLOSED]
  2. #2
    Hello!

    It seems that these solutions were not designed to be used together.

    However, we are investigating.
  3. #3
    Hello everybody,

    I can confirm, they are not designed to be able to combine them.

    Here is a related thread.
    http://forums.ext.net/showthread.php...ll=1#post45377

    By the way, it is possible with Ext.NET v2 and it looks well with a minor CSS tweak.

    Example
    <%@ Page Language="C#" %>
    
    <%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>
    
    <script runat="server">
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!X.IsAjaxRequest)
            {
                this.Store1.DataSource = this.Data;
                this.Store1.DataBind();
            }
        }
    
        private object[] Data
        {
            get
            {
                return new object[]
                {
                    new object[] { "3m Co", 71.72, 0.02, 0.03, "9/1 12:00am" },
                    new object[] { "Alcoa Inc", 29.01, 0.42, 1.47, "9/1 12:00am" },
                    new object[] { "Altria Group Inc", 83.81, 0.28, 0.34, "9/1 12:00am" },
                    new object[] { "American Express Company", 52.55, 0.01, 0.02, "9/1 12:00am" },
                    new object[] { "American International Group, Inc.", 64.13, 0.31, 0.49, "9/1 12:00am" },
                    new object[] { "AT&T Inc.", 31.61, -0.48, -1.54, "9/1 12:00am" },
                    new object[] { "Boeing Co.", 75.43, 0.53, 0.71, "9/1 12:00am" },
                    new object[] { "Caterpillar Inc.", 67.27, 0.92, 1.39, "9/1 12:00am" },
                    new object[] { "Citigroup, Inc.", 49.37, 0.02, 0.04, "9/1 12:00am" },
                    new object[] { "E.I. du Pont de Nemours and Company", 40.48, 0.51, 1.28, "9/1 12:00am" },
                    new object[] { "Exxon Mobil Corp", 68.1, -0.43, -0.64, "9/1 12:00am" },
                    new object[] { "General Electric Company", 34.14, -0.08, -0.23, "9/1 12:00am" },
                    new object[] { "General Motors Corporation", 30.27, 1.09, 3.74, "9/1 12:00am" },
                    new object[] { "Hewlett-Packard Co.", 36.53, -0.03, -0.08, "9/1 12:00am" },
                    new object[] { "Honeywell Intl Inc", 38.77, 0.05, 0.13, "9/1 12:00am" },
                    new object[] { "Intel Corporation", 19.88, 0.31, 1.58, "9/1 12:00am" },
                    new object[] { "International Business Machines", 81.41, 0.44, 0.54, "9/1 12:00am" },
                    new object[] { "Johnson & Johnson", 64.72, 0.06, 0.09, "9/1 12:00am" },
                    new object[] { "JP Morgan & Chase & Co", 45.73, 0.07, 0.15, "9/1 12:00am" },
                    new object[] { "McDonald\"s Corporation", 36.76, 0.86, 2.40, "9/1 12:00am" },
                    new object[] { "Merck & Co., Inc.", 40.96, 0.41, 1.01, "9/1 12:00am" },
                    new object[] { "Microsoft Corporation", 25.84, 0.14, 0.54, "9/1 12:00am" },
                    new object[] { "Pfizer Inc", 27.96, 0.4, 1.45, "9/1 12:00am" },
                    new object[] { "The Coca-Cola Company", 45.07, 0.26, 0.58, "9/1 12:00am" },
                    new object[] { "The Home Depot, Inc.", 34.64, 0.35, 1.02, "9/1 12:00am" },
                    new object[] { "The Procter & Gamble Company", 61.91, 0.01, 0.02, "9/1 12:00am" },
                    new object[] { "United Technologies Corporation", 63.26, 0.55, 0.88, "9/1 12:00am" },
                    new object[] { "Verizon Communications", 35.57, 0.39, 1.11, "9/1 12:00am" },
                    new object[] { "Wal-Mart Stores, Inc.", 45.45, 0.73, 1.63, "9/1 12:00am" }
                };
            }
        }
    </script>
    
    <!DOCTYPE html>
    
    <html>
    <head runat="server">
        <title>Ext.NET v2 Example</title>
        
        <style>
            /* style rows on mouseover */
            .x-grid-row-over .x-grid-cell-inner {
                font-weight: bold;
            }
    
            .my-header .x-box-inner {
                margin-top: 23px;
            }
        </style>
    
        <script>
            var template = '<span style="color:{0};">{1}</span>';
    
            var change = function (value) {
                return Ext.String.format(template, (value > 0) ? "green" : "red", value);
            };
    
            var pctChange = function (value) {
                return Ext.String.format(template, (value > 0) ? "green" : "red", value + "%");
            };
        </script>
    </head>
    <body>
        <ext:ResourceManager runat="server" />
        
        <h1>Grouped Header Example</h1>
        <p>This example shows how to create a grid with column headers which are nested within category headers.</p>
        <p>Category headers do not reference Model fields via a <code>dataIndex</code>, rather they contain
        child header definitions (which may themselves either contain a <code>dataIndex</code> or more levels of headers).</p>
        
        <ext:GridPanel 
            ID="GridPanel1"
            runat="server" 
            Title="Grouped Header Grid" 
            Width="600" 
            ColumnLines="true"
            Height="350">
            <Store>
                <ext:Store ID="Store1" runat="server">
                    <Model>
                        <ext:Model runat="server">
                            <Fields>
                                <ext:ModelField Name="company" />
                                <ext:ModelField Name="price" Type="Float" />
                                <ext:ModelField Name="change" Type="Float" />
                                <ext:ModelField Name="pctChange" Type="Float" />
                                <ext:ModelField Name="lastChange" Type="Date" DateFormat="M/d hh:mmtt" />
                            </Fields>
                        </ext:Model>
                    </Model>
                </ext:Store>
            </Store>
            <ColumnModel runat="server">
                <Columns>
                    <ext:Column 
                        runat="server" 
                        Text="Company" 
                        DataIndex="company" 
                        Flex="1" 
                        Sortable="false" 
                        Cls="my-header">
                        <HeaderItems>
                            <ext:TextField runat="server" />
                        </HeaderItems>
                    </ext:Column>
    
                    <ext:Column runat="server" Text="Stock Price">
                        <Columns>
                            <ext:Column 
                                runat="server" 
                                Text="Price" 
                                DataIndex="price" 
                                Width="75" 
                                Sortable="true">
                                <HeaderItems>
                                    <ext:TextField runat="server" />
                                </HeaderItems>
                                <Renderer Format="UsMoney" />
                            </ext:Column>
                            <ext:Column 
                                runat="server" 
                                Text="Change" 
                                DataIndex="change" 
                                Width="75" 
                                Sortable="true">
                                <HeaderItems>
                                    <ext:TextField runat="server" />
                                </HeaderItems>
                                <Renderer Fn="change" />
                            </ext:Column>
                            <ext:Column 
                                runat="server" 
                                Text="Change %" 
                                DataIndex="pctChange" 
                                Width="75" 
                                Sortable="true">
                                <HeaderItems>
                                    <ext:TextField runat="server" />
                                </HeaderItems>
                                <Renderer Fn="pctChange" />
                            </ext:Column>
                        </Columns>
                    </ext:Column>                
                    
                    <ext:DateColumn 
                        runat="server" 
                        Text="Last Updated" 
                        DataIndex="lastChange" 
                        Width="85" 
                        Sortable="true" 
                        Format="dd/MM/yyyy" 
                        Cls="my-header">
                        <HeaderItems>
                            <ext:TextField runat="server" />
                        </HeaderItems>
                    </ext:DateColumn>
                </Columns>
            </ColumnModel>
        </ext:GridPanel>
    </body>
    </html>
  4. #4
    Hi Daniil.
    Hi Baidaly.

    Thanks again for the answers.

    Quote Originally Posted by Daniil View Post
    By the way, it is possible with Ext.NET v2 and it looks well with a minor CSS tweak.
    I'll update to version 2

    []'S

Similar Threads

  1. [FIXED] [1.6] Header Group Column layout bug
    By ascsolutions in forum Bugs
    Replies: 11
    Last Post: Aug 30, 2012, 12:20 PM
  2. Replies: 8
    Last Post: Sep 13, 2011, 8:47 PM
  3. [CLOSED] Change text in header group column.
    By pdcase in forum 1.x Legacy Premium Help
    Replies: 4
    Last Post: Mar 09, 2011, 3:44 PM
  4. [CLOSED] [1.0] Grid column header group - span multiple rows
    By Neil_Walters in forum 1.x Legacy Premium Help
    Replies: 3
    Last Post: Jan 14, 2011, 11:11 PM
  5. Replies: 3
    Last Post: Aug 13, 2010, 4:25 PM

Posting Permissions