Messages

1

Help for ParamQuery Pro / Re: cellClick for nested grid.

« on: May 11, 2023, 08:17:26 pm »

Perfect, thanks.

2

Help for ParamQuery Pro / cellClick for nested grid.

« on: May 11, 2023, 05:10:28 pm »

I have created a nested grid and am attempting to add a cellClick event. I have added the code, but it only works on the main grid, not the nested.
        detailModel: {
            //cache: false,
            collapseIcon: "ui-icon-plus",
            expandIcon: "ui-icon-minus",
            init: function (ui) {
                  var rowData = ui.rowData,
                      detailobj = gridDetailModel($(this).pqGrid('instance'), rowData), //get a copy of gridDetailModel                       
                      $grid = $("<div></div>").pqGrid(detailobj); //init the detail grid.
                      $grid.on ( "cellClick", function( event, ui ) {} );
                  return $grid;               
            }
I have also attempted to add a cellClick in the gridDetailModel function, but it also only works on the main grid.

3

Help for ParamQuery Pro / Re: Error with grid Export

« on: April 05, 2023, 12:35:03 am »

That was it. I appreciate the assist. The color was assigned to link fields.

4

Help for ParamQuery Pro / Error with grid Export

« on: April 04, 2023, 08:27:45 pm »

pqgrid 8.2.1
I receive the following error when I attempt to export the grid in excel format. No issue with other formats. I have tried specifying a hex color, but the same error occurs.
pqgrid.min.js:17 Uncaught invalid color: rgb(72, 135, 199)
(anonymous) @ pqgrid.min.js:17
getStyle @ pqgrid.min.js:17
exportWb @ pqgrid.min.js:17
Export @ pqgrid.min.js:17
n.exportData @ pqgrid.min.js:17
listener @ cstar.rf.js:210
(anonymous) @ pqgrid.min.js:13
dispatch @ 3.6.0.min.js:2
v.handle @ 3.6.0.min.js:2

    if (typeof rfc.export === "boolean" && rfc.export) {
        if (!obj.toolbar) obj.toolbar = { items: [] };
        obj.toolbar.items.push({
                    type: 'select',
                    label: 'Format: ',               
                    attr: 'id="export_format"',
                    options: [{ csv: 'Csv', htm: 'Html', xlsx: 'Excel', json: 'Json'}]
                });
        obj.toolbar.items.push({
            type: 'button', label: "Export ", icon: 'ui-icon-arrowthickstop-1-s',
            listener: function () {
                    format = $("#export_format").val(),
//                    color = "#99CC99"                           
                    blob = this.exportData({ format: format, sheetName: rfc.title || rfc.list, render: true }),
                    name = (rfc.exportName ? rfc.exportName : (rfc.title || rfc.list) + "." + format);
                if (typeof blob === "string") blob = new Blob([blob]);
                saveAs(blob, name);
            }
        });
        obj.toolbar.items.push({ type: 'separator' });
    }