Creating a Custom Spanning

The following example demonstrates how to span cells across a range of values.

XAML	Copy Code
<Grid xmlns:xcdg="http://schemas.xceed.com/wpf/xaml/datagrid"> <Grid.Resources> <xcdg:DataGridCollectionViewSource x:Key="cvs_orders" Source="{Binding Source={x:Static Application.Current}, Path=Orders}" /> <local:CustomSpannedCellSelector x:Key="spannedCellSelector" /> </Grid.Resources> <xcdg:DataGridControl ItemsSource="{Binding Source={StaticResource cvs_orders}}" SpannedCellSelector="{StaticResource spannedCellSelector}"> <xcdg:DataGridControl.View> <xcdg:TableView AllowCellSpanning="True" /> </xcdg:DataGridControl.View> <xcdg:DataGridControl.Columns> <xcdg:Column FieldName="Freight" CellSpanningDirection="Row" /> </xcdg:DataGridControl.Columns> </xcdg:DataGridControl> </Grid>

XAML

Copy Code

<Grid xmlns:xcdg="http://schemas.xceed.com/wpf/xaml/datagrid">
  <Grid.Resources>
    <xcdg:DataGridCollectionViewSource x:Key="cvs_orders"
                                       Source="{Binding Source={x:Static Application.Current}, Path=Orders}" />
    <local:CustomSpannedCellSelector x:Key="spannedCellSelector" />
  </Grid.Resources>
  <xcdg:DataGridControl ItemsSource="{Binding Source={StaticResource cvs_orders}}"
                        SpannedCellSelector="{StaticResource spannedCellSelector}">
    <xcdg:DataGridControl.View>
      <xcdg:TableView AllowCellSpanning="True" />
    </xcdg:DataGridControl.View>
    <xcdg:DataGridControl.Columns>
      <xcdg:Column FieldName="Freight"
                   CellSpanningDirection="Row" />
    </xcdg:DataGridControl.Columns>
  </xcdg:DataGridControl>
</Grid>

C#	Copy Code
public sealed class CustomSpannedCellSelector : SpannedCellSelector { private const decimal Range = 10m; public override bool CanMerge(SpannedCellFragment x, SpannedCellFragment y) { if ((x.Column == y.Column) && (x.Column.FieldName == "Freight")) { var xBound = this.GetLowerBound(x); var yBound = this.GetLowerBound(y); return xBound.HasValue && yBound.HasValue && (xBound.Value == yBound.Value); } return false; } public override object SelectContent(IEnumerable<SpannedCellFragment> fragments) { var first = fragments.FirstOrDefault(); var bound = (first != null) ? this.GetLowerBound(first) : null; if (!bound.HasValue) return null; return string.Format("{0} - {1}", bound.Value, bound.Value + Range); } private decimal? GetLowerBound(SpannedCellFragment x) { var content = x.Content; if (!(content is decimal)) return null; var value = (decimal)content; return Math.Floor(value / Range) * Range; } }

Copy Code

public sealed class CustomSpannedCellSelector : SpannedCellSelector
{
  private const decimal Range = 10m;
  public override bool CanMerge(SpannedCellFragment x, SpannedCellFragment y)
  {
    if ((x.Column == y.Column) && (x.Column.FieldName == "Freight"))
    {
      var xBound = this.GetLowerBound(x);
      var yBound = this.GetLowerBound(y);
      return xBound.HasValue
             && yBound.HasValue
             && (xBound.Value == yBound.Value);
    }
    return false;
  }
  public override object SelectContent(IEnumerable<SpannedCellFragment> fragments)
  {
    var first = fragments.FirstOrDefault();
    var bound = (first != null) ? this.GetLowerBound(first) : null;
    if (!bound.HasValue)
      return null;
    return string.Format("{0} - {1}", bound.Value, bound.Value + Range);
  }
  private decimal? GetLowerBound(SpannedCellFragment x)
  {
    var content = x.Content;
    if (!(content is decimal))
      return null;
    var value = (decimal)content;
    return Math.Floor(value / Range) * Range;
  }
}