Hi All,

If you have any further questions or concerns with this, please feel free to let us know.

I dont know if this helps but I had the same type of issue. I just used underscores instead of a space and used CSS on that cell with font-size: 0px !important; for a visuals

Hi Martin,

Thanks for your reply.

I got this error in all grid features, mainly the one appears first in list. If I comment that out then it shows on next one. Can you please create an sample at your side to see an error, using datasource from my previous post and below is my java script file. Error appears on row expanding.

function getMaterialPricesList() {
    try{
    $.ig.loader(function () {
       
        $("#GridTable").igHierarchicalGrid({
            columns: [
                    { headerText: "Price List Ref", key: "R", width: "200px", dataType: "string" },
                    { headerText: "Price List Name", key: "N", width: "600px", dataType: "string" },
                    { headerText: "Hide Quote Pricing", key: "H", width: "100px", dataType: "bool", format: "checkbox" },
                    { headerText: "Inactive", key: "Inactive", width: "50px", dataType: "bool", format: "checkbox" }
            ],
            width: "1100px",
            initialDataBindDepth: 1,
            dataSource: URL,
            responseDataKey: "Records",
            responseDataType: "json",
            responseTotalRecCountKey: "servertotalcount",
            renderCheckboxes: true,
            autoGenerateColumns: false,
            autoGenerateLayouts: false,
            defaultChildrenDataProperty: "Items",
            primaryKey: "R",
            //rowsRendered: rowsRenderedHierarchical,
            //rowExpanding: rowsRenderedHierarchicalChild,
            columnLayouts: [
                     {
                        key: "Items",
                        name: "Items",
                        responseDataKey: "",
                        childrenDataProperty: "Items",
                        autoGenerateColumns: false,
                        renderCheckboxes: true,
                        primaryKey: "I",
                        foreignKey: "R",
                        features: [
                            {
                                name: "Filtering",
                                allowFiltering: true,
                                caseSensitive: false,
                                mode: "advanced"
                            },
                            {
                                name: 'Sorting',
                                firstSortDirection: 'descending'
                            },
                            {
                                name: 'Paging',
                                type: "local",
                                pageSize: 10,
                            },
                            {
                                name: "Updating",
                                startEditTriggers: "dblclick",
                                editMode: editmode,
                                enableAddRow: createAccess,
                                enableDeleteRow: false,
                                enableDataDirtyException: false,
                               // editCellStarting: editCellStartingMaterialPrice,
                               // editCellStarted: editCellStartedMaterialPrice,
                               // editRowEnding: editRowEndingMaterialPrice,
                               // rowDeleting: deletingRowMaterialPrice,
                                columnSettings: [
                                        {
                                            columnKey: "E",
                                            editorType: "datepicker",
                                            editorOptions:
                                            {
                                                required: false,
                                                validatorOptions:
                                                {
                                                    required: false
                                                }
                                            }
                                        },
                                        {
                                            columnKey: "M",
                                            editorType: "combo",
                                            editorOptions:
                                            {
                                                mode: "dropdown",
                                                dropDownWidth: "300px",
                                                dataSource: MaterialRefJSON,
                                                dataSourceType: "json",
                                                textKey: "Name",
                                                valueKey: "Value",
                                                readOnly: true,
                                                required: true,
                                               // selectionChanged: selectionChangedMaterialRef,
                                                validatorOptions:
                                                {
                                                    required: true
                                                }
                                            }
                                        },
                                        {
                                            columnKey: "C",
                                            editorType: 'numeric',
                                            validation: true,
                                            editorOptions: { required: true, maxLength: 5, decimalSeparator: "." }
                                        },
                                        {
                                            columnKey: "F",
                                            editorType: 'numeric',
                                            validation: true,
                                            editorOptions: { required: true, maxLength: 5, decimalSeparator: "." }
                                        }
                                        ]
                            }],
                       
                        columns: [
                                  { key: "I", headerText: "ID", dataType: "number", width: "25px", hidden: true },
                                  { key: "R", headerText: "Price List Ref", dataType: "string", width: "95px" },
                                  { key: "M", headerText: "Material Ref", dataType: "string", width: "100px" },
                                  { key: "D", headerText: "Description", dataType: "string", width: "150px" },
                                  { key: "T", headerText: "Material Type", dataType: "string", width: "70px" },
                                  { key: "C", headerText: "Current Price", dataType: "numeric", width: "50px" },
                                  { key: "F", headerText: "Future Price", dataType: "numeric", width: "50px" },
                                  { key: "E", headerText: "Effective Date", dataType: "date", format: "dd/MM/yy", width: "100px"},
                                  { key: "Inactive", headerText: "Inactive", width: "50px", dataType: "bool", format: "checkbox" }
                                ]
                    }],
            features: [
                {
                    name: 'Selection',
                    //rowSelectionChanged: rowSelectionChanged_handler
                },
                {
                    name: 'Paging',
                    type: 'remote',
                    pageSize: 5,
                    recordCountKey: "servertotalcount",
                    pageSizeUrlKey: "pageSize",
                    pageIndexUrlKey: "page",
                    pageSizeChanging: function(evt, ui) {
                                            page = 0;
                                            filterExpr = "";
                                            groupExpr = "";
                                            sortColumn = "";
                                            }
                },
                {
                    name: 'Sorting',
                    type: 'remote',
                    firstSortDirection: 'descending',
                    columnSorting: columnSorting_handler
                },
                {
                    name: "Filtering",
                    allowFiltering: true,
                    caseSensitive: false,
                    type: "remote",
                    mode: "advanced",
                    dataFiltering: dataFiltering_handler,
                    columnSettings: [
                                    { columnKey: "Inactive", allowFiltering: false },
                                    { columnKey: "H", allowFiltering: false }
                    ]
                },
                //{
                //    name: "GroupBy",
                //    type: "remote",
                //    emptyGroupByAreaContent: "Drag a column here to group by",
                //    modalDialogHeight: 100,
                //    groupedColumnsChanging: groupedColumnsChanging_handler,
                //    columnSettings: [
                //                    { columnKey: "R", allowGrouping: true },
                //                    { columnKey: "H", allowGrouping: true },
                //                    { columnKey: "Inactive", allowGrouping: true, condition: false }
                //                    ]
                //},
                {
                    name: "Updating",
                    startEditTriggers: "dblclick",
                    enableAddRow: createAccess,
                    editCellStarted: function(evt, ui) {
                                    switch (ui.columnKey) {
                                    case 'R':
                                    if (ui.rowAdding)
                                        ui.editor.igEditor('option', 'readOnly', false);
                                    else
                                        ui.editor.igEditor('option', 'readOnly', true);
                                    break;
                                    default:
                                    }
                        },
                        enableDeleteRow: false,
                        enableDataDirtyException: false,
                       // editRowEnding: editRowEndingMaterialPriceList,
                       // rowDeleting: deletingRowMaterialPriceList,
                        columnSettings: [
                            {
                                columnKey: "R",
                                editorType: "text",
                                editorOptions:
                                {
                                    required: true,
                                    validatorOptions:
                                    {
                                        required: true
                                    }
                                }
                            },
                        ]
                }]
        });
    });

    $("#GridTable").data("igGrid").dataSource.settings.urlParamsEncoded = function(owner, params) {
            Page = 0;
            params.filteringParams.Filter = filterExpr;
            params.filteringParams.Group = groupExpr;
            params.filteringParams.Sort = sortColumn;
    };
  }
  catch (e) {
        alert('getMaterialPricesList() - An error has occurred: ' + e.message)
    }
}