Recent Posts

21

Help for ParamQuery Pro / Re: Exported Excel Issues with Merged Cells and SUM in WPS/MS Office

« Last post by paramvir on June 19, 2025, 04:37:36 pm »

1st issue:

ParamQuery Pro supports xlsx format only, so please ensure to name the file with xlsx extension while downloading the file.


2nd issue:

Please add this refresh event in the grid initialization object. It would ensure to clear all the merged cells except the 1st cell in merged cell range, whenever any range of cells is merged in ParamQuery grid.

Code: [Select]

                refresh(){                   
                    var mc = this.options.mergeCells,
                        mcLast = mc.at(-1);
                    if( mcLast ){
                        //debugger;
                        let {r1, c1, r2, c2, rc, cc, cleared} = mcLast,
                            count = rc * cc;
                        if(count > 1 && !cleared){
                            let val = this.Range({r1, c1}).value()[0],
                                r = this.Range({r1, c1: c1, r2, c2});

                            mcLast.cleared = true;
                            this.one('beforeValidate', (evt, ui) => {ui.history = false});
                            r.value([val]);                           
                        }
                    }
                },


22

ParamQuery Pro Evaluation Support / MOVED: Exported Excel Issues with Merged Cells and SUM in WPS/MS Office

« Last post by paramvir on June 19, 2025, 01:51:56 pm »

This topic has been moved to Help for ParamQuery Pro.

https://paramquery.com/forum/index.php?topic=5019.0

23

Help for ParamQuery Pro / Exported Excel Issues with Merged Cells and SUM in WPS/MS Office

« Last post by saritha_sdwot on June 19, 2025, 12:36:42 pm »

Hi,

I'm facing a couple of issues with Excel files exported from ParamQuery Grid:

The exported Excel file is downloaded with a .xls extension, which doesn't open properly in Microsoft Office. To work around this, I renamed it to .xlsx, and it opens fine.

However, I'm encountering a problem with merged cells in the exported file. When using the SUM() function on merged cells:

In WPS Office and Microsoft Excel, the sum includes duplicate values from the merged regions (i.e., it adds hidden values under the merged cells).

In LibreOffice, it works correctly and only includes the value from the visible (top-left) cell in the merged range.

This issue appears only in Excel files exported from ParamQuery Grid. If I manually unmerge and remerge the cells in Excel, the problem is resolved — which suggests the initial export includes hidden values in all cells of the merged range.

Is there a way to modify the export logic in ParamQuery so that:

Only the top-left cell of a merged range contains a value,

The other cells in the merged range are left blank (like LibreOffice expects)?

Thanks!

24

Help for ParamQuery Pro / Re: Icon in column header

« Last post by paramvir on June 18, 2025, 06:40:35 pm »

If you don't want it to be part of title API, then

In refreshHeader event, get a reference to header cell with getCellHeader method

https://paramquery.com/pro/api#method-getCellHeader

and add icon by DOM manipulation.

25

Help for ParamQuery Pro / Icon in column header

« Last post by queensgambit9 on June 18, 2025, 04:52:42 pm »

Hi

I would like add a icon to column header for a specific column after the title. But not being a part of the title.
What would be the best approach for this?

26

Help for ParamQuery Pro / Re: BootStrap Dropdown not working

« Last post by pbassey on May 29, 2025, 07:55:12 pm »

Perfect!  Thank you...

27

Help for ParamQuery Pro / Re: BootStrap Dropdown not working

« Last post by paramvir on May 29, 2025, 06:50:13 pm »

grid cells have overflow: hidden; that's why the dropdown gets clipped.

It can be resolved by:

a) Either add style overflow: visible to the cells containing bootstrap dropdowns.

b) or add data-bs-popper-config='{"strategy":"fixed"}' to data-bs-toggle='dropdown' elements:

jsfiddle with 2nd solution:

https://jsfiddle.net/zyhcok5p/

More discussion about this issue:

https://stackoverflow.com/questions/31829312/bootstrap-dropdown-clipped-by-overflowhidden-container-how-to-change-the-conta

28

Help for ParamQuery Pro / BootStrap Dropdown not working

« Last post by pbassey on May 29, 2025, 01:18:42 am »

I am using a PG Grid that has an "Actions" column that has 3 buttons inside. The 3rd button is named "More" and is supposed to popup a bootstrap menu of 2 items (Export and Delete options), but is not working

Below is a link to jsfiddler that has the code I am using:
https://jsfiddle.net/7swe1L5d/

Notice that when you click on the "more" button inside the grid, nothing happens.  However, when you click on the "more" button above/outside of the grid, it works fine.  Because the menu works outside the grid, there must be an issue with the QueryParam options I am using.

Can you please tell me what I need to do to get this bootstrap popup working inside QueryParam?

29

Bug Report / Re: Safari 16 and below bug with suggested fix

« Last post by paramvir on May 28, 2025, 08:44:13 am »

The original code uses a negative lookbehind

Code: [Select]

fmtPart = fmtPart.replace(/(?<![ap])m{1,5}/gi, replacer("M"));.

The following snippet can be used instead, as it avoids lookbehind by capturing the preceding character:

Code: [Select]

fmtPart = fmtPart.replace(/(^|[^ap])(m{1,5})/gi, (match, prefix, mSequence, offset) => {
     return prefix + replacer('M')(mSequence, offset + prefix.length );
});


30

Help for ParamQuery Pro / Re: Why are cells marked as dirty with updateRow track: false?

« Last post by paramvir on May 25, 2025, 12:31:40 pm »

Please pass the params correctly

Code: [Select]

        grid.updateRow({
            track: false,
            history: false,
            checkEditable: false,
            refresh: true,
            rowList: [{
              rowIndx: ri,
              newRow: res.data
            }]
        });