Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - paramvir

Pages: 1 [2] 3 4 ... 400
Either formulas or rowTemplate option are useful to handle copy/paste and autofill cases.

Please check this example based on formulas:

summary and grand summary auto refresh when any cell or row or number of rows are updated via updateRow method.

So I guess there is something incorrect in your implementation. Please share your code how are you updating the cells / rows.

News / Upgrade to Pro Version 9.0.2
« on: September 11, 2023, 07:02:49 pm »
Dear All

We are pleased to announce the release of version v9.0.2, a bug fix update for version 9.0.0

Release notes for version 9.0.0 are here:

Some of the fixes are related to validation tooltip, copy/paste of text with line breaks, import/export to xlsx w.r.t ISO datetimes and difference of timezones, pivot grandsummary for count function, row selections.

Best Regards
The ParamQuery Team

Bug Report / Re: Inquiry about import excel date format (pqgrid 9.x)
« on: September 07, 2023, 03:47:41 pm »
Dear Kim

Its release is anticipated on Monday

If it's urgent for you, then you can download fixed version from here:


There is no dataIndx of columns in js workbook ( js equivalent of xlsx file ) so there is no automatic or direct way to map the column positions between grid and js workbook.

One way to do it is by matching the column titles in grid and js workbook provided the column titles are not changed in grid or Excel file after export.

Assign required indx to all cells in all rows in js workbook ( wb.sheets[0].rows[ i ].cells ) and then reorder all cells in all rows using sort method.

When excel file is imported in the grid, the columns in grid have the same order as in Excel file by default.

Kindly share a jsfiddle if you are facing any issues.

Dear sankyuJK

Your forum account has been upgraded to Pro Enterprise.

Hi sankyuJK

Kindly register with the same email with which you made the purchase or share your transaction details.

Bug Report / Re: Inquiry about import excel date format (pqgrid 9.x)
« on: August 30, 2023, 02:00:34 pm »
This issue has been fixed, though the corrected version is not available for download yet.

Please check the fix in this example: and let me know your findings.


Help for ParamQuery Pro / Re: Interaction with table in scaled container
« on: August 29, 2023, 09:23:12 pm »
Hi Jesper

transform creates not one isolated but many layout problems related to key navigation, column resizing, grid maximize, etc functionality due to the aforementioned reason. So it would require changes at many places in the code.

I'm relooking into it for any viable solution.


Help for ParamQuery Pro / Re: select list
« on: August 29, 2023, 07:12:22 pm »
You need to update column.render callback

Code: [Select]
render: function(ui) {
  return {   
    //text: itemlistObj[ui.cellData] //this can also be used.
    text: itemlist.find( item => item.value==ui.cellData).label

And there is no need to store id_label values in the rowData.

Do you get any error in the browser console?

Kindly share a jsfiddle for speedy resolution.

reactive option is not working with treegrid, hence it's not refreshing its UI when its state changes.

Please check this alternative way:

Code: [Select]
bthSearch_Click(event) { 

Code: [Select]
setData(data) {
    //either use this.
    /*this.grid.option('', data);


Pages: 1 [2] 3 4 ... 400