Xceed DataGrid for WPF

Re: StatCell, ResultConverterParameter Problem

arya009 — Fri, 16 Oct 2009 08:50:27 GMT

anyone? i m still getting this error :(

Re: StatCell, ResultConverterParameter Problem

Jenny [Xceed] — Wed, 22 Jul 2009 17:36:13 GMT

This is a binding error that is most likely not related to the grid; however, if you provide me with the binding that is failing, I will try and help you get up and running.

Re: StatCell, ResultConverterParameter Problem

arya009 — Wed, 22 Jul 2009 13:03:32 GMT

There is only one error that too for Alternaterowcolor

System.Windows.Data Error: 4 : Cannot find source for binding with reference 'RelativeSource FindAncestor, AncestorType='HotsoftControls.HotsoftGrid', AncestorLevel='1''. BindingExpression:Path=AlternateRowColor; DataItem=null; target element is 'SolidColorBrush' (HashCode=48034301); target property is 'Color' (type 'Color')

Re: StatCell, ResultConverterParameter Problem

Jenny [Xceed] — Wed, 22 Jul 2009 12:47:21 GMT

What is the error in the output window?

Re: StatCell, ResultConverterParameter Problem

arya009 — Wed, 22 Jul 2009 05:28:02 GMT

I have modified the code accordingly. but result is the same...

<xcdg:StatCell FieldName="RunningCostAmtAC">
    <xcdg:StatCell.ContentTemplate>
        <DataTemplate>
            <StackPanel Orientation="Horizontal">
                <TextBlock Text="{Binding RelativeSource={RelativeSource Self}, Path=(xcdg:DataGridControl.StatContext).sum_RunningCostAmtAC, Converter={StaticResource statResultConverter}, ConverterParameter='€#,###,###,###.##'}" Margin="4,0,0,0" />
            </StackPanel>
        </DataTemplate>
    </xcdg:StatCell.ContentTemplate>
</xcdg:StatCell >

Re: StatCell, ResultConverterParameter Problem

Jenny [Xceed] — Tue, 21 Jul 2009 16:27:57 GMT

There are at least 2 things wrong with the provided XAML:

1- The ContentTemplate property requires a DataTemplate. It will not accept any other element type.

2- You can't use double quotes (") in in the ConverterParameter. Use a single quote (') instead.

Re: StatCell, ResultConverterParameter Problem

arya009 — Tue, 21 Jul 2009 06:45:46 GMT

This is the another thing i have tried and it is giving me another error:

Error : Name cannot begin with the '\' character, hexadecimal value 0x5C. Line 1, position 2214.

<xcdg:StatRow>
<xcdg:StatRow.Resources>
<xcdg:StatResultConverter x:Key="statResultConverter"/><app:MaskNumberConverter x:Key="maskConverter" />
</xcdg:StatRow.Resources>
<xcdg:StatCell FieldName="Qty">
    <xcdg:StatCell.ContentTemplate>
        <StackPanel Orientation="Horizontal">
            <TextBlock Text="{Binding RelativeSource={RelativeSource Self}, Path=(xcdg:DataGridControl.StatContext).sum_Qty, Converter={StaticResource maskConverter}, ConverterParameter="\#,##,##,##,#0.00"}" Margin="4,0,0,0" />
        </StackPanel>
    </xcdg:StatCell.ContentTemplate>
</xcdg:StatCell >
<xcdg:StatCell FieldName="QtyMeasure">
    <xcdg:StatCell.ContentTemplate>
        <StackPanel Orientation="Horizontal">
            <TextBlock Text="{Binding RelativeSource={RelativeSource Self}, Path=(xcdg:DataGridControl.StatContext).sum_QtyMeasure, Converter={StaticResource maskConverter}, ConverterParameter="\#,##,##,##,#0.00"}" Margin="4,0,0,0" />
        </StackPanel>
    </xcdg:StatCell.ContentTemplate>
</xcdg:StatCell >
<xcdg:StatCell FieldName="RunningCostAmtBC">
    <xcdg:StatCell.ContentTemplate>
        <StackPanel Orientation="Horizontal">
            <TextBlock Text="{Binding RelativeSource={RelativeSource Self}, Path=(xcdg:DataGridControl.StatContext).sum_RunningCostAmtBC, Converter={StaticResource maskConverter}, ConverterParameter="$#,##,##,##,#0.00"}" Margin="4,0,0,0" />
        </StackPanel>
    </xcdg:StatCell.ContentTemplate>
</xcdg:StatCell >
<xcdg:StatCell FieldName="BalanceCostAmtBC">
    <xcdg:StatCell.ContentTemplate>
        <StackPanel Orientation="Horizontal">
            <TextBlock Text="{Binding RelativeSource={RelativeSource Self}, Path=(xcdg:DataGridControl.StatContext).sum_BalanceCostAmtBC, Converter={StaticResource maskConverter}, ConverterParameter="$#,##,##,##,#0.00"}" Margin="4,0,0,0" />
        </StackPanel>
    </xcdg:StatCell.ContentTemplate>
