I have an UltraGrid bound to a DataTable with an Amount column of type double.
I have set the Column.Style to Double in addition to other properties.
col.Header.Caption = "Value";
col.SortIndicator = SortIndicator.Ascending;
col.Width = 150;
col.CellClickAction = AllowEdit ? CellClickAction.Edit : CellClickAction.RowSelect;
col.CellAppearance.BackColor = AllowEdit ? Color.LightYellow : _defGridBackColor;
col.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Double;
col.Nullable = Infragistics.Win.UltraWinGrid.Nullable.Disallow;
col.MaxLength = 20;
col.MaxValue = 1000000000000;
col.Format = "###,###,###,##0.#0";
col.PromptChar = '\0';
col.NullText = "None";
However, I am only able to enter a max value of 100,000,000.00 in the
column via the editor.
Setting MaxValue to say, 1 trillion, has no effect.
I can enter more than 100M if I set the MaskInput property. I wanted to know if there is another way of accomplishing this? MaskInput, for one, shows thousands placeholders, which I don't want.
If I enter more than 8 zeros, the cursor skips to the right of the decimal point. If I paste in 1000,000,000 it gets truncated to 100,000,000.00.
Also, if I remove the column.Style = Double line, it allows me to enter more than 100,000,000, which is why I suspected it is related to the column style.
I guess I should mention that I am using v10.3.
Hi,
I tried this out and it seems to work fine for me.I am able to enter 1000000000000 (the MaxValue you posted in your code here) with no problems.
What do you mean when you say "I am only able to enter a max value of 100,000,000.00 in the column via the editor." What exactly happens when you try?
Hello,
You could take a look at the following link about the 'Double' style of a column:
http://help.infragistics.com/NetAdvantage/WinForms/2011.2/CLR2.0/?page=Infragistics2.Win.UltraWinGrid.v11.2~Infragistics.Win.UltraWinGrid.ColumnStyle.html.
You could also try using 'UltraMaskedEdit' or 'UltraNumericEditor' for the mentioned column in your case and see if those controls suit your needs.
Please do not hesitate to contact us if you need any additional assistance.
I guess what I want is to increase or lift this arbitrary limit of 100 million without changing anything else such as introducing mask inputs which will confuse users. This limit applies to the Style.Currency as well, which doesn't seem to make sense. Surely that number is too low.