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

GridNumericColumn with Decimal Digits when Edit

31 Answers 1936 Views

Grid

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

31 Answers, 1 is accepted

answered on 20 Dec 2008, 06:29 PM

Hello Henrique,

You can easily control the way the numbers are formatted using GridTemplateColumn and RadNumericTextBox control.

    
            <telerik:GridTemplateColumn HeaderText="Valor" SortExpression="Valor" UniqueName="Valor"> 
        
                <ItemStyle HorizontalAlign="Right"></ItemStyle> 
        
                <ItemTemplate> 
        
                    ... 
        
                </ItemTemplate> 
        
                <EditItemTemplate> 
        
                    <telerik:RadNumericTextBox ID="RadNumericTextBox1" runat="server" DataType="System.Decimal" 
        
                        Value='<%# Bind("Valor") %>' Type="Currency" NumberFormat-DecimalDigits="2" /> 
        
                </EditItemTemplate> 
        
            </telerik:GridTemplateColumn>

Please let us know whether this suits your scenario.

Best regards,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

Accepted

answered on 16 Dec 2010, 11:37 PM

RadGridEdit.jpg

InPlace editing of a GridNumericColumn still won't show the proper number of decimal places:

Here is the grid markup:

<telerik:RadGrid ID="radgrdProgramServiceCostingSheet" runat="server" Width="980px" DataSourceID="odsGetServiceCostingSheet" EnableLinqExpressions="true"

ShowStatusBar="true" AllowAutomaticUpdates="false"

AutoGenerateColumns="false" AllowFilteringByColumn="false" AllowPaging="false" AllowSorting="true">

<ClientSettings EnableRowHoverStyle="true" Selecting-AllowRowSelect="true" Scrolling-AllowScroll="true" Scrolling-ScrollHeight="280px" EnablePostBackOnRowClick="true" /> <%--ClientEvents-OnPopUpShowing="CostingSheetEditPopUpShowing" --%>

<GroupingSettings CaseSensitive="false" />

<MasterTableView TableLayout="Fixed" DataKeyNames=

"fldCostingSheetID,fldCostingSheetHeaderID,fldServiceVenueItemID,fldCostPerUnit,fldUnits,fldHours,fldGratuity,GP,fldTax,fldTaxable,PricingOption,BillType,fldPricingOptionID,fldBilltype"

EditMode="InPlace" > <%--EditFormSettings-PopUpSettings-Modal="true"--%>

<HeaderStyle HorizontalAlign="Left" />

<ItemStyle Wrap="false" />

<AlternatingItemStyle Wrap="false" />

<Columns>

<telerik:GridEditCommandColumn ButtonType="LinkButton" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-Width="45px" EditText="" UpdateText="" CancelText="" UniqueName="EditButton" />

<telerik:GridBoundColumn DataField="Category" HeaderText="Cat" SortExpression="Category" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-Width="48px" UniqueName="Category" />

<telerik:GridBoundColumn DataField="VendorName" HeaderText="Vendor" SortExpression="VendorName" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-Width="135px" UniqueName="VendorName" />

<telerik:GridBoundColumn DataField="fldCostingItem" HeaderText="Costing Item" SortExpression="fldCostingItem" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-Width="125px" UniqueName="fldCostingItem" />

<telerik:GridNumericColumn DataField="fldCostPerUnit" HeaderText="Unit Cost" SortExpression="fldCostPerUnit" DataFormatString="{0:C2}" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="80px" UniqueName="fldCostPerUnit" DecimalDigits="2" NumericType="Currency" KeepNotRoundedValue="true" />

<telerik:GridNumericColumn DataField="fldHours" HeaderText="Hrs" SortExpression="fldHours" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="30px" UniqueName="fldHours" />

<telerik:GridBoundColumn DataField="fldGratuity" HeaderText="Grat" SortExpression="fldGratuity" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="30px" UniqueName="fldGratuity" />