</xcdg:StatCell >
<xcdg:StatCell FieldName="RunningCostAmtAC">
    <xcdg:StatCell.ContentTemplate>
        <StackPanel Orientation="Horizontal">
            <TextBlock Text="{Binding RelativeSource={RelativeSource Self}, Path=(xcdg:DataGridControl.StatContext).sum_RunningCostAmtAC, Converter={StaticResource maskConverter}, ConverterParameter="\€#,###,###,###.##"}" Margin="4,0,0,0" />
        </StackPanel>
    </xcdg:StatCell.ContentTemplate>
</xcdg:StatCell >
<xcdg:StatCell FieldName="CostPerUnit">
    <xcdg:StatCell.ContentTemplate>
        <StackPanel Orientation="Horizontal">
            <TextBlock Text="{Binding RelativeSource={RelativeSource Self}, Path=(xcdg:DataGridControl.StatContext).divide_CostPerUnit, Converter={StaticResource maskConverter}, ConverterParameter="\#,##,##,##,#0.00"}" Margin="4,0,0,0" />
        </StackPanel>
    </xcdg:StatCell.ContentTemplate>
</xcdg:StatCell >
<xcdg:StatCell FieldName="CataloguePriceBC">
    <xcdg:StatCell.ContentTemplate>
        <StackPanel Orientation="Horizontal">
            <TextBlock Text="{Binding RelativeSource={RelativeSource Self}, Path=(xcdg:DataGridControl.StatContext).avg_CataloguePriceBC, Converter={StaticResource maskConverter}, ConverterParameter="$#,##,##,##,#0.00"}" Margin="4,0,0,0" />
        </StackPanel>
    </xcdg:StatCell.ContentTemplate>
</xcdg:StatCell >
</xcdg:StatRow>

maskConverter is the converter which i am using to convert the data of DataRow. It is working properly as you can see euro sign in DataRows.

Re: StatCell, ResultConverterParameter Problem

arya009 — Tue, 21 Jul 2009 05:10:00 GMT

I have alter it like this :

<xcdg:StatCell FieldName="RunningCostAmtAC" ResultPropertyName="sum_RunningCostAmtAC" HorizontalContentAlignment="Right" ResultConverterParameter="\€#,###,###,###.##" />

but still the problem remains. It is still showing ? instead of Euro sign. Font family is same i have only assigned font weight property in statrow.

Re: StatCell, ResultConverterParameter Problem

Mohamed [Xceed] — Mon, 20 Jul 2009 15:52:52 GMT

Hi,

You can force the use of the euro literal by setting ResultConverterParameter="\€#,###,###,###.##" on your RunningCostAmtAC StatCell.

Otherwise, please ensure that you are using the same FontFamily in both your StatRow and DataRow.

StatCell, ResultConverterParameter Problem

arya009 — Mon, 20 Jul 2009 12:00:38 GMT

I am trying to set Stat Functions at runtime which is running fine. I have only one problem, When i am passing $ or Euro Symbol it is showing $ but in case of Euro it is showing ?

This is my code which is getting generated at runtime and getting binded to stat row

<xcdg:StatRow>
<xcdg:StatCell FieldName="Qty" ResultPropertyName="sum_Qty" HorizontalContentAlignment="Right" ResultConverterParameter="#,##,##,##,#0.00" />
<xcdg:StatCell FieldName="QtyMeasure" ResultPropertyName="sum_QtyMeasure" HorizontalContentAlignment="Right" ResultConverterParameter="#,##,##,##,#0.00" />
<xcdg:StatCell FieldName="RunningCostAmtBC" ResultPropertyName="sum_RunningCostAmtBC" HorizontalContentAlignment="Right" ResultConverterParameter="$#,##,##,##,#0.00" />
<xcdg:StatCell FieldName="BalanceCostAmtBC" ResultPropertyName="sum_BalanceCostAmtBC" HorizontalContentAlignment="Right" ResultConverterParameter="$#,##,##,##,#0.00" />
<xcdg:StatCell FieldName="RunningCostAmtAC" ResultPropertyName="sum_RunningCostAmtAC" HorizontalContentAlignment="Right" ResultConverterParameter="€#,###,###,###.##" />
<xcdg:StatCell FieldName="CostPerUnit" ResultPropertyName="divide_CostPerUnit" HorizontalContentAlignment="Right" ResultConverterParameter="#,##,##,##,#0.00" />
<xcdg:StatCell FieldName="CataloguePriceBC" ResultPropertyName="avg_CataloguePriceBC" HorizontalContentAlignment="Right" ResultConverterParameter="$#,##,##,##,#0.00" />
</xcdg:StatRow>

Here is the image of the output.

Link of the image : http://img515.imageshack.us/img515/162/statcell.jpg