Hi,

As Tony mentioned that if embedded editor provider is used, then editing and rendering is defined not by grid, but by editor. So, the only way around is to modify that editor (better to say: hack into its logic). All aspects of "embedded" features are defined by
Infragistics.WebUI.Shared.IProvidesEmbeddableEditor. There are few methods on server and few methods on client. You will be interested in the getRenderedValue and RenderValue members.

To adjust value provided by editor after user edited cell, you need to override the getRenderedValue member function. Example below will limit number of digits after dot to 1.

To support rendering of initial values is more complex. You need to remove WebNumericEdit from aspx, extend it and override its RenderValue. Below is example:

public partial class MyPage : System.Web.UI.Page
{
  // all your codes here

  private MyWebNumericEdit WebNumericEdit1;
  protected override void OnInit(EventArgs e)
  //or
  //protected void Page_Load(object sender, EventArgs e)
  {
     this.WebNumericEdit1 = new MyWebNumericEdit();
     this.WebNumericEdit1.ID = "WebNumericEdit1";
     this.WebNumericEdit1.ClientSideEvents.Initialize = "WebNumericEdit1_Initialize";
     this.Form.Controls.Add(this.WebNumericEdit1);
  }
}

internal class MyWebNumericEdit : Infragistics.WebUI.WebDataInput.WebNumericEdit
{
   public override string RenderValue(object value)
   {
       string val = base.RenderValue(value);
       int dot = val.IndexOf('.');
       if(dot > 0 && dot + 2 < val.Length)
           val = val.Substring(0, dot + 2);
       return val;
   }
}

Hi,

There are 2 similar editors Infragistics.Web.UI.EditorControls.WebNumericEditor and Infragistics.WebUI.WebDataInput.WebNumericEdit which are located in different dlls and target different base classes.
The architecture of editors for UltraWebGrid are based on embedded-editor interface, which is defined in shared dll. That dll is shared by controls located in Infragistics.WebUI, such as UltraWebGrid, WebTextEdit, WebDateChooser, etc. So, you need to replace Infragistics.Web.UI.EditorControls.WebNumericEditor by Infragistics.WebUI.WebDataInput.WebNumericEdit.

The default tagname if that editor is igtxt, so it will probably appear in asxp as
<igtxt:WebNumericEdit ID="WebNumericEdit1" runat="server"></igtxt:WebNumericEdit>

Note: the WebNumericEditor belongs to Infragistics.Web.UI which contains AJAX controls and located in a single dll. It can be used by WebDataGrid as editor wrapped into EditorProvider.

Hi, I am trying to implement a WebNumericEditor for an UltraWebGrid. I need to prevent users from entering characters into a numeric cell. I tried to manually validate it via javascript but it seems like Ultrawebgrid numeric columns auto-convert invalid characters to 0 so I never tell if they accidentally hit a character or meant to enter a 0 anyway.  

I'm using these versions of Infragistics

• Infragistics35.Web.v10.1, Version=10.1.20101.1011
• Infragistics35.Web.v10.1, Version=10.1.20101.1011

So far my understanding of how editors work is to drop and editor on the page like so 

<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>

<ig:WebNumericEditor ID="WebNumericEditor1" runat="server" DataMode="Decimal" MinValue="0" MaxValue="100"></ig:WebNumericEditor>

And then at the column I reference the editor right?

<igtbl:UltraGridColumn BaseColumnName="[col name]" EditorControlID="WebNumericEditor1"></igtbl:UltraGridColumn>

But I seem to get this message instead. 

System.Exception: The control ctl00$ContentPlaceHolder1$WebNumericEditor1 references a control that does not implement IProvidesEmbeddableEditor and cannot be used as the editor control for column ctl00xContentPlaceHolder1xUltraWebGrid1_c_0_32

So far I've seen other forum posts use it successfully. So what exactly am I doing wrong? 

Hi guys,

The solution propesed by Viktor Snezhko works pretty well.

You only need to add the next code in order to set/get the value in the grid control (in my case the decimals are delimited with coma that's why i use the replace).

 function AfterEnterEditModeHandler(gridName, itemName) {
     //debugger;
     // Begin custom code to support Excel like float numbers
     var oCell = igtbl_getCellById(itemName);
     var valCell = new Number(oCell.getValue());
     oCell.Band.Grid._editorCurrent.value = valCell.toString().replace(".", ",");
     // End custom code to support Excel like float numbers

   }

   function BeforeExitEditModeHandler(gridName, itemName) {
     //debugger;
     // Begin custom code to support Excel like float numbers
     var oCell = igtbl_getCellById(itemName);
     oCell.setValue(oCell.Band.Grid._editorCurrent.value, false);
     // End custom code to support Excel like float numbers
   }

Success!!

Hi,

I tried to customize format/pattern/etc of WebNumericEdit - but unsuccessfully.

I am sorry for not clear explains of the problem.

I have a page with wNumEdit1 as WebNumericEdit control.

For example, user inputs number 123.123456 into wNumEdit1 and go to next field. I need that the text in the wNumEdit1 field shown as a 123.1235 ( rounded to 4 digits ) , but value remains = 123.123456. 

If the user moves in the wNumEdit1 field that it again sees whole value 123.123456 for editing. 

That is, control should show number in two formats. In "show" mode - as formated rounded number, in "edit" mode - whole number.

 Now I try to format a wNumEdit1 control's text in onblur handler:

        
        function WebNumEdit_TextFormat(oEdit)
        {
            // onblur handler
            setTimeout("FormatNumText('"+oEdit.ID+"');", 100);
        }
        function FormatNumText(numEdID)
        {
            var numEdCtrl = igedit_getById(numEdID);
            if (numEdCtrl)
            {
                var valTxt = numEdCtrl.text;
                var dot = valTxt.indexOf('.');
                if(dot > 0 && dot + 5 < valTxt.length)
                { 
                    valTxt = numToStrFormat(numEdCtrl.value, 4);
                    numEdCtrl.text = valTxt;
                    numEdCtrl.repaint();
                }
            }
        }

I will be grateful for any ideas.

Hi,

To customize format/pattern/etc of WebNumericEdit you do not need to override anything. You can create a NumberFormatInfo object with disired properties and set it to NumberFormat property of control (similar to codes in the very first email or NetAdvantage samples related to culture formats).