BadFormad DataFormatString "{0:0.##}" + " %" C1GridView 2025v2 399

BadFormad DataFormatString "{0:0.##}" + " %" C1GridView 2025v2 399

Posted by: enrique.pv-ext on 21 May 2026, 10:40 am EST

• 

  enrique.pv-ext

  • Post Options:
  • Link
    Copy

  Posted 21 May 2026, 10:40 am EST

  Hi,
  
  Migrate from 2010v1 to 2025v2 399 in ASP.NET WebForms NET Framework 4.8.1.
  
  Using C1GridView from C1.Web.Wijmo.Controls.48.dll

  DataFormatString = "{0:0.##}" + " %";

  My code:

      f = new C1BoundField();
      f = GetC1BoundField(210, (string)this._textsShown[5], "P", "P", TableItemStyle);
      f.DataFormatString = "{0:0.##}" + " %";
      f.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
      C1GridView1.Columns.Add(f);

  f.DataFormatString = “{0:#,##0}”;
  
  can be n0 or c2

  Any suggestions for “{0:0.##}” + " %"; ?

• 

  uttkarsh.matiyal

  

  • Post Options:
  • Link
    Copy

  Posted 22 May 2026, 3:31 am EST

  Hello Enrique,

  It seems that you want to format numerical values as percentages. If so, you can use the “p” format specifier. It works similarly to “n” or “c”, but is specifically used for percentage formatting.

  Please note that when a numerical value is formatted using “p”, it is automatically multiplied by 100 before the ‘%’ symbol is applied.

  Sample: GridView_PercentFormat.zip

  Regards,
  
  Uttkarsh.

• 

  enrique.pv-ext

  • Post Options:
  • Link
    Copy

  Posted 25 May 2026, 3:34 am EST - Updated 25 May 2026, 3:40 am EST

  I try with p, p0, p1…

  f.DataFormatString = "p1"; // "{0:0.##}" + " %"; //  when a numerical value is formatted using “p”, it is automatically multiplied by 100 before the ‘%’ symbol is applied.

  p
  
  

  p0
  
  

  p1
  
  

  In older version: “{0:0.##}” + " %";

  

  any suggestions, for view right the percentage value ?

• 

  uttkarsh.matiyal

  

  • Post Options:
  • Link
    Copy

  Posted 26 May 2026, 3:11 am EST

  Hello Enrique,

  As mentioned earlier, when using the “p” format specifier, the value is automatically multiplied by 100 before the “%” symbol is appended. Therefore, the behavior you are seeing is expected.

  For your scenario, one possible workaround is to divide the underlying values by 100 before binding them to the grid, and then use the percentage format specifier.

  If this approach does not meet your requirements, please share a small sample of the data being bound to the grid along with the relevant C1-specific code used in your project. This will help us better understand the scenario and suggest the most appropriate solution.

  Regards,
  
  Uttkarsh

• 

  enrique.pv-ext

  • Post Options:
  • Link
    Copy

  Posted 25 June 2026, 7:23 am EST

  Format legacy: {0:0} % for DataFormatString

  sample legacy:

          <cc1:C1BoundField  DataField="TAX_PERCENT" SortExpression="TAX_PERCENT"
               HeaderText="IVA" DataFormatString="{0:0} %">
               <ItemStyle CssClass="GridNumber" />                   
          </cc1:C1BoundField>

  any suggestions: p, p1, p2,…n0… ?

• 

  uttkarsh.matiyal

  

  • Post Options:
  • Link
    Copy

  Posted 26 June 2026, 3:13 am EST

  Hello Enrique,

  There are only two viable options to achieve your requirement:

  1. Use Template Field:

  <wijmo:C1TemplateField HeaderText="Amount (template)">
      <ItemStyle HorizontalAlign="Right" />
      <ItemTemplate><%# Eval("TOTAL_AMOUNT") %> %</ItemTemplate>
  </wijmo:C1TemplateField>

  2. Use “p2” format with calculated column values:

  <wijmo:C1BoundField DataField="TOTAL_AMOUNT_calculated"
      HeaderText="Amount (p2 with calculated field)"
      SortExpression="TOTAL_AMOUNT_calculated"
      DataFormatString="p2">
      <ItemStyle CssClass="GridNumber" Width="120px" />
  </wijmo:C1BoundField>
  
  ---
  
  protected void Page_Load(object sender, EventArgs e)
  {
      if (!IsPostBack)
      {
          var data = GetData();
          data = AddCalculatedPercentField(data, "TOTAL_AMOUNT");
          C1GridView1.DataSource = data;
          C1GridView1.DataBind();
      }
  }
  
  private DataTable AddCalculatedPercentField(DataTable data, string colName)
  {
      var newColName = $"{colName}_calculated";
      data.Columns.Add(newColName, typeof(decimal));
      foreach (DataRow row in data.Rows)
      {
          if(decimal.TryParse(row[colName].ToString(), out decimal val))
          row[newColName] = val/100;
          else
              row[newColName] = 0;
      }
      return data;
  }
  
  private DataTable GetData()
  {
      DataTable dt = new DataTable();
      dt.Columns.Add("Item", typeof(string));
      dt.Columns.Add("TOTAL_AMOUNT", typeof(decimal));
  
      dt.Rows.Add("Laptop", 0.01m);
      dt.Rows.Add("Monitor", 0.03m);
      dt.Rows.Add("Keyboard", 96.65m);
  
      return dt;
  }

  Please refer to the attached sample for the same: GridView_PercentFormat.zip

  Regards,
  
  Uttkarsh.