What's New?

Gridpanel number format and showmask

  1. #1
    Aug 25, 2009, 6:51 AM

    Gridpanel number format and showmask

    I want to know how format number on gridpanel,please look below code.
    comment code cann't be used,why?

    additional,I add showmask property,but it have not any effect.

    <ext:GridPanel 
            runat="server" ID="GridPanel" 
            Width="800" Height="300" StoreID="Store1" 
            StripeRows="true" TrackMouseOver="true"> 
            <ColumnModel ID="ColumnModel1" runat="server"> 
                <Columns> 
                    <ext:Column Header="Vendor Invoice No" DataIndex="SDVINV" Width="80"> 
                    </ext:Column> 
                    <ext:Column Header="Vendor Invoice Date" DataIndex="SDVDID" Width="70"> 
                        <Renderer Fn="ConvertDate" /> 
                    </ext:Column> 
                    <ext:Column Header="Item No" DataIndex="SDITNR" Width="70"> 
                    </ext:Column> 
                    <ext:Column Header="Item Name" DataIndex="SDITDS" Width="100"> 
                    </ext:Column> 
                    <ext:Column Header="PO no + line no" DataIndex="SDPRNR" Width="120"> 
                    </ext:Column> 
                    <ext:Column Header="Delivery No" DataIndex="SDREV#" Width="80"> 
                    </ext:Column> 
                    <ext:Column Header="UOM" DataIndex="SDUMSR" Width="40"> 
                    </ext:Column> 
                    <ext:Column Header="Receiving Qty" DataIndex="SDGQTY" Width="80"> 
                        <%--<Renderer Fn="Ext.util.Format.numberRenderer('0,000')" />--%> 
                    </ext:Column> 
                    <ext:Column Header="Price(yen)" DataIndex="SDPRIC" Width="80"> 
                    </ext:Column> 
                    <ext:Column Header="Amount(yen)" DataIndex="SDGAMT" Width="80"> 
                    </ext:Column> 
                    <ext:Column Header="Packing Code" DataIndex="SDPAKC" Width="40"> 
                    </ext:Column> 
                </Columns> 
            </ColumnModel> 
            <SelectionModel> 
                <ext:RowSelectionModel ID="RowSelectionModel1" runat="server" /> 
            </SelectionModel> 
            <LoadMask ShowMask="true" /> 
            <TopBar> 
                <ext:Toolbar ID="Toolbar1" runat="server"> 
                    <Items> 
                        <ext:ToolbarFill ID="ToolbarFill1" runat="server" /> 
                        <ext:Button ID="btnToExcel" runat="server" Text="To Excel" Icon="PageExcel"> 
                            <Listeners> 
                                <Click Handler="#{GridPanel}.submitData(false);" /> 
                            </Listeners> 
                        </ext:Button> 
                    </Items> 
                </ext:Toolbar> 

            </TopBar> 
        </ext:GridPanel>
    Last edited by geoffrey.mcgill; Jul 19, 2010 at 6:48 PM. Reason: please use [code] tags
  2. #2
    Jul 19, 2010, 6:45 PM
    Hello, ling242a!

    comment code cann't be used,why?
    It seems this code is fine. Please look at this example based on yours.
    <%@ 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)
    {
        this.Store1.DataSource = new List<Company> 
         { 
             new Company(712343.729),
             new Company(29566.01645),
             new Company(83.81)
         };

        this.Store1.DataBind();
    }

    public class Company
    {
        public Company(double price)
        {
            this.Price = price;
        }
        
        public double Price { get; set; }
    }
</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 id="Head1" runat="server">
    <title></title>
</head>
<body>
    <ext:ResourceManager ID="ResourceManager1" runat="server" />
    <ext:Store ID="Store1" runat="server">
        <Reader>
            <ext:JsonReader>
                <Fields>
                    <ext:RecordField Name="Price" />
                </Fields>
            </ext:JsonReader>
        </Reader>
    </ext:Store>
    <ext:GridPanel runat="server" ID="GridPanel" Width="800" Height="300" StoreID="Store1"
        StripeRows="true" TrackMouseOver="true">
        <ColumnModel ID="ColumnModel1" runat="server">
            <Columns>
                <ext:Column Header="Receiving Qty" DataIndex="Price" Width="80">
                    <Renderer Fn="Ext.util.Format.numberRenderer('0,000')" />
                </ext:Column>
            </Columns>
        </ColumnModel>
        <SelectionModel>
            <ext:RowSelectionModel ID="RowSelectionModel1" runat="server" />
        </SelectionModel>
        <LoadMask ShowMask="true" />
        <TopBar>
            <ext:Toolbar ID="Toolbar1" runat="server">
                <Items>
                    <ext:ToolbarFill ID="ToolbarFill1" runat="server" />
                    <ext:Button ID="btnToExcel" runat="server" Text="To Excel" Icon="PageExcel">
                        <Listeners>
                            <Click Handler="#{GridPanel}.submitData(false);" />
                        </Listeners>
                    </ext:Button>
                </Items>
            </ext:Toolbar>
        </TopBar>
    </ext:GridPanel>
</body>
</html>
    Please provide me with the full code causing this issue.

    additional,I add showmask property,but it have not any effect.
    The Mask is actual if you use a Proxy of Store control different from a default Proxy (PagingMemoryProxy). It might be ScriptTagProxy, HttpProxy, etc. When a default proxy is used a Store data and a page are loaded at the same time. Please look how it works (I mean the Mask), just follow the link, for example:
    https://examples1.ext.net/#/GridPane..._File_Loading/

    P.S. Please use the [CODE] tags to wrap a code.

Similar Threads

  1. Format Number in GridPanel Template Column
    By pooja in forum 1.x Help
    Replies: 0
    Last Post: May 04, 2012, 9:43 AM
  2. FORMAT NUMBER ON A GRIDPANEL
    By marcmvc in forum 1.x Help
    Replies: 2
    Last Post: Feb 21, 2011, 9:23 AM
  3. [CLOSED] Number Format
    By majestic in forum 1.x Legacy Premium Help
    Replies: 2
    Last Post: Jan 23, 2011, 3:57 AM
  4. How to format a number with 3 decimal
    By NishaLijo in forum 1.x Help
    Replies: 1
    Last Post: Nov 24, 2010, 5:44 AM
  5. Link in Grid with format number
    By bsnezw in forum 1.x Help
    Replies: 2
    Last Post: Oct 26, 2009, 2:50 PM

Posting Permissions