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
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

>

Parents
No Data
Reply
  • 30945
    Offline posted

    Hello,

     

    I have logged this behavior with our developers in our tracking system, with an issue ID of 113494.  I have also created a support ticket on your behalf with number CAS-93317-D0LTKP in order to link the development issue to it so that you are automatically updated when a Service Release containing your fix is available for download.

     

    Sincerely,

    Krasimir

    Developer Support Engineer

    Infragistics, Inc.

    www.infragistics.com/support

Children