Intersoft Community - WebGrid Enterprise - Space character in Text Areas and Dropdowns in Webgrid

Space character in Text Areas and Dropdowns in Webgrid

sjain — Thu, 08 Nov 2018 14:09:57 GMT

Hi,

Chrome with new version introduced a new problem.

On click on any cell, cell text ended with space which tuns into "\t" into database while save. which is causing issues. (Unable to attach pictures because of issue into editor)
NOTE: Chrome earlier version (67.0) is working fine.

I am using Webgrid product version 10.0.

Please give us a solutions.

Regards

Sachin Jain

Space character in Text Areas and Dropdowns in Webgrid

questica — Tue, 18 Mar 2014 10:02:40 GMT

Hi Yudi,

There really needs to be a better way to deal with this.

1. This affects various types of cells not just webcombos

2. I don't have a static list of columns. This needs to work for any cell in any grid

Is this something you will consider releasing a patch for?

Space character in Text Areas and Dropdowns in Webgrid

yudi — Mon, 17 Mar 2014 00:59:20 GMT

Double clicking on WebGrid’s cell will select the text inside. Unfortunately, some browsers interpret the empty cell as a cell with &nbsp character. When selected, that character will be used as default filter in WebCombo which will returns no result.

Following work around will remove the space to WebCombo’s textbox.

function WebGrid1_OnEnterEditMode(controlId, tblName, editObject)
{
    var WebGrid1 = ISGetObject(controlId);
    var cell = editObject.cellElement;
    var colName = WebGrid1.GetColumnByElement(cell).Name;
    // only applied to CategoryID column
    // which uses WebCombo as the editor type
    if (colName == "CategoryID")
    {
        if (editObject.ToCellObject().Value == "")
        {
            // removes the space, " " by
            // setting TextBox value of WebCombo to ""
            editObject.element.SetTextBoxValue("");
        }
    }
    return true;
}

Hope this helps.

Space character in Text Areas and Dropdowns in Webgrid

questica — Fri, 14 Mar 2014 16:04:30 GMT

If I have a row in a grid with a text area column or webcombo column, doubleclicking on an empty cell in a record will sometimes show a space character in the cell rather than nothing

Observations:

Recent version of Chrome show this bad behaviour. The character is an (A0) or nbsp character

Recent version of firefox show the character and it is a standard space

IE11 doesn't seem to have the problem

Can we get a resolution to this. It is very problematic because it sets a default filter on dropdowns and webcombos that returns no results.

Thanks

Marshall.