Flexgrid footer NET6

Flexgrid footer NET6

Posted by: devcode.ou on 23 April 2023, 8:20 pm EST

• 

  devcode.ou

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 23 April 2023, 8:20 pm EST

  Hi
  
  could you help me to use the “columnFooters” in the flexgrig NET6 version
  
  this is my code in the old version:

  [code]public static void kFlexgrid__init_footer_group(FlexGrid flexgrid)
  
  {
  
  var gr = new MyC1GroupRow();
  
  gr.Background =System.Windows.Media.Brushes.LightGray;

  //flexgrid.ColumnFooters.Height =18;
  
  flexgrid.ColumnFooters.Background =System.Windows.Media.Brushes.Black;
  
  flexgrid.ColumnFooters.Margin =new System.Windows.Thickness(2,2,0,2);
  
  flexgrid.ColumnFooters.Rows.Add(gr);
  
  }

  public class MyC1GroupRow : C1.WPF.FlexGrid.GroupRow
  
  {
  
  public override string GetDataFormatted(C1.WPF.FlexGrid.Column col)
  
  {
  
  var data = base.GetDataRaw(col);
  
  return string.Format(col.Binding.ConverterCulture, “{0:”+ col.Binding.StringFormat +“}”, data);
  
  }
  
  }[/code]

  Thank you

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 24 April 2023, 9:24 pm EST

  Hi,

  Thanks for reaching out to us.
  
  We didn’t support ColumnFooter in FlexGrid Net6 yet. However, this is in our to-do list. You can check out ComponentOne 2023 RoadMap: https://www.grapecity.com/blogs/componentone-2023-roadmap

  There’s no ETA confirmed yet too. We will inform you once ColumnFooter property is added.[Internal Tracking Id - C1XAML-31590]

  Regards,
  
  Nitin

• 

  kgallion

  • Post Options:
  • Link
    Copy

  Posted 13 November 2023, 10:34 am EST

  We are also running into this issue moving from Net Framework to Net7. Do you have an ETA for the ColumnFooter feature? Or a suggested workaround until it is available?

  Thanks,
  
  Keith

• 

  devcode.ou

  • Post Options:
  • Link
    Copy

  Posted 13 November 2023, 8:04 pm EST

  i stopped using it, i created my own solution
  
  let me know when you will fix it
  
  thanx

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 13 November 2023, 11:10 pm EST

  Hi,

  This feature is available in the latest 7.0 version: https://www.nuget.org/packages/C1.WPF.Grid/7.0.20233.662
  
  Please refer the attached sample for the same: FlexGridColumnFooters.zip

  Best Regards,
  
  Nitin

• 

  devcode.ou

  • Post Options:
  • Link
    Copy

  Posted 18 December 2023, 2:01 am EST

  Hi i saw your example, but is it possible, as before, to have the aggregate value under each column?
  
  Thanx

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 18 December 2023, 11:41 pm EST

  Hi,

  You can specify the AggregateFunctions for each column. Please refer to the attached modified sample for the same: FlexGridColumnFooters.zip

  Best Regards,
  
  Nitin

• 

  devcode.ou

  • Post Options:
  • Link
    Copy

  Posted 17 January 2024, 10:38 pm EST

  Hi can you help me to customize the footer columns in (.NET 6,7,8),
  
  I used the “ColumnFooter” properties but

  • is it possible to avoid the label “count”,“sum”?
  • is it possible to create a sort of CellTemplate ?
    
    Thanx
• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 18 January 2024, 11:56 pm EST

  Hi,

  Thanks for reaching out to us again.
  
  This is the default behavior and is added to identify the particular aggregate applied on the column. In order to hide aggregate function from Footers. You can override the PrepareCell method of GridCellFactory as:

  public override async void PrepareCell(GridCellType cellType, GridCellRange range, GridCellView cell, Thickness internalBorders)
  {
      base.PrepareCell(cellType, range, cell, internalBorders);
      if (cellType == GridCellType.ColumnFooter)
      {
          if (cell.Content is GridSummaryCell summaryCell)
          {
              await Task.Delay(100);
              string empty = string.Empty;
              summaryCell.Title = summaryCell.Title.Replace("Sum(", empty)
                  .Replace("Count(", empty)
                  .Replace("Avg(", empty)
                  .Replace("Max(", empty)
                  .Replace("Min(", empty)
                  .Replace("Range(", empty)
                  .Replace("Std(", empty)
                  .Replace("Var(", empty)
                  .Replace("StdPop(", empty)
                  .Replace("VarPop(", empty)
                  .Replace(")", empty);
          }
      }
  }

  You can also customize the Footer Cells using CellFactory. Please let us know if you are facing any issues while implementing it.
  
  Please refer the attached sample for the same: FlexGridColumnFooters_Mod.zip

  Regards,
  
  Nitin