We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

IPivotField interface missing SortType

Thread ID:





106331 Dec 29,2012 12:27 AM UTC Jan 3,2013 06:06 AM UTC WPF 1
Tags: XlsIO
Win RT
Asked On December 29, 2012 12:27 AM UTC

I have been trying out the Win RT XlsIO Beta.  While creating a pivot table I noticed that the pivot table sort order didn't match the source data (not sure why.. possible bug?).  I initially couldn't find a way to force a sort of the field either.

I cracked open the assembly with reflector and found that the IPivorField implementation PivotFieldImpl had the desired field.  I am now able to sort the field by doing a cast:

((Syncfusion.XlsIO.Implementation.PivotTables.PivotFieldImpl)pivotTable.Fields[0]).SortType = PivotFieldSortType.Ascending;

Manikandan M [Syncfusion]
Replied On January 3, 2013 06:06 AM UTC


Thanks for using Syncfusion products.

Sort order didn't match the source data in XlsIO:
We are afraid that we are not able to reproduce the issue "sort order didn't match the source data" from our side. We have created the simplified sample and have attached the same in the below link. Please make use of this and let us know if this helps you.

Sample link:PivotTable_WinRT.zip

If the above sample does not meet with scenario, please modify the above sample to reproduce the issue or create the simplified issue reproducing sample and update us. so that we could analysis further on this issue.

Property for SortType in IPivotField interface:
We currently have not exposed the SortType property of pivot field in XlsIO for testing purpose. We will expose this property in any of the upcoming release.

Please let us know if you need any clarifications.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon