This is a migrated thread and some comments may be shown as answers.

Radfilter textbox German numeric format issue

7 Answers 66 Views

Filter

This is a migrated thread and some comments may be shown as answers.

RAKESH asked on 28 Aug 2013, 11:02 AM

German-format.PNG

Hi,

I'm filtering my grid column using RadFilter. For numeric columns for en-US (english) culture with value 0.5 it is working fine.

But if I change my culture to german (de-DE), Radfilter textbox is accepting value as 0,5 (which is correct) and my grid column also filtered with 0,5 values, but radfilter textbox converting 0,5 value as 5,00 which is not correct. It should show as 0,5.

<telerik:RadFilter runat="server" ID="rfControllers" FilterContainerID="RadFilter1" ShowApplyButton="true" Visible="true" Skin="Web20"></telerik:RadFilter>

Please refer to the attachment.

Please help me.

- Kumar

7 Answers, 1 is accepted

answered on 02 Sep 2013, 06:42 AM

RadFilterCultureChange.zip

Hi,

I have assembled a sample page in order to replicate the issue but to no avail. In order to further investigate the problem you could modify the provided page to show the unwanted behavior so we could debug it and advice you with the best possible solution. You could upload the files on a public sharing site and provide a link in your post.

Regards,
Antonio Stoilkov
Telerik

If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.

answered on 02 Sep 2013, 01:40 PM

Hi Antonio,

I have created sample pages to replicate the issue. Please see below working code. Filter Value with 1,5 and click on apply button. You will notice that value 1,5 changing it to 15,00 in Radfilter Numeric Textbox.

ASPX

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default3.aspx.cs" Inherits="Dave.Web.Default3" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title></title>

</head>

<body>

<form id="form1" runat="server">

<div>

<telerik:RadScriptManager runat="server">

</telerik:RadScriptManager>

<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server">

<telerik:RadFilter runat="server" ID="rfControllers" FilterContainerID="RadGrid1">

<FieldEditors>

<telerik:RadFilterNumericFieldEditor FieldName="Value"></telerik:RadFilterNumericFieldEditor>

</FieldEditors>

</telerik:RadFilter>

<telerik:RadGrid ID="RadGrid1" runat="server" OnNeedDataSource="RadGrid1_NeedDataSource"

AutoGenerateColumns="false" AllowPaging="true" AllowSorting="true" PageSize="7">

<MasterTableView>

<Columns>

<telerik:GridBoundColumn DataField="ID" HeaderText="ID" UniqueName="ID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Value" HeaderText="Value" UniqueName="Value">

</telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

</telerik:RadAjaxPanel>

</div>

</form>

</body>

</html>

ASPX.CS

using System;

using System.Collections.Generic;

using System.Globalization;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using Telerik.Web.UI;

using System.Data;

namespace Dave.Web

{

public partial class Default3 : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected override void InitializeCulture()

{

Page.UICulture = "de-DE";

Page.Culture = "de-DE";

}

protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)

{

DataTable table = new DataTable();

table.Columns.Add("ID", typeof(int));

table.Columns.Add("Value", typeof(double));

for (int i = 1; i < 21; i++)

{

double val = i + 0.5;

table.Rows.Add(i, val);

}

RadGrid1.DataSource = table;

}

Sorry for pasting the code here. I don't have any URL to upload the code.

- Kumar

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

Radfilter textbox German numeric format issue

7 Answers, 1 is accepted