[CLOSED] GridPanel hide/show columns

  1. #1

    [CLOSED] GridPanel hide/show columns

    Can I hide/show columns in a GridPanel during a direct method. If so what is the correct approach?

    I am current calling a directmethod to repopulate my GridPanels store. During that call I am also deciding to hide or show certain columns based on the data. The GridPanel is updated with the new data and the columns are hidden/shown, but the columns are not appropriately fit within the GridPanel.

    How can I ask the GridPanel to resize its columns?
    Last edited by Daniil; Dec 04, 2015 at 7:08 AM. Reason: [CLOSED]
  2. #2
    Hi Chris,

    Setting a Column's Hidden property should be good enough.
    https://examples2.ext.net/#/GridPane...Configuration/

    What approach do you use?

    but the columns are not appropriately fit within the GridPanel
    I would assume everything should be okay after showing/hiding columns and, maybe, we are dealing with an issue.

    May I have a look at a test case?

    How can I ask the GridPanel to resize its columns?
    Maybe, App.GridPanel1.doLayout(), but I am not sure.
  3. #3
    Sorry for not getting back Daniil, I have been performing a lot of data analysis this past week. It turns out that my problem was I was hiding the flex column. Once I verified that hide/show should work via Javascript, DirectEvent and/or DirectMethod I looked at my code again and found the problem.

    Below is the test case that showed how to hide/show columns via different calls. Thanks again.

    <%@ 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();
            }
        }
    
        protected void TogglePrice(object sender, DirectEventArgs e)
        {
            //Ext.Net.Button button = sender as Ext.Net.Button;
            //this.GridPanel1.ColumnModel.Columns[1].Hidden = button.Pressed;
            //PriceColumn.Hidden = button.Pressed;
            //button.Text = button.Pressed ? "Show Price (SERVER)" : "Hide Price (SERVER)";
            PriceColumn.Hidden = TogglePriceBtn.Pressed;
            TogglePriceBtn.Text = TogglePriceBtn.Pressed ? "Show Price (DirectEvent)" : "Hide Price (DirectEvent)";
        }
    
        [DirectMethod]
        public void ToggleDate()
        {
            //this.GridPanel1.ColumnModel.Columns[4].Hidden = ToggleDateBtn.Pressed;
            LastChangeColumn.Hidden = ToggleDateBtn.Pressed;
            ToggleDateBtn.Text = ToggleDateBtn.Pressed ? "Show Date (DirectMethod)" : "Hide Date (DirectMethod)";
        }
    </script>
    
    <!DOCTYPE html>
    
    <html>
    <head runat="server">
        <title>Simple Array Grid - Ext.NET Examples</title>
        <link href="/resources/css/examples.css" rel="stylesheet" />
    
        <script>
            var toggleChange = function (btn) {
    
                if (btn.pressed) {
                    btn.setText('Show Change (JavaScript)')
                    App.ChangeColumn.hide();
                }
                else {
                    btn.setText('Hide Change (JavaScript)')
                    App.ChangeColumn.show();
                }
            }
    
            var toggleDate = function (btn) {
                App.direct.ToggleDate();
            }
    
        </script>
    
    </head>
    <body>
        <form runat="server">
            <ext:ResourceManager runat="server" />
    
            <h1>Columns model ajax operation</h1>
    
            <ext:GridPanel
                ID="GridPanel1"
                runat="server"
                Title="Array Grid"
                Width="600"
                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 ID="CompanyColumn" runat="server" Text="Company" Width="160" DataIndex="company"
                            Flex="1" />
                        <ext:Column ID="PriceColumn" runat="server" ClientIDMode="Static" Text="Price" Width="75"
                            DataIndex="price">
                            <Renderer Format="UsMoney" />
                        </ext:Column>
                        <ext:Column ID="ChangeColumn" runat="server" ClientIDMode="Static" Text="Change"
                            Width="75" DataIndex="change" />
                        <ext:Column ID="ChangePrtColumn" runat="server" Text="Change %" Width="75" DataIndex="pctChange" />
                        <ext:DateColumn ID="LastChangeColumn" runat="server" Text="Last Updated" Width="85"
                            DataIndex="lastChange" />
                    </Columns>
                </ColumnModel>
                <SelectionModel>
                    <ext:RowSelectionModel runat="server" Mode="Single" />
                </SelectionModel>
                <View>
                    <ext:GridView runat="server" StripeRows="true" TrackOver="true" />
                </View>
                <BottomBar>
                    <ext:Toolbar runat="server">
                        <Items>
                            <ext:ToolbarFill runat="server" />
                            <ext:Button ID="TogglePriceBtn" runat="server" Text="Hide 'Price' (DirectEvent)"
                                EnableToggle="true" OnDirectClick="TogglePrice" />
                            <ext:Button runat="server" Text="Hide 'Change' (JavaScript)" EnableToggle="true">
                                <Listeners>
                                    <Click Fn="toggleChange" />
                                </Listeners>
                            </ext:Button>
                            <ext:Button ID="ToggleDateBtn" runat="server" Text="Hide 'Date' (DirectMethod)" EnableToggle="true">
                                <Listeners>
                                    <Click Fn="toggleDate" />
                                </Listeners>
                            </ext:Button>
                        </Items>
                    </ext:Toolbar>
                </BottomBar>
            </ext:GridPanel>
        </form>
    </body>
    </html>
  4. #4
    Thank you for the follow-up and sharing the sample!
  5. #5
    You may close the thread.

Similar Threads

  1. Show or hide columns in a GridPanel.
    By Lisseth in forum 1.x Help
    Replies: 2
    Last Post: Jun 09, 2015, 5:08 PM
  2. [CLOSED] GridPanel columns Show/Hide Handler
    By vadym.f in forum 1.x Legacy Premium Help
    Replies: 1
    Last Post: Mar 06, 2013, 3:20 PM
  3. GridPanel Hide/Show Columns
    By vs.mukesh in forum 1.x Help
    Replies: 1
    Last Post: Oct 30, 2010, 4:29 PM
  4. [CLOSED] Show/hide GridPanel columns during DirectEvent
    By jmcantrell in forum 1.x Legacy Premium Help
    Replies: 1
    Last Post: Sep 20, 2010, 8:51 PM
  5. [CLOSED] Show/Hide grid columns
    By GmServizi in forum 1.x Legacy Premium Help
    Replies: 6
    Last Post: Mar 28, 2010, 6:39 AM

Posting Permissions