[CLOSED] Gropingview with locked columns almost working

  1. #1

    [CLOSED] Gropingview with locked columns almost working

    Hello

    Starting with your locked column grid example, I try to play with grouping view. The good new is that it almost works. See the code below :

    <%@ 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 = 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" }
                };
    
                this.Store1.DataBind();
            }
        }
    </script>
    
    <!DOCTYPE html>
    
    <html>
    <head id="Head1" runat="server">
        <title>GridPanel with Locking GridView - Ext.NET Examples</title>
        <link href="/resources/css/examples.css" rel="stylesheet" type="text/css" />    
    
        <script type="text/javascript">
            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 ID="ResourceManager1" runat="server" />
        
        <h1>GridPanel with Locking Columns</h1>
        
        <p>Demonstrates how to achieve "freeze pane" locking functionality similar to Excel in a GridPanel.</p>
        
        <ext:Store ID="Store1" runat="server" GroupField="company" >
            <Model>
                <ext:Model ID="Model1" 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>
    
        <ext:GridPanel 
            ID="GridPanel1"
            runat="server" 
            Title="Locking Grid" 
            AutoScroll="True"
            ColumnLines="True"
            EnableColumnMove="False"
            Width="500" 
            Height="350"
            StoreID="Store1">
            <ColumnModel ID="ColumnModel1" runat="server">
                <Columns>
                    <ext:Column ID="Column1" runat="server" Text="Company" DataIndex="company" Width="160" Locked="true" />
                    <ext:Column ID="Column2" runat="server" Text="Price" DataIndex="price" Locked="true">
                        <Renderer Format="UsMoney" />
                    </ext:Column>
                    <ext:Column ID="Column3" runat="server" Text="Change" DataIndex="change">
                        <Renderer Fn="change" />
                    </ext:Column>
                    <ext:Column ID="Column4" runat="server" Text="Change" DataIndex="pctChange">
                        <Renderer Fn="pctChange" />
                    </ext:Column>
                    <ext:DateColumn ID="DateColumn1" runat="server" Text="Last Updated" DataIndex="lastChange" />
                </Columns>
            </ColumnModel>
            <Features>
                <ext:Grouping 
                    runat="server"
                    GroupHeaderTpl='{name} ({[values.rows.length]} {[values.rows.length > 1 ? "Items" : "Item"]})'
                    StartCollapsed="false">
                </ext:Grouping>
            </Features>
        </ext:GridPanel>          
    </body>
    </html>
    The bad thing is that colpased works only on locked columns and not on the others. Will it be very difficult to make it works?
    Last edited by Daniil; Apr 25, 2012 at 2:37 PM. Reason: [CLOSED]
  2. #2
    Hi,

    Unfortunately, it won't work.
    http://www.sencha.com/forum/showthread.php?189663

    Here is some interesting thread.
    http://www.sencha.com/forum/showthread.php?143568

    But, personally, I would not try to get it working.
  3. #3
    Arf.. Too bad, I saw a plugin on Ext.js that manage this behaviour, but as I work with Ext.NET, I have no try to use it.

    By the way, I think I will abandon grouping feature to manage data in an other way, so, at this moment, I will locked my columns.

    Thanks to answer.
  4. #4
    What is the plugin?

    Generally, I've tried many ExtJS plugins with Ext.NET with success, but not all.
  5. #5
    I thought I have found it in the addon parts of Sencha site when looking for adding title in charts, but in fact no, I think now, that I have dreamed that exists. Sorry.
  6. #6
    Ok, thanks for the clarification.

Similar Threads

  1. Template Columns not working
    By QualityCode in forum 1.x Help
    Replies: 3
    Last Post: Apr 24, 2012, 8:38 AM
  2. [CLOSED] Get the locked view from gridpanel
    By leon_tang in forum 1.x Premium Help
    Replies: 2
    Last Post: Apr 06, 2011, 3:21 PM
  3. [CLOSED] Locked ImageCommand Column
    By paulc in forum 1.x Premium Help
    Replies: 5
    Last Post: Feb 24, 2011, 12:08 PM
  4. [CLOSED] Locked column and row alignment
    By Stefanaccio in forum 1.x Premium Help
    Replies: 2
    Last Post: Oct 20, 2010, 12:14 PM
  5. Replies: 1
    Last Post: May 12, 2010, 4:41 PM

Posting Permissions