Hello,
I have a RadGrid with GridNumericColumn and EditMode="Batch"
Here is column definition
<telerik:GridNumericColumn DataField="CheckAmount" UniqueName="CheckAmount" HeaderText="Check Amount ($)" DataFormatString="{0:C2}" DecimalDigits="2" NumericType="Number" ColumnEditorID="NumericEditor" ItemStyle-HorizontalAlign="Right"></telerik:GridNumericColumn>
Here is column editor definition
<telerik:GridNumericColumnEditor runat="server" ID="NumericEditor">
<NumericTextBox runat="server" NumberFormat-DecimalDigits="2" DataFormatString="{0:C2}" NumberFormat-GroupSeparator="" MinValue="0.00" MaxValue="99999999.99" IncrementSettings-InterceptArrowKeys="false" IncrementSettings-InterceptMouseWheel="false"></NumericTextBox>
</telerik:GridNumericColumnEditor>
Currently, when I edit a number two zeroes are automatically added after a decimal point, for example, 1234 gets converted to 1234.00. I would like to implement functionality when user can type in "cents" and amount gets converted to "dollars.cents", for example 1234 should be converted to 12.34. Could you please suggest how to implement it?
And to expand my original question, I also need to deny entering of empty and negative amounts preferably with validation messages instead of out of range auto correct. Is it possible to achieve with GridNumericColumn/GridNumericColumnEditor or do I need to use GridTempateColumn with EditItemTemplate?
Thanks,
Olga