[CLOSED] locking grid view in right side?

  1. #1

    [CLOSED] locking grid view in right side?

    could it possible lock column in right side of gridpanel?

    <ext:GridPanel 
                        ID="MainGridPanel" 
                        runat="server" 
                        StripeRows="true" 
                        Header="false" 
                        Title="Title"
                        TrackMouseOver="true" 
                        Height="800" 
                        StoreID="MainStore">
                         <ColumnModel ID="ColumnModel1" runat="server">
                             <Columns>
                                 <ext:RowNumbererColumn />
                                 <ext:Column ColumnID="HOCODE" Header="HOCODE" DataIndex="HOCODE" Hidden="true" />
                                 <ext:Column ColumnID="Reference" Header="Reference" DataIndex="Reference" Width="120" />
                                 <ext:Column ColumnID="Date" Header="Date" DataIndex="Date" Width="100" />
                                 <ext:Column ColumnID="Project" Header="Project Name" DataIndex="Project" Width="120">
                                     <Commands>
                                         <ext:ImageCommand CommandName="cmdProject" Icon="TableMultiple" />
                                     </Commands>
                                 </ext:Column>
                                 <ext:Column ColumnID="Category" Header="Category" DataIndex="Category" Width="120">
                                     <Commands>
                                         <ext:ImageCommand CommandName="cmdCategory" Icon="TableMultiple"/>
                                     </Commands>
                                 </ext:Column>
                                 <ext:Column ColumnID="Department" Header="Department" DataIndex="Department" Width="120">
                                     <Commands>
                                         <ext:ImageCommand CommandName="cmdDepartment" Icon="TableMultiple"  />
                                     </Commands>
                                 </ext:Column>
                                 <ext:Column ColumnID="StartTime" Header="Start Time" DataIndex="StartTime" Width="100">
                                  <Commands>
                                         <ext:ImageCommand CommandName="cmdStartTime" Icon="Clock" />
                                     </Commands>
                                 </ext:Column>
                                 <ext:Column ColumnID="EndTime" Header="End Time" DataIndex="EndTime" Width="100">
                                  <Commands>
                                         <ext:ImageCommand CommandName="cmdEndrtTime" Icon="Clock" />
                                     </Commands>
                                 </ext:Column>
                                 <ext:Column ColumnID="Hours" Header="Hours" DataIndex="Hours" Width="120" Align="Right" />
                                 <ext:Column ColumnID="RateType" Header="Rate Type" DataIndex="RateType" Width="120">
                                     <Commands>
                                         <ext:ImageCommand CommandName="cmdRateType" Icon="CalculatorEdit"  />
                                     </Commands>
                                 </ext:Column>
                                 <ext:Column ColumnID="Function" Header="Function" DataIndex="Function" Width="120">
                                     <Commands>
                                         <ext:ImageCommand CommandName="cmdFunction" Icon="TableEdit"  />
                                     </Commands>
                                 </ext:Column>
                                 <ext:Column ColumnID="Notes" Header="Notes" DataIndex="Notes" Width="160">
                                     <Commands>
                                         <ext:ImageCommand CommandName="cmdNotes" Icon="NoteEdit"  />
                                     </Commands>
                                 </ext:Column>
                                 <ext:CheckColumn ColumnID="ReChargeable" Header="ReChargeable" Width="120" />
                                 <ext:CheckColumn ColumnID="CreditSalaryAccount" Header="Credit Salary Account"  Width="140" />
                                 <ext:Column ColumnID="Client" Header="Client" DataIndex="Client" Width="140">
                                     <Commands>
                                         <ext:ImageCommand CommandName="cmdClient" Icon="TableEdit"    />
                                     </Commands>
                                 </ext:Column>
                                 <ext:Column ColumnID="Rate" Header="Rate" DataIndex="Rate" Width="100"   Align="Right"/>
                                 <ext:Column ColumnID="Amount" Header="Total"  Width="100"   Align="Right"  Locked="true"/>
                                 <ext:Column ColumnID="ChargingStatus" Header="Charging Status"  Width="120" Align="Right"  Locked="true">
                                     <Commands>
                                         <ext:ImageCommand CommandName="cmdChargingStatus" Icon="TableMultiple"   />
                                     </Commands>
                                 </ext:Column>
                                 <ext:Column ColumnID="Status" Header="Status"  Width="120" Align="Right" Locked="true">
                                     <Commands>
                                         <ext:ImageCommand CommandName="cmdStatus" Icon="TableMultiple" />
                                     </Commands>
                                 </ext:Column>
                             </Columns>
                         </ColumnModel>
                         <View>
                            <ext:LockingGridView runat="server" />
                         </View>
                         <BottomBar>
                             <ext:PagingToolbar ID="PagingToolbar2" runat="server" PageSize="25" StoreID="MainStore" />
                         </BottomBar>
                     </ext:GridPanel>
    Last edited by geoffrey.mcgill; Sep 21, 2010 at 9:34 PM. Reason: [CLOSED]
  2. #2
    Hi,

    Please see the following sample
    <%@ 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.GridPanel1.Store.Primary.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.GridPanel1.Store.Primary.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>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 String.format(template, (value > 0) ? "green" : "red", value);
            };
    
            var pctChange = function (value) {
                return String.format(template, (value > 0) ? "green" : "red", value + "%");
            };
            
            var swapViews = function (){
                this.view.lockedWrap.dom.style.right = "0px";
                this.view.mainWrap.dom.style.left = "0px";
                this.view.updateLockedWidth = this.view.updateLockedWidth.createSequence(function(){
                    this.view.mainWrap.dom.style.left = "0px";
                }, this);            
            };
        </script>
    </head>
    <body>
        <ext:ResourceManager runat="server" />
        
        <h1>GridPanel with Locking GridView</h1>
        
        <p>Demonstrates how to achieve "freeze pane" locking functionality similar to Excel in a GridPanel by using the LockingGridView Component.</p>
        
        <ext:GridPanel 
            ID="GridPanel1"
            runat="server" 
            StripeRows="true"
            Title="Locking Grid" 
            TrackMouseOver="true"
            Width="500" 
            Height="350">
            <Store>
                <ext:Store runat="server">
                    <Reader>
                        <ext:ArrayReader>
                            <Fields>
                                <ext:RecordField Name="company" />
                                <ext:RecordField Name="price" Type="Float" />
                                <ext:RecordField Name="change" Type="Float" />
                                <ext:RecordField Name="pctChange" Type="Float" />
                                <ext:RecordField Name="lastChange" Type="Date" DateFormat="M/d hh:mmtt" />
                            </Fields>
                        </ext:ArrayReader>
                    </Reader>
                </ext:Store>
            </Store>
            <ColumnModel runat="server">
                <Columns>
                    <ext:Column ColumnID="Company" Header="Company" DataIndex="company" Width="160" Locked="true" />
                    <ext:Column Header="Price" DataIndex="price">
                        <Renderer Format="UsMoney" />
                    </ext:Column>
                    <ext:Column Header="Change" DataIndex="change">
                        <Renderer Fn="change" />
                    </ext:Column>
                    <ext:Column Header="Change" DataIndex="pctChange">
                        <Renderer Fn="pctChange" />
                    </ext:Column>
                    <ext:DateColumn Header="Last Updated" DataIndex="lastChange" />
                </Columns>
            </ColumnModel>
            <SelectionModel>
                <ext:RowSelectionModel runat="server" SingleSelect="true" />
            </SelectionModel>
            <View>
                <ext:LockingGridView runat="server">
                </ext:LockingGridView>
            </View>
            
            <Listeners>
                <ViewReady Handler="swapViews.call(this);" />
            </Listeners>
        </ext:GridPanel>          
    </body>
    </html>
  3. #3
    Hi vladimir,

    Thank you for your time, this is better solution... what we are looking for

    thanx.

    NOTE : Solved.
  4. #4
    I did follow the example on this page LockingGridView but I get an error:

    Error : Invalid Argument

    It points to the updateLockedWidth function. Line is : this.scroller.dom.style.width = vw;

    Any ideas?

Similar Threads

  1. Replies: 7
    Last Post: Mar 27, 2013, 6:07 AM
  2. [CLOSED] Locking Grid with RowExpander plugin
    By leon_tang in forum 1.x Legacy Premium Help
    Replies: 1
    Last Post: Feb 23, 2011, 2:37 PM
  3. [CLOSED] Locking Grid and AddColumn
    By paulc in forum 1.x Legacy Premium Help
    Replies: 1
    Last Post: Feb 23, 2011, 11:05 AM
  4. [CLOSED] [1.0] Locking Grid View JavaScript Error
    By jskibo in forum 1.x Legacy Premium Help
    Replies: 4
    Last Post: Jun 01, 2010, 11:09 PM

Tags for this Thread

Posting Permissions