Hello,
I have two questions about formatting column.
1/ Percent format
- I have a column needs format percent. I used DataFormatString="{0:P2}" for this column. When I enter "30.45" to a cell and exit edit mode, the cell displayed "3045.00%". I don't want this cell multiply to 100 auto.
2/ Currency editor
- I have set DataFormatString="{0:C2}" and used CurrencyEditorProvider for this column. When load data, cell displayed "500$" but when I click to cell to edit, the cell displayed "0" and I can't get value of cell by client.
How to solve its?
I forget provide my aspx file. I'm using NetAdvantage version 14.1.20141.2011 latest release. This is my code:
<ig:WebDataGrid ID="UG_PricingTiers" runat="server" Height="175px" Width="100%" AutoGenerateColumns="False" EnableDataViewState="True" DataKeyFields="ID" EnableAjax="False" Font-Bold="False"> <Columns> <ig:BoundDataField DataFieldName="SRVC_Ledger_Tier_Code_Type_Lkup_ID" Key="SRVC_Ledger_Tier_Code_Type_Lkup_ID" Width="5%" CssClass="ReadOnlyTextLeft"> <Header Text="Tier ID" CssClass="NormalTextCenter"></Header> <Footer CssClass="NormalTextCenter"></Footer> </ig:BoundDataField> <ig:BoundDataField CssClass="ReadOnlyTextLeft" DataFieldName="SRVC_Terms_Tier_Type_Lkup_ID" Key="SRVC_Terms_Tier_Type_Lkup_ID" Width="15%"> <Header Text="Tier Type" CssClass="NormalTextCenter"></Header> <Footer CssClass="NormalTextCenter"></Footer> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Tier_Threshold_Amt" Key="Tier_Threshold_Amt" Width="10%" DataFormatString="{0:C2}" CssClass="ReadOnlyTextRight" DataType="System.String"> <Header Text="Tier Threshold Amount" CssClass="NormalTextCenter"></Header> <Footer CssClass="NormalTextCenter"></Footer> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Effective_Dt" Key="Effective_Dt" Width="10%" CssClass="ReadOnlyTextLeft" DataType="System.DateTime"> <Header Text="Effective Date" CssClass="NormalTextCenter"></Header> <Footer CssClass="NormalTextCenter"></Footer> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Common_Int_Index_Lkup_ID" Key="Common_Int_Index_Lkup_ID" Width="15%" CssClass="ReadOnlyTextLeft" DataType="System.Object"> <Header Text="Pricing Index" CssClass="NormalTextCenter"></Header> <Footer CssClass="NormalTextCenter"></Footer> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Interest_Rate_Pct" Key="Interest_Rate_Pct" Width="15%" DataFormatString="{0:P5}" CssClass="ReadOnlyTextRight"> <Header Text="Rate" CssClass="NormalTextCenter"></Header> <Footer CssClass="NormalTextCenter"></Footer> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Interest_Floor_Pct" Key="Interest_Floor_Pct" Width="15%" DataFormatString="{0:P5}" CssClass="ReadOnlyTextRight"> <Header Text="Floor" CssClass="NormalTextCenter"></Header> <Footer CssClass="NormalTextCenter"></Footer> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Interest_Ceiling_Pct" Key="Interest_Ceiling_Pct" Width="15%" DataFormatString="{0:P5}" CssClass="ReadOnlyTextRight"> <Header Text="Ceiling" CssClass="NormalTextCenter"></Header> <Footer CssClass="NormalTextCenter"></Footer> </ig:BoundDataField> <ig:BoundDataField DataFieldName="ID" Key="ID" Hidden="True"></ig:BoundDataField> <ig:BoundDataField DataFieldName="SRVC_FixedFloat_Type_Lkup_ID" Key="SRVC_FixedFloat_Type_Lkup_ID" Hidden="True"></ig:BoundDataField> <ig:BoundDataField DataFieldName="Common_Accrl_Basis_Code_Lkup_ID" Key="Common_Accrl_Basis_Code_Lkup_ID" Hidden="True"></ig:BoundDataField> <ig:BoundDataField DataFieldName="SRVC_Interest_Rate_Change_Frequency_Type_Lkup_ID" Key="SRVC_Interest_Rate_Change_Frequency_Type_Lkup_ID" Hidden="True"></ig:BoundDataField> <ig:BoundDataField DataFieldName="SRVC_Terms_Rate_Change_Apply_Lkup_ID" Key="SRVC_Terms_Rate_Change_Apply_Lkup_ID" Hidden="True"></ig:BoundDataField> <ig:BoundDataField DataFieldName="SRVC_Arms_Plan_Type_Lkup_ID" Key="SRVC_Arms_Plan_Type_Lkup_ID" Hidden="True"></ig:BoundDataField> <ig:BoundDataField DataFieldName="SRVC_Terms_Default_Rate_Plan_Type_Lkup_ID" Key="SRVC_Terms_Default_Rate_Plan_Type_Lkup_ID" Hidden="True"></ig:BoundDataField> <ig:BoundDataField DataFieldName="Interest_Index_Release_1_Pct" Key="Interest_Index_Release_1_Pct" Hidden="True"></ig:BoundDataField> <ig:BoundDataField DataFieldName="Interest_Index_Release_2_Pct" Key="Interest_Index_Release_2_Pct" Hidden="True"></ig:BoundDataField> <ig:BoundDataField DataFieldName="Interest_Relationship_Code_1" Key="Interest_Relationship_Code_1" Hidden="True"></ig:BoundDataField> <ig:BoundDataField DataFieldName="Interest_Relationship_Code_2" Key="Interest_Relationship_Code_2" Hidden="True"></ig:BoundDataField> <ig:UnboundField Hidden="True" Key="Status" /> <ig:UnboundField Key="uSRVC_Ledger_Tier_Code_Type_Lkup_ID" Hidden="True"></ig:UnboundField> <ig:UnboundField Key="uSRVC_Terms_Tier_Type_Lkup_ID" Hidden="True"></ig:UnboundField> <ig:UnboundField Key="uTier_Threshold_Amt" Hidden="True"></ig:UnboundField> <ig:UnboundField Key="uCommon_Int_Index_Lkup_ID" Hidden="True"></ig:UnboundField> </Columns> <EditorProviders> <ig:DropDownProvider ID="Ledger_Tier_Code_Provider" StretchHeight="False"> <EditorControl DropDownContainerMaxHeight="160px" EnableAnimations="False" DisplayMode="DropDownList" NullText="0" DropDownContainerHeight="160px"> <ClientEvents DropDownOpening="DropDownProvider_Opening" /> </EditorControl> </ig:DropDownProvider> <ig:DropDownProvider ID="SRVC_Terms_Tier_Type_Provider" StretchHeight="False"> <EditorControl DropDownContainerMaxHeight="160px" EnableAnimations="False" DisplayMode="DropDownList" NullText="0" DropDownContainerHeight="160px"> <ClientEvents DropDownOpening="DropDownProvider_Opening" /> </EditorControl> </ig:DropDownProvider> <ig:DropDownProvider ID="Common_Int_Index_Prodiver" StretchHeight="False"> <EditorControl DropDownContainerMaxHeight="160px" EnableAnimations="False" DisplayMode="DropDownList" NullText="0" DropDownContainerHeight="160px"> <ClientEvents DropDownOpening="DropDownProvider_Opening" /> </EditorControl> </ig:DropDownProvider> <ig:DatePickerProvider ID="Effective_Dt_PricingTiers_Provider"> <EditorControl runat="server" EditModeFormat="MM/dd/yyyy" EnableViewState="true"> </EditorControl> </ig:DatePickerProvider> <ig:CurrencyEditorProvider ID="TB_Currency_PricingTiers"> <EditorControl runat="server" CssClass="TextRight" MaxLength="10" MinDecimalPlaces="2"> </EditorControl> </ig:CurrencyEditorProvider> <ig:PercentEditorProvider ID="TB_Percent_PricingTiers"> <EditorControl runat="server" CssClass="TextRight" MaxLength="10" MinDecimalPlaces="5"> </EditorControl> </ig:PercentEditorProvider> </EditorProviders> <Behaviors> <ig:EditingCore BatchUpdating="True"> <Behaviors> <ig:CellEditing Enabled="true" EditCellCssClass="NormalText"> <ColumnSettings> <ig:EditingColumnSetting ColumnKey="SRVC_Ledger_Tier_Code_Type_Lkup_ID" EditorID="Ledger_Tier_Code_Provider" /> <ig:EditingColumnSetting ColumnKey="SRVC_Terms_Tier_Type_Lkup_ID" EditorID="SRVC_Terms_Tier_Type_Provider" /> <ig:EditingColumnSetting ColumnKey="Common_Int_Index_Lkup_ID" EditorID="Common_Int_Index_Prodiver" /> <ig:EditingColumnSetting ColumnKey="Effective_Dt" EditorID="Effective_Dt_PricingTiers_Provider" /> <ig:EditingColumnSetting ColumnKey="Tier_Threshold_Amt" EditorID="TB_Currency_PricingTiers" /> <ig:EditingColumnSetting ColumnKey="Interest_Rate_Pct" EditorID="TB_Percent_PricingTiers" /> <ig:EditingColumnSetting ColumnKey="Interest_Floor_Pct" EditorID="TB_Percent_PricingTiers" /> <ig:EditingColumnSetting ColumnKey="Interest_Ceiling_Pct" EditorID="TB_Percent_PricingTiers" /> </ColumnSettings> <CellEditingClientEvents EnteringEditMode="UG_PricingTiers_CellEditing_EnteringEditMode" /> <EditModeActions MouseClick="Single" EnableOnActive="True" /> </ig:CellEditing> </Behaviors> </ig:EditingCore> <ig:Sorting Enabled="true"> <SortingClientEvents ColumnSorting="" /> </ig:Sorting> <ig:Activation Enabled="true"> <ActivationClientEvents ActiveCellChanging="" /> </ig:Activation> <ig:Selection CellClickAction="Cell" RowSelectType="Single" Enabled="true"> </ig:Selection> <ig:RowSelectors Enabled="True" RowNumbering="False" EnableInheritance="True"> <RowSelectorClientEvents RowSelectorClicked="UG_PricingTiers_RowSelector_RowSelectorClicked" /> </ig:RowSelectors> <ig:Paging PagerAppearance="Bottom" PageSize="6" Enabled="false" QuickPages="9" /> <ig:ColumnResizing> <ColumnSettings> <ig:ColumnResizeSetting /> </ColumnSettings> </ig:ColumnResizing> </Behaviors> </ig:WebDataGrid>