Forums Ultimate UI for WPF
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
Close
Sam
3160
xampivotgrid is sorting numbers as strings
posted

Is sorting:  1, 1.5, 10, 2

Should sort 1, 1.5, 2, 10

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

<

 

 

 

igFlatData:FlatDataSource x:Key="QtyFlatData" x:Shared="False" PreserveMembersOrder

="False"

 

 

 

Rows

="[Collateral].[Collateral],[AcctNo].[AcctNo]"

 

 

 

Columns

="[Type].[Type],[Coupon].[Coupon]"

 

 

 

Measures

="Qty"

 

 

 

>

 

 

 

 

 

<igFlatData:FlatDataSource.ConnectionSettings

>

 

 

 

 

<igFlatData:FlatDataConnectionSettings ItemsSource="{Binding Items

}"/>

 

 

 

 

</igFlatData:FlatDataSource.ConnectionSettings

>

 

 

 

 

<igFlatData:FlatDataSource.CubesSettings

>

 

 

 

 

<igFlatData:CubeMetadata DataTypeFullName

="Poolman.Models.ExposureItem">

 

 

 

 

<igFlatData:DimensionMetadata SourcePropertyName="Qty" DisplayFormat

="{}{0:#,#;(#,#)}"/>

 

 

 

 

</igFlatData:CubeMetadata

>

 

 

 

 

</igFlatData:FlatDataSource.CubesSettings

>

 

 

 

 

<igFlatData:FlatDataSource.LevelDefaultSortDirections

>

 

 

 

 

<igFlatData:LevelSortDirection LevelUniqueName="Collateral" SortDirection

="Ascending" />

 

 

 

 

<igFlatData:LevelSortDirection LevelUniqueName="Coupon" SortDirection

="Ascending"/>

 

 

 

 

</igFlatData:FlatDataSource.LevelDefaultSortDirections

>

 

 

 

 

 

<igFlatData:FlatDataSource.HierarchyDescriptors

>

 

 

 

 

<igFlatData:HierarchyDescriptor SourcePropertyName="Collateral" HierarchyName

="Collateral" >

 

 

 

 

<igFlatData:HierarchyDescriptor.LevelDescriptors

>

 

 

 

 

<igFlatData:HierarchyLevelDescriptor LevelName

="All"/>

 

 

 

 

<igFlatData:HierarchyLevelDescriptor LevelName="Description" LevelExpressionPath="Collateral"

/>

 

 

 

 

</igFlatData:HierarchyDescriptor.LevelDescriptors

>

 

 

 

 

</igFlatData:HierarchyDescriptor

>