Forums Retired Products and Controls
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
Patrick
25
WebNumericEdit - Formating problems with UltraWebgrid
posted

Hello,

 I'm using a ultrawebgrid that contains numbers with 2 decimals. For editing the numbers i'm using a webnumericedit with datamode double and culture dutch since the users will all be dutch.

The ultrawebgrid has 3 colums. 1 Column is hidden, 1 column cannot be edited. The column to be edited has the format ###,###,##0.00, type custom and datatype System.Double.

The format for the numbers in the grid works as it should. When i click on the cell the webnumericedit displays the format correct, but when i click on it the second time the format is suddenly englisch and not dutch. For example. 100.000,12 is dutch format. The first time i click on the cell is displays 100.000,12 but when i edit the cell the second time the number is 10000012. It is as if is forgets that is should be dutch format.

If i change the value to 100.000,12 and save the record, there is no problem. The value given back to class bound to the grid is 100000.12

Can anybody tell me what's happining? 

I'm using asp.net with vb.net.

here is my code:

<igtxt:WebNumericEdit ID="EditC" runat="server" BackColor="#CCFFCC"

Culture="Dutch (Netherlands)" Font-Size="XX-Small" Height="20px"

MinDecimalPlaces="Two" ValueText="000" Width="79px">

</igtxt:WebNumericEdit>

<igtbl:UltraWebGrid ID="grdGD" runat="server" Height="280px"

Width="280px" TabIndex="1">

<bands>

<igtbl:UltraGridBand AllowAdd="No" AllowColSizing="Fixed"

AllowColumnMoving="None" AllowDelete="No" AllowRowNumbering="None"

AllowSorting="No" AllowUpdate="Yes" CellClickAction="Edit" Expandable="No"

FixedHeaderIndicator="None" GridLines="Both" GroupByColumnsHidden="Yes"

RowAlternateStyling="False" RowSelectors="No" RowSizing="Fixed"

SelectTypeCell="None" SelectTypeCol="None" SelectTypeRow="None">

<addnewrow view="NotSet" visible="NotSet">

</addnewrow>

<Columns>

<igtbl:UltraGridColumn AllowGroupBy="No" AllowNull="False" AllowResize="Fixed"

AllowRowFiltering="False" AllowUpdate="No" BaseColumnName="Type"

CellButtonDisplay="Always" CellMultiline="No" Format="" IsBound="True"

Key="Type" SortIndicator="Disabled" Type="Custom" Width="130px"

EditorControlID="">

<HeaderStyle BackColor="Silver" />

<CellButtonStyle BackColor="Silver" Wrap="True">

</CellButtonStyle>

<Header Caption="Cluster" FixedHeaderIndicator="None">

</Header>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn AllowGroupBy="No" AllowNull="False" AllowResize="Fixed"

AllowRowFiltering="False" AllowUpdate="Yes" BaseColumnName="Amount"

CellMultiline="No" DataType="System.Double" Format="###,###,##0.00" IsBound="True"

Key="Amount" SortIndicator="Disabled" Width="80px" EditorControlID="EditC"

Type="Custom">

<HeaderStyle BackColor="Silver" />

<CellStyle HorizontalAlign="Right">

</CellStyle>

<Header Caption="€/#">

<RowLayoutColumnInfo OriginX="1" />

</Header>

<Footer>

<RowLayoutColumnInfo OriginX="1" />

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="Sortorder" Hidden="True" IsBound="True"

Key="Sortorder">

<Header Caption="Sortorder">

<RowLayoutColumnInfo OriginX="2" />

</Header>

<Footer>

<RowLayoutColumnInfo OriginX="2" />

</Footer>

</igtbl:UltraGridColumn>

</Columns>

</igtbl:UltraGridBand>

</bands>

<displaylayout

allowupdatedefault="Yes" bordercollapsedefault="Separate" name="grdGD"

rowheightdefault="20px" rowselectorsdefault="No" stationarymargins="Header"

stationarymarginsoutlookgroupby="True" tablelayout="Fixed" version="4.00"

usefixedheaders="True">

<framestyle backcolor="Window" bordercolor="InactiveCaption"

borderstyle="None" borderwidth="1px" font-names="Microsoft Sans Serif"

font-size="8.25pt" height="280px" width="280px">

</framestyle>

<pager minimumpagesfordisplay="2">

<PagerStyle BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">

<borderdetails colorleft="White" colortop="White" widthleft="1px"

widthtop="1px" />

</PagerStyle>

</pager>

<editcellstyledefault borderstyle="None" borderwidth="0px">

</editcellstyledefault>

<footerstyledefault backcolor="LightGray" borderstyle="Solid" borderwidth="1px">

<borderdetails colorleft="White" colortop="White" widthleft="1px"

widthtop="1px" />

</footerstyledefault>

<headerstyledefault backcolor="LightGray" borderstyle="Solid"

horizontalalign="Left">

<borderdetails colorleft="White" colortop="White" widthleft="1px"

widthtop="1px" />

</headerstyledefault>

<rowstyledefault backcolor="Window" bordercolor="Silver" borderstyle="Solid"

borderwidth="1px" font-names="Microsoft Sans Serif" font-size="8.25pt">

<padding left="3px" />

<borderdetails colorleft="Window" colortop="Window" />

</rowstyledefault>

<groupbyrowstyledefault backcolor="Control" bordercolor="Window">

</groupbyrowstyledefault>

<groupbybox>

<boxstyle backcolor="ActiveBorder" bordercolor="Window">

</boxstyle>

</groupbybox>

<addnewbox>

<boxstyle backcolor="Window" bordercolor="InactiveCaption" borderstyle="Solid"

borderwidth="1px">

<borderdetails colorleft="White" colortop="White" widthleft="1px"

widthtop="1px" />

</boxstyle>

</addnewbox>

<activationobject bordercolor="" borderwidth="">

</activationobject>

<filteroptionsdefault>

<filterdropdownstyle backcolor="White" bordercolor="Silver" borderstyle="Solid"

borderwidth="1px" customrules="overflow:auto;"

font-names="Verdana,Arial,Helvetica,sans-serif" font-size="11px" height="300px"

width="200px">

<padding left="2px" />

</filterdropdownstyle>

<filterhighlightrowstyle backcolor="#151C55" forecolor="White">

</filterhighlightrowstyle>

<filteroperanddropdownstyle backcolor="White" bordercolor="Silver"

borderstyle="Solid" borderwidth="1px" customrules="overflow:auto;"

font-names="Verdana,Arial,Helvetica,sans-serif" font-size="11px">

<padding left="2px" />

</filteroperanddropdownstyle>

</filteroptionsdefault>

</displaylayout>

</igtbl:UltraWebGrid>