[CLOSED] gridpanel / sorting / ascent insensitive

[tMp]

Hello

I am setting the locale on run time (currentuiculture & currentculture) of my webapp to get multi lingual application according to a user selection and not via locale of ext.net in the config file. This works wonderful with datefields but gives me a problem with sorting on gridpanels. Strings with ascents don't get sorted as we do it (ascent insensitive for chars like a & ä or u & ü). Is there a way to set the sorting locale on the fly too? (like currentculture?)

Thank you very much.

best regards

PS: I know there is the SortType on the modelfield but that seems to give me only case (in)sensitive...

[Daniil]

Hi @tMp,

As far as I know JavaScript has issues with sorting characters with accents.

Generally speaking, remote sorting (on server) is the answer in such scenarios. Is it an option for you?

[tMp]

Hello Daniil,

I feared you would answer something like that. I am trying to do as much as possible on the client side. In this case all the data is already on the client side and there is no need to disturb the server with anything about it... But in that case I think I will have too because it looks really stupid if you are not used to it = clients won't find everything...

Thanks for the information and if you ever have a solution - please don't hesitate to share it ;)

cheers!

PS: Or could I enhance the sorting with some javascript to strip the accents?

[Daniil]

I agree.

Could you, please, provide a simple test case to reproduce the issue? I would like to investigate in details.

As far as I can understand you are facing two different issues (with different configurations)? Please provide a test case of the most actual issue first.

[tMp]

Hello Daniil,

I am so sorry. I had a mix up with locale and remote sorting (I corrected the initial text, there is only one problem - the one with JavaScript sorting in gridpanels and case & accent insensitivity).

As you see in the test case, the "e" and the "Ä" aren't where they should be... Perhaps one can tweak the sorting algorithm to ignore cases and accents?

Thank you,

best regards

<%@ Page Language="C#" %>

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Xml.Xsl" %>
<%@ Import Namespace="System.Xml" %>
<%@ Import Namespace="System.Linq" %>

<script runat="server">
    private DataTable GetDataTable()
    {
        DataTable table = new DataTable();

        table.Columns.AddRange(new DataColumn[] {
            new DataColumn("Name")   { ColumnName = "name",    DataType = typeof(string) }
        });

        foreach (object[] obj in this.Data)
        {
            table.Rows.Add(obj);
        }

        return table;
    }
    
    private object[] Data
    {
        get
        {            
            return new object[]
            {
                new object[] { "AT&T Inc." },
                new object[] { "Boeing Co." },
                new object[] { "Caterpillar Inc."},
                new object[] { "Citigroup, Inc."},
                new object[] { "E.I. du Pont de Nemours and Company" },
                new object[] { "exxon Mobil Corp"},
                new object[] { "General Electric Company" },
                new object[] { "General Motors Corporation" },
                new object[] { "Hewlett-Packard Co." },
                new object[] { "Honeywell Intl Inc" },
                new object[] { "Intel Corporation" },
                new object[] { "International Business Machines" },
                new object[] { "Johnson & Johnson" },
                new object[] { "JP Morgan & Chase & Co" },
                new object[] { "McDonald\"s Corporation" },
                new object[] { "Merck & Co., Inc." },
                new object[] { "Microsoft Corporation" },
                new object[] { "Pfizer Inc" },
                new object[] { "The Coca-Cola Company" },
                new object[] { "Ägis GmbH" },
                new object[] { "The Procter & Gamble Company" },
                new object[] { "United Technologies Corporation" },
                new object[] { "Verizon Communications" },
                new object[] { "Wal-Mart Stores, Inc." }
            };
        }
    }
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!X.IsAjaxRequest)
        {
            this.Store1.DataSource = this.GetDataTable();
            this.Store1.DataBind(); 
        }
    }

    </script>
<!DOCTYPE html>

<html>
<head runat="server">
    <title>Basic GridPanel - Ext.NET Examples</title>
    <link href="/resources/css/examples.css" rel="stylesheet" />
</head>
<body>
    <ext:ResourceManager runat="server" Locale="de-ch" />

    <ext:Viewport runat="server"  MarginSpec="0 0 10 0">
        <LayoutConfig>
            <ext:VBoxLayoutConfig Align="Center" Pack="Center" />
        </LayoutConfig>
        <Items>
            <ext:GridPanel 
                runat="server" 
                Title="Test" 
                Frame="true"
                Width="400"
                Height="295">
                <Store>
                    <ext:Store 
                        id="Store1"
                        runat="server">
                        <Model>
                            <ext:Model runat="server">
                                <Fields>
                                    <ext:ModelField Name="name" />
                                </Fields>
                            </ext:Model>
                        </Model>
                        <Sorters>
                            <ext:DataSorter Property="name" />
                        </Sorters>
                    </ext:Store>
                </Store>
                <ColumnModel runat="server">
                    <Columns>
                        <ext:Column runat="server" Text="Name" Flex="1" DataIndex="name" />
                    </Columns>
                </ColumnModel>
            </ext:GridPanel>
        </Items>
    </ext:Viewport>
</body>
</html>

[Daniil]

Thank you for the test case and sorry for the delay. I will investigate it a bit later this week.