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>
Hello Manh,
Thank you for contacting Infragistics Developer Support!
This is an initial update to let you know that we have received your support request and I am currently looking into this issue. I was able to reproduce the behavior that you are describing. I will look further into this matter in order to find the root cause for this issue and I will keep you posted on my progress.
Please feel free to continue sending updates to this case at any time.
Hello Vasya,
I am also facing this issue.
Could you please send me the solution on this account.
Hi Manh,
I just want to update you that the service release that fix this issue is ready and you can download it form the My keys and download section under the Service release Tab:
Please let us know if you still experience any issues.
Thank you for your patience.
I created the following case for you CAS-138003-R0G2Y3 and I will update you through it. You could see it in your account in the "Support Activity" page.
Please let me know if you have any additional questions regarding this matter.
Thank for your reply. I looking forward hearing from you.