DataSorter in columns

Aspose.Cells Product Family
1

Hi all. I have a question for you and I can’t seem to find this in the documentation…

MS Office provides options for the sorting functionality where we can change the default row sorting to column sorting, allowing the user to sort data along columns as he would do for rows.

I can’t seem to find this property/option in Aspose.Cells. Is it not implemented? If so can you implement it? If it is implemented can you provide me a sample?

Thanks in advance,
Cruz

2

Hi Cruz,

Kindly check the following documentation topic for your reference:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/data-sorting.html

Thank you.

3

Hi Amjad, thanks for the reply.

I had already checked that topic, actually. But it does not explain by doubt… This topic shows how to sort data along the sheets rows (Ascending and Descending) but what I want to do is to use the sorting along the columns (Left to Right). My question is: is this possible with Aspose.Cells? If so, how can I do it?


Cruz

4

Hi,

Now we understand your need. We will support it to enhance data sorting feature soon.

Thank you.

5

Hi there,



I’d like to know if you have any timings on this issue.



Keep up the good work.

Cruz

6

Hi Cruz,

We will give you an eta for the feature soon.

Thank you.

7

Hi Cruz,

Please try the fix in https://forum.aspose.com/t/97151

And set the sort orientation from left to right with the code dataSorter.SortLeftToRight = true;