Sorting data by clicking on header

faureciasg · February 12, 2013, 4:57am

Hello !

I’m looking for a feature which enables the sorting by clicking on headers columns.
Is there something like this ?
By clicking on the header of the column C for exemple the data automatically sort ascending and if you click again the data sort descending.

Thanks for your answers !

amjad.sahi · February 12, 2013, 6:11am

Hi,

Please see the demo for your reference, GridWeb supports data sorting accordingly:

github.com

aspose-cells/Aspose.Cells-for-.NET/blob/master/Examples_GridWeb/GridWeb.Net4/CSharp/Worksheets/SortData.aspx.cs

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Aspose.Cells.GridWeb.Data;
using System.Drawing;
using Aspose.Cells.GridWeb;

namespace Aspose.Cells.GridWeb.Examples.CSharp.Worksheets
{
    public partial class SortData : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

This file has been truncated. show original

Thank you.

faureciasg · February 12, 2013, 7:06am

I have seen this demo before. But it’s not exactly what i’m looking for. I want to enable for the user a sorting like the asp:Gridview sorting. When user clicks on the header of a column it sorts the data by the ascending way. When he clicks again it sorts data by descending way. Etc.

Is there such a thing or should I write the code to do it ? By the way by using the code in the demo, user can only be able to sort in one way by clicking on the header manually defined.

amjad.sahi · February 12, 2013, 12:02pm

Hi,

Well, we do have such data sorting feature (GridView sorting type) but only in data binding mode, see the following demo for your reference if it may help you. We do not provide such data sorting feature in default mode.

e.g

Please uncheck "Create in-sheet headers" and now click on ProductName column, it will do in ascending order, now click it again, it will do the data sorting in descending order.

Thank you.