<telerik:GridBoundColumn DataField="fldUnits" HeaderText="Units" SortExpression="fldUnits" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="30px" UniqueName="fldUnits" />

<telerik:GridBoundColumn DataField="fldTax" HeaderText="Tax" SortExpression="fldTax" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="35px" UniqueName="fldTax" />

<telerik:GridCheckBoxColumn DataField="fldTaxable" HeaderText="Tax?" SortExpression="fldTaxable" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-Width="35px" UniqueName="fldTaxable" />

<telerik:GridBoundColumn DataField="fldCost" HeaderText="Cost" SortExpression="fldCost" DataFormatString="{0:C2}" HeaderStyle-CssClass="radGridViewHeader" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="110px" UniqueName="fldCost" />

<telerik:GridBoundColumn DataField="GP" HeaderText="GP" SortExpression="GP" DataFormatString="{0:0%}" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="35px" UniqueName="GP" />

<telerik:GridBoundColumn DataField="fldUnitRev" HeaderText="Unit Rev" SortExpression="fldUnitRev" DataFormatString="{0:C2}" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="80px" UniqueName="fldUnitRev" />

<telerik:GridBoundColumn DataField="PricingOption" HeaderText="Pricing Opt" SortExpression="PricingOption" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-Width="55px" UniqueName="PricingOption" />

<telerik:GridBoundColumn DataField="fldRevenue" HeaderText="Revenue" SortExpression="fldRevenue" DataFormatString="{0:C2}" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="110px" UniqueName="fldRevenue" />

<telerik:GridBoundColumn DataField="fldRevPerPerson" HeaderText="Rev PP" SortExpression="fldRevPerPerson" DataFormatString="{0:C2}" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="95px" UniqueName="fldRevPerPerson" />

<telerik:GridBoundColumn DataField="CommOption" HeaderText="Comm" SortExpression="CommOption" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-Width="80px" UniqueName="CommOption" />

<telerik:GridBoundColumn DataField="BillType" HeaderText="Bill Type" SortExpression="BillType" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-Width="80px" UniqueName="BillType" />

<telerik:GridBoundColumn DataField="fldGroupType" HeaderText="Group" SortExpression="fldGroupType" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-Width="50px" ItemStyle-HorizontalAlign="Right" UniqueName="fldGroupType" />

<telerik:GridBoundColumn DataField="fldSortOrder" HeaderText="Sort" SortExpression="fldSortOrder" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-Width="40px" ItemStyle-HorizontalAlign="Right" UniqueName="fldSortOrder" />

<telerik:GridBoundColumn DataField="fldTax1" UniqueName="fldTax1" Visible="false" ReadOnly="true" />

<telerik:GridBoundColumn DataField="fldTax2" UniqueName="fldTax2" Visible="false" ReadOnly="true" />

</Columns>

</MasterTableView>

</telerik:RadGrid>

Note the Unit Cost column. Also, if a cell is a whole-dollar amount, there is no decimal at all, much less the ".00' that should be showing.

I don't get why the InPlace Edit Mode can't assume the same styling as the ItemTemplate has.

answered on 20 Dec 2010, 01:04 PM

Hello Jerry T.,

Try setting AllowRounding="true":

Veli
the Telerik team

Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

answered on 20 Dec 2010, 04:08 PM

Ok, another problem has reared its head.

For any columns that are read-only (I don't want users to be able to edit the values), the number of decimals jump back to 4 digits:

<telerik:GridNumericColumn DataField="fldUnitRev" HeaderText="Unit&nbsp;Rev" SortExpression="fldUnitRev" DataFormatString="{0:C2}" HeaderStyle-CssClass="radGridViewHeader" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="80px" UniqueName="fldUnitRev" ReadOnly="true" DecimalDigits="2" AllowRounding="true" NumericType="Currency" />

I've tried various combinations of attributes and even went back to the GridBoundColumn but nothing works. I'd hate to have to end up using a GridTemplateColumn just to get two decimal places to show instead of four.

Jerry

answered on 21 Dec 2010, 09:32 AM

Yes, this is because the settings you specify for the number formatting are applied to RadNumericTextBox initialized when your column is editable. When you are using a read-only column, RadNumericTextBox is not initialized and is not used to format you data values.

Nevertheless, we confirm an inconsistent behavior of the GridNumericColumn with respect to formatting of the data values in view mode and in edit mode when the column is read-only. I have notified our dev team of this issue and they will look into it on a first occasion. Please excuse us for the inconvenience. As a work-around, you need to programmatically find the value in the edit form and format it. You can use RadGrid's ItemDataBound event for that:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)

{

    if (e.Item is GridEditableItem && e.Item.IsInEditMode)

    {

        GridEditableItem editItem = (GridEditableItem)e.Item;

        double fldUnitRev = Double.Parse((editItem["fldUnitRev"].Controls[1] as Literal).Text);

        editItem["fldUnitRev"].Text = fldUnitRev.ToString("C2");

    }

}

Let me know how that works for you.

Veli
the Telerik team

answered on 21 Dec 2010, 03:20 PM

Thanks, Veli.

That workaround shows the proper format now.

But I have found yet another inconsistency (bug?)

If a column is marked Read-Only in the markup, it cannot be changed in the codebehind (either in ItemCreated or ItemDatabound) but if it's NOT Read-Only in the markup, it CAN be changed to read-only in the codebehind in the ItemCreated event:

<telerik:GridNumericColumn DataField="fldCost" HeaderText="Cost" SortExpression="fldCost" DataFormatString="{0:C2}" HeaderStyle-CssClass="radGridViewHeader" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="110px" UniqueName="fldCost" DecimalDigits="2" AllowRounding="true" KeepNotRoundedValue="true" NumericType="Currency" />

Private Sub radgrdProgramServiceCostingSheet_ItemCreated(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles radgrdProgramServiceCostingSheet.ItemCreated

If (TypeOf e.Item Is GridEditableItem) And e.Item.IsInEditMode Then

Dim gei As GridEditableItem = DirectCast(e.Item, GridEditableItem)

Dim numtxtRevenue As RadNumericTextBox = DirectCast(gei("fldRevenue").Controls(0), RadNumericTextBox)

numtxtRevenue.Enabled = (gei("PricingOption").Text <> "1") 'Not GP-based

Dim numtxtCost As RadNumericTextBox = DirectCast(gei("fldCost").Controls(0), RadNumericTextBox)

numtxtCost.ReadOnly = True

'numtxtCost.Enabled = True

End If

End Sub

We have a couple of columns in this grid that will need to be disabled/enabled based on various conditions that can change with the row itself being edited. It appears if I set the column in the markup to NOT be read-only, then I can use the .Enabled = False/True in order to make it not editable/editable as a workaround, though. But I cannot change the .ReadOnly property value if it is set to be ReadOnly="True" in the markup.

answered on 22 Dec 2010, 02:22 PM

You can programmatically set the HorizontalAlign properties of the various styles the RadNumericTextBox instance in your edited item exposes. If you were using a stand-alone RadNumericTextBox, you would have:

<telerik:RadNumericTextBox ID="RadNumericTextBox1" runat="server" Type="Currency"

EnabledStyle-HorizontalAlign="Right"

HoveredStyle-HorizontalAlign="Right"

DisabledStyle-HorizontalAlign="Right"

EmptyMessageStyle-HorizontalAlign="Right"

FocusedStyle-HorizontalAlign="Right"

InvalidStyle-HorizontalAlign="Right"

NegativeStyle-HorizontalAlign="Right"

ReadOnlyStyle-HorizontalAlign="Right">

</telerik:RadNumericTextBox>

The above settings will have the numeric box right-align its cell text in all of the above states. With a numeric textbox in a grid column editor, you would need to use RadGrid's ItemDataBound event again to find RadNumericTextBox and set its properties programmatically:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)

{

if (e.Item is GridEditableItem && e.Item.IsInEditMode)

{

GridEditableItem editItem = (GridEditableItem)e.Item;

GridNumericColumnEditor numEditor = (GridNumericColumnEditor)editItem.EditManager.GetColumnEditor("Price");

numEditor.NumericTextBox.EnabledStyle.HorizontalAlign = HorizontalAlign.Right;

numEditor.NumericTextBox.DisabledStyle.HorizontalAlign = HorizontalAlign.Right;

numEditor.NumericTextBox.HoveredStyle.HorizontalAlign = HorizontalAlign.Right;

numEditor.NumericTextBox.EmptyMessageStyle.HorizontalAlign = HorizontalAlign.Right;

numEditor.NumericTextBox.FocusedStyle.HorizontalAlign = HorizontalAlign.Right;

numEditor.NumericTextBox.InvalidStyle.HorizontalAlign = HorizontalAlign.Right;

numEditor.NumericTextBox.NegativeStyle.HorizontalAlign = HorizontalAlign.Right;

numEditor.NumericTextBox.ReadOnlyStyle.HorizontalAlign = HorizontalAlign.Right;

}

Now you get a completely right-aligned numeric textbox.

Veli
the Telerik team

answered on 22 Dec 2010, 03:50 PM

RadGridEdit2.jpg

Thanks, Veli.

But, there should still be ONE attribute set in the markup for the GridNumericColumn that allows setting the value to be right-aligned in the regular grid and in edit mode. Adding 8 lines of code in the codebehind seems very inefficient. It's great having all of those attributes available but they should only serve to customize something that would be an exception to an over-arching attribute setting.

Also, when I use the HorizontalAlign property and set it to Right, when I go into edit mode, the value disappears in the cell. I have to click on the cell before it appears.

markup:

<telerik:RadGrid ID="radgrdProgramServiceCostingSheet" runat="server" DataSourceID="odsGetServiceCostingSheet" EnableLinqExpressions="true" Width="100%"

ShowStatusBar="true" AllowAutomaticUpdates="false"

AutoGenerateColumns="false" AllowFilteringByColumn="false" AllowPaging="false" AllowSorting="true">

<GroupingSettings CaseSensitive="false" />

<MasterTableView TableLayout="Fixed" DataKeyNames=

"fldCostingSheetID,fldCostingSheetHeaderID,fldServiceVenueItemID,fldCostPerUnit,fldUnits,fldHours,fldGratuity,GP,fldTax,fldTaxable,PricingOption,BillType,fldPricingOptionID,fldBilltype,Category"

EditMode="InPlace" > <%--EditFormSettings-PopUpSettings-Modal="true"--%>

<HeaderStyle HorizontalAlign="Left" />

<ItemStyle Wrap="false" />

<AlternatingItemStyle Wrap="false" />

<Columns>

<telerik:GridTemplateColumn DataField="Category" HeaderText="Cat" SortExpression="Category" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-Width="55px" UniqueName="Category" >

<ItemTemplate>

<%# String.Format("{0:c}", Eval("Category"))%>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadComboBox ID="rcbCategory" runat="server" Width="55px" DropDownWidth="75px"

EnableEmptyListItem="false"

DataSourceId="odsGetCostingSheetCostCategories"

DataValueField="CostCatAbv"

DataTextField="CostCatAbv"

SelectedValue="<%# Bind('Category') %>">

</telerik:RadComboBox>

</EditItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridNumericColumn DataField="fldCostPerUnit" HeaderText="Unit Cost" SortExpression="fldUnitRev" DataFormatString="{0:C2}" HeaderStyle-CssClass="radGridViewHeader" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="80px" UniqueName="fldCostPerUnit" DecimalDigits="2" AllowRounding="true" NumericType="Currency" />

<telerik:GridNumericColumn DataField="fldGratuity" HeaderText="Grat" SortExpression="fldGratuity" DataFormatString="{0:0%}" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="30px" UniqueName="fldGratuity" />

<telerik:GridNumericColumn DataField="fldUnits" HeaderText="Units" SortExpression="fldUnits" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="30px" UniqueName="fldUnits" />

<telerik:GridNumericColumn DataField="fldTax" HeaderText="Tax" SortExpression="fldTax" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="35px" UniqueName="fldTax" DecimalDigits="2" AllowRounding="true" KeepNotRoundedValue="true" />

<telerik:GridNumericColumn DataField="GP" HeaderText="GP" SortExpression="GP" DataFormatString="{0:0%}" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="35px" UniqueName="GP" />

<telerik:GridNumericColumn DataField="fldUnitRev" HeaderText="Unit Rev" SortExpression="fldUnitRev" DataFormatString="{0:C2}" HeaderStyle-CssClass="radGridViewHeader" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="80px" UniqueName="fldUnitRev" DecimalDigits="2" AllowRounding="true" KeepNotRoundedValue="true" NumericType="Currency" />

<telerik:GridTemplateColumn DataField="PricingOption" HeaderText="Pricing Opt" SortExpression="PricingOption" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-Width="75px" UniqueName="PricingOption" >

<ItemTemplate>

<%# String.Format("{0:c}", Eval("PricingOption"))%>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadComboBox ID="rcbPricingOption" runat="server" Width="75px" DropDownWidth="100px" Height="80px"

AutoPostBack="true"

EnableEmptyListItem="false"

DataSourceId="odsGetCostingSheetPricingOptions"

DataValueField="PricingOption"

DataTextField="PricingOption"

SelectedValue="<%# Bind('PricingOption') %>"

OnSelectedIndexChanged="rcbPricingOption_SelectedIndexChanged">

</telerik:RadComboBox>

</EditItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridNumericColumn DataField="fldRevenue" HeaderText="Revenue" SortExpression="fldRevenue" DataFormatString="{0:C2}" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="110px" UniqueName="fldRevenue" DecimalDigits="2" AllowRounding="true" KeepNotRoundedValue="true" NumericType="Currency" />

<telerik:GridNumericColumn DataField="fldRevPerPerson" HeaderText="Rev PP" SortExpression="fldRevPerPerson" DataFormatString="{0:C2}" HeaderStyle-CssClass="radGridViewHeader" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="95px" UniqueName="fldRevPerPerson" DecimalDigits="2" AllowRounding="true" KeepNotRoundedValue="true" NumericType="Currency" />

<telerik:GridBoundColumn DataField="fldTax1" UniqueName="fldTax1" Visible="false" ReadOnly="true" />

<telerik:GridBoundColumn DataField="fldTax2" UniqueName="fldTax2" Visible="false" ReadOnly="true" />

</Columns>

</MasterTableView>

</telerik:RadGrid>

codebehind:

Private Sub radgrdProgramServiceCostingSheet_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles radgrdProgramServiceCostingSheet.ItemDataBound

If (TypeOf e.Item Is GridDataItem) Then

*bunch of unrelated stuff snipped*

If (TypeOf e.Item Is GridEditableItem) And e.Item.IsInEditMode Then

Dim gei As GridEditableItem = DirectCast(e.Item, GridEditableItem)

Dim numtxtGP As RadNumericTextBox = DirectCast(gei("GP").Controls(0), RadNumericTextBox)

Dim numtxtUnitRev As RadNumericTextBox = DirectCast(gei("fldUnitRev").Controls(0), RadNumericTextBox)

Dim numtxtRevenue As RadNumericTextBox = DirectCast(gei("fldRevenue").Controls(0), RadNumericTextBox)

Dim rcbPricingOpt As RadComboBox = DirectCast(gei("PricingOption").FindControl("rcbPricingOption"), RadComboBox)

numtxtUnitRev.DisabledStyle.HorizontalAlign = HorizontalAlign.Right

numtxtUnitRev.EmptyMessageStyle.HorizontalAlign = HorizontalAlign.Right

numtxtUnitRev.EnabledStyle.HorizontalAlign = HorizontalAlign.Right

numtxtUnitRev.FocusedStyle.HorizontalAlign = HorizontalAlign.Right

numtxtUnitRev.HoveredStyle.HorizontalAlign = HorizontalAlign.Right

numtxtUnitRev.InvalidStyle.HorizontalAlign = HorizontalAlign.Right

numtxtUnitRev.ReadOnlyStyle.HorizontalAlign = HorizontalAlign.Right

End If

End Sub

answered on 23 Dec 2010, 09:47 AM

testpage.zip

I am consistently unable to reproduce this issue with the version you have indicated. Attaching a test page. Can you try to reproduce this issue in it?

Veli
the Telerik team

answered on 23 Dec 2010, 05:24 PM

Ok...in the long run, this is what works for me:

If (TypeOf e.Item Is GridEditableItem) And e.Item.IsInEditMode Then

Dim gei As GridEditableItem = DirectCast(e.Item, GridEditableItem)

Dim numtxtUnitCost As RadNumericTextBox = DirectCast(gei("fldCostPerUnit").Controls(0), RadNumericTextBox)

Dim numtxtGP As RadNumericTextBox = DirectCast(gei("GP").Controls(0), RadNumericTextBox)

Dim numtxtUnitRev As RadNumericTextBox = DirectCast(gei("fldUnitRev").Controls(0), RadNumericTextBox)

Dim numtxtRevenue As RadNumericTextBox = DirectCast(gei("fldRevenue").Controls(0), RadNumericTextBox)

Dim rcbPricingOpt As RadComboBox = DirectCast(gei("PricingOption").FindControl("rcbPricingOption"), RadComboBox)

numtxtUnitCost.Width = 80

numtxtUnitCost.NumberFormat.DecimalDigits = 2

numtxtUnitCost.NumberFormat.KeepNotRoundedValue = True

numtxtUnitCost.NumberFormat.KeepTrailingZerosOnFocus = True

numtxtUnitCost.NumberFormat.AllowRounding = True

numtxtUnitCost.DisabledStyle.HorizontalAlign = HorizontalAlign.Right

numtxtUnitCost.EnabledStyle.HorizontalAlign = HorizontalAlign.Right

numtxtUnitRev.Width = 80

numtxtUnitRev.NumberFormat.DecimalDigits = 2

numtxtUnitRev.NumberFormat.KeepNotRoundedValue = True

numtxtUnitRev.NumberFormat.KeepTrailingZerosOnFocus = True

numtxtUnitRev.NumberFormat.AllowRounding = True

numtxtUnitRev.DisabledStyle.HorizontalAlign = HorizontalAlign.Right

numtxtUnitRev.EnabledStyle.HorizontalAlign = HorizontalAlign.Right

and all of that code is just to be sure that two columns have the same formatting that I specified in the markup for the RadGrid for those columns. I have 3 other columns yet to do the same for.

We *really* need that formatting to pass through to edit mode as a default instead of having to write all that unnecessary code on the server side.

Thanks.

answered on 26 Apr 2016, 07:55 PM

I ve this GridNumericColumn, i using batch edit mode, but in edit mode cant Apply Format In Edit Mode, so i need know if this issue was fixed im using 2016 paid licence.

<telerik:GridNumericColumn HeaderStyle-Width="100" ItemStyle-HorizontalAlign="Right" FooterStyle-HorizontalAlign="Right" DecimalDigits="2" Aggregate="Sum" FooterText=" " DataField="NOMW_CONCEPTO01" HeaderText="Concepto_01" UniqueName="NOMW_CONCEPTO01" Visible="false" ReadOnly="false" AllowFiltering="false" Groupable="false" ColumnValidationSettings-EnableRequiredFieldValidation="true" EmptyDataText="0.00" DataFormatString="{0:N2}"></telerik:GridNumericColumn>