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
Infragistics User
655
Decimal and thousand separators
posted

Hi,

I have a WebDataGrid with a decimal column and its own editor:

<ig:BoundDataField DataFieldName ="HORAS_LABORABLES" Key ="HORAS_LABORABLES"

Header-CssClass ="HorasLaborables" Width ="120" CssClass="Right" DataType ="System.Decimal" DataFormatString ="{0:N2}">
<Header Text ="Horas laborables"></Header>
</ig:BoundDataField>

<ig:NumericEditorProvider ID ="Horas">
<EditorControl ClientIDMode="Predictable" runat ="server" DataMode="Decimal" MaxDecimalPlaces="2" >
</EditorControl>
</ig:NumericEditorProvider>

But by default, the decimal separator is “,” and the thousand separator is “.”, but I need just the opposite. I need the “.” as the decimal separator and “,” as the thousand separator.  How can I define the decimal and thousand separator on the NumericEditorProvider?

Thanks for your help.

Parents
No Data
Reply
  • 2535
    Verified Answer
    Offline posted

    Hi,

    Thank you for using our forum.

    You can set the Culture property in your editor to en-US for example and the decimal separator will be ‘.’.

    <ig:NumericEditorProvider ID ="Horas">
    <EditorControl ClientIDMode="Predictable" runat ="server" DataMode="Decimal" MaxDecimalPlaces="2" Culture="en-US"     >
    </EditorControl>
    </ig:NumericEditorProvider>

    Please let me know if I can provide any further assistance.

Children