Forums Ultimate UI for ASP.NET Web Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Antonio Fernández
115
Error DataFormatString
posted

Hello:

We are evaluating the WebDataGrid v13.1 control. We want to use it in our web app, but we have this issue: if a cell has a “19,65” value (note the comma separator as defined in Control Panel for floating point values), then:

  • The cell is painted correctly
  • When you edit the cell content, it shows “1965”

In a similar, case:

  • If you use row["Item"] =  10.24;   à it shows in edit mode “1024”, but:
  • If you use row["Item"] =  10.240;  à it shows in edit mode “10,24”!

 

 

Aspx:

        <ig:WebDataGrid ID="WebDataGrid1" runat="server" Height="350px" Width="400px" AutoGenerateColumns="False"

            DataKeyFields="id">

            <Columns>

                <ig:BoundDataField Key="id" DataFieldName="id" Header-Text="id">   

                   <Header Text="id"></Header>

                </ig:BoundDataField>

                <ig:BoundDataField Key="Item" DataFieldName="Item" DataFormatString="{0:N2}" Header-Text="Item">

                    <Header Text="Item"></Header>

                </ig:BoundDataField>

            </Columns>

            <EditorProviders>

                <ig:NumericEditorProvider ID="WebDataGrid1_NumericEditorProvider1">

                    <EditorControl ClientIDMode="Predictable" DataMode="Decimal"

                        MaxDecimalPlaces="2">

                    </EditorControl>

                </ig:NumericEditorProvider>

            </EditorProviders>

            <Behaviors>

                <ig:Activation>

                </ig:Activation>

                <ig:EditingCore>

                    <Behaviors>

                        <ig:CellEditing>

                            <ColumnSettings>

                                <ig:EditingColumnSetting ColumnKey="id" ReadOnly="True" />

                                <ig:EditingColumnSetting ColumnKey="Item"

                                    EditorID="WebDataGrid1_NumericEditorProvider1" />

                            </ColumnSettings>

                        </ig:CellEditing>

                    </Behaviors>

                </ig:EditingCore>

            </Behaviors>

        </ig:WebDataGrid>

 

 

 

 

 

  • 20255
    Offline posted

    Hello Antonio,

     I am still following your case. If you still have any concerns or questions I will be glad to help.

  • 20255
    Suggested Answer
    Offline posted

    Hello Antonio,

     Thanks for you patience. In order to resolve this issue, you need to turn on Globalization in the ScriptManager to take care of the regional differences.

    <asp:ScriptManager ID="ScriptManager" runat="server" EnableScriptGlobalization="true">
    </asp:ScriptManager>


     If you have any questions or concerns or if you need further assistance please let me know. Thank you for using our forum!

  • 20255
    Suggested Answer
    Offline posted

    Hello Antonio,
    Thank you for posting in our forum!
    I've looked into your issue and have asked our development team to look further into it. In order to allow you to track the state of this issue I've opened a private case with number CAS-125517-Z1X0W1 . We'll continue communication trough the case.