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.
<
telerik:RadGrid
ID
=
"radgrdProgramServiceCostingSheet"
runat
=
"server"
DataSourceID
=
"odsGetServiceCostingSheet"
EnableLinqExpressions
=
"true"
Width
=
"100%"
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,Category"
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: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: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
=
"fldUnitRev"
DataFormatString
=
"{0:C2}"
HeaderStyle-CssClass
=
"radGridViewHeader"
ItemStyle-HorizontalAlign
=
"Right"
HeaderStyle-Width
=
"80px"
UniqueName
=
"fldCostPerUnit"
DecimalDigits
=
"2"
AllowRounding
=
"true"
NumericType
=
"Currency"
/>
<
telerik:GridNumericColumn
DataField
=
"fldHours"
HeaderText
=
"Hrs"
SortExpression
=
"fldHours"
HeaderStyle-CssClass
=
"radGridViewHeader"
HeaderStyle-HorizontalAlign
=
"Center"
ItemStyle-HorizontalAlign
=
"Right"
HeaderStyle-Width
=
"30px"
UniqueName
=
"fldHours"
/>
<
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: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"
ReadOnly
=
"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
=
"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
>