Recent Posts

61

Help for ParamQuery Pro / Re: exportRender not working

« Last post by jplevene on March 25, 2026, 11:15:20 pm »

Even setting it to "false" didn't work.

It's not a problem for me as I just used "skipExport" and in "render" I do a different export for export.

Looking at it again, the API guide isn't clear as it says:

column.exportRenderType: Boolean
Rendered cell values ( otherwise raw cell data ) in this column are included in the exported data when this option is true.
This option overrides render parameter of exportData() method for the current column.

Maybe  the second line above should be:
When this option is true (default), the rendered cell (if render is used) is exported, otherwise the raw cell data value is exported.

62

Bug Report / Re: Filter input, drop down arrow has no padding to protect it

« Last post by jplevene on March 25, 2026, 10:59:22 pm »

Looked into this further, by me setting the style option, it completely removed the padding from the input instead of adding a style to it.  Had the padding been due to a CSS class, then this wouldn't have happened.  I think it should be a CSS class, which also means that if I want to change the style in the style option, it will do so.

So for instance if I do "color:red" in the style option, the padding will disappear.

This is why I this is a bug and not a help request.

63

Help for ParamQuery Pro / Re: Invalid Data Display (#VALUE!) on Excel Paste In React

« Last post by paramvir on March 25, 2026, 10:33:35 pm »

copy paste from Excel to pqgrid works fine in general, can you please share example spreadsheet and specific cells which cause this issue.

64

Help for ParamQuery Pro / Re: exportRender not working

« Last post by paramvir on March 25, 2026, 10:26:30 pm »

exportRender is not a callback, can you please explain your objective?

65

Help for ParamQuery Pro / Re: Calculation Refresh Issue on Scroll In React

« Last post by paramvir on March 25, 2026, 07:55:17 pm »

Please use the option refreshCompareBy: 'render' or refreshCompareBy: ''

https://paramquery.com/pro/api#option-refreshCompareBy

and let me know the results.

66

Help for ParamQuery Pro / Invalid Data Display (#VALUE!) on Excel Paste In React

« Last post by Punit on March 25, 2026, 07:00:42 pm »

When data is copied from Excel and pasted into pqGrid, it is displayed as ‘#VALUE!

beforeValidate: function (evt, ui) {
  if (ui.source === "paste") {
    const grid = this;

    // Block all new row additions on paste
    ui.addList.length = 0;

    // Loop through updated rows
    ui.updateList.forEach(({ newRow, rowData }) => {
      for (const dataIndx in newRow) {
        if (!newRow.hasOwnProperty(dataIndx)) continue;

        const col = grid.getColumn({ dataIndx });
        console.log(col, "=rowData-paste");

        const elementType = rowData?.ElementType;
        let val = newRow[dataIndx];

        console.log(val, "=paste-value");
        // output #VALUE!
      }
    });
  }
}

67

Help for ParamQuery Pro / Re: exportRender not working

« Last post by jplevene on March 25, 2026, 06:39:43 pm »

Was about to update my above comment, exportRender:false also doesn't work.  I am applying this to a detail grid on the icon type:"deatil" column

Even exportRender:function(ui){return false;} does not work

I tried skipExport:true which works obviously, however this column is the first column and is frozen which causes the next column to be frozen, or in the case of my grid the 3rd column as the first two are frozen

68

Help for ParamQuery Pro / Calculation Refresh Issue on Scroll In React

« Last post by Punit on March 25, 2026, 06:28:11 pm »

When we have large data, the calculation doesn’t update properly after changing a value. It only updates after scrolling up and then back down

I added a value, and it is shown in screenshot_5. The calculated data is displayed in screenshot_6. After deleting the value, it is shown in screenshot_8, but the calculation is not update and is still displayed in screenshot_7

69

Help for ParamQuery Pro / exportRender not working

« Last post by jplevene on March 25, 2026, 05:46:04 pm »

It doesn't seem to be calling the function:

exportRender:function(ui){ return { text:ui.rowData["noChild"]?"":"+" }; }

70

Help for ParamQuery Pro / Re: Expanding detail row

« Last post by jplevene on March 22, 2026, 02:19:36 am »

Thanks, really helped and far better than my idea.

Would be really nice as a feature. 

For others, I did it programatically so that it only affected one grid with an id of "my_grid" and not all of them:

Code: [Select]

// Override the prototype using a standard function but only for the availability grid
const pq_grid_defaultGetPadding = $.paramquery.cHierarchy.prototype.getPadding;
$.paramquery.cHierarchy.prototype.getPadding = function() {
// In pqGrid modules, 'this.that.element' holds the jQuery object of the grid
const gridId = this.that && this.that.element ? this.that.element.attr('id') : null;
if(gridId === 'my_grid')
return { paddingLeft: 25 };
else
return pq_grid_defaultGetPadding ? pq_grid_defaultGetPadding.apply(this, arguments) : { paddingLeft: 0 };
};
const styleTag = document.createElement('style');
styleTag.textContent = `
#hh_availability_grid .pq-detail {
z-index: 90 !important; /* Optional: add !important if another stylesheet is overriding it */
background: #fff;
}
#hh_availability_grid .pq-cont-right {
z-index: unset;
}
`;
document.head.appendChild(styleTag);