Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
280
what is this? why is express "#VALUE!" ??
posted

my source code

    protected void Button3_Click(object sender, EventArgs e)
    {

        UltraWebGrid1.Bands[0].Columns.Add("Total", "ba_ulimit * 5 = ?");
        Infragistics.WebUI.UltraWebGrid.UltraGridColumn c = UltraWebGrid1.Bands[0].Columns.FromKey("Total");
        c.DataType = "System.Double";
        c.Format = "C";
        c.Formula = " [ba_ulimit] * 5 ";
        c.Width = Unit.Pixel(150);
        c.CellStyle.HorizontalAlign = HorizontalAlign.Right;

        // set up footer summaries for total column
        c.Footer.Key = "Total";
        c.Footer.Caption = "Total = ";
        c.Footer.Total = Infragistics.WebUI.UltraWebGrid.SummaryInfo.Sum;
        c.Footer.Formula = "ROUND(SUM([Total]),2)";

        // set up footer summaries for the Unit Price column
        c = UltraWebGrid1.Bands[0].Columns.FromKey("ba_ulimit");
        c.Width = Unit.Pixel(150);
        //c.Header.Caption = "ba_ulimit Value";
        c.CellStyle.HorizontalAlign = HorizontalAlign.Right;
        c.AllowUpdate = Infragistics.WebUI.UltraWebGrid.AllowUpdate.Yes;
        //c.Format = "###,###,###.00";

        Infragistics.WebUI.UltraWebGrid.ColumnFooter cf = c.Footer;
        cf.Key = "ba_bcode";
        cf.Caption = "ba_bcode value = ";
        cf.Total = Infragistics.WebUI.UltraWebGrid.SummaryInfo.Avg;
        cf.Formula = "ROUND(SUM([ba_bcode]),2)";


        // Allow for footers to be visible
        Infragistics.WebUI.UltraWebGrid.UltraGridBand b = UltraWebGrid1.Bands[0];
        b.ColFootersVisible = Infragistics.WebUI.UltraWebGrid.ShowMarginInfo.Yes;

    }

what is  "#VALUE!" ?

i do .. File attachment  PNG pic.

i don't know. help me plz ^^

 

 

Parents
No Data
Reply
  • 8680
    posted

    hardmanii said:
    what is  "#VALUE!" ?

    It usually means that the expression you are using to generate the value you are trying to display is generating an invalid value.  I'd start by looking for "divide by zero", type mismatches, etc.

Children