Messages

1

Help for ParamQuery Pro / Re: Columns overlaps in case of the Animation mode is on

« on: September 29, 2023, 07:55:56 pm »

Duplicate columns can't be used in the colModel.

Every column is supposed to have unique dataIndx.

2

ParamQuery Pro Evaluation Support / MOVED: When rowSpanHead mode is set to true, sorting functionality is not working

« on: September 26, 2023, 07:50:09 am »

This topic has been moved to Help for ParamQuery Pro.

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

3

Help for ParamQuery Pro / Re: When rowSpanHead mode is set to true, sorting functionality is not working

« on: September 26, 2023, 07:49:50 am »

It would be fixed in upcoming version.

This patch can be used for now to fix it

Code: [Select]

pq.cRenderHead.prototype.onHeaderCellClick=function(e,t,s){e=e||{};var l=this.that,i=l.options,r=i.sortModel,a=i.selectionModel,o=$(s.target),d=e.dataIndx;if(!1!==l._trigger("headerCellClick",s,{column:e,colIndx:t,dataIndx:d})&&-1!=t&&!o.closest(".pq-grid-header-search-row")[0]){if(a.column&&a.type&&!o.hasClass("pq-title-span")&&!o.hasClass("ui-icon")){var n=l.getFirstVisibleRIP(),c={c1:t,firstC:t,firstR:n},p=l.iSelection,u=p.address(),C=u.length;if(pq.isCtrl(s))p.add(c);else{if(s.shiftKey){if(C&&"column"==u[C-1].type){var f=u[C-1];f.c1=f.firstC,f.c2=t,f.r1=f.r2=f.type=f.cc=void 0}c=u}l.Range(c,!1).select()}null!=(n=l.getFirstVisibleRIP(!0))&&(l.focus({rowIndxPage:n,colIndx:t}),l._trigger("mousePQUp"))}else(r.wholeCell||o.hasClass("pq-title-span"))&&l.isSortable(e)&&l.sort({sorter:[{dataIndx:d,sortIndx:e.sortIndx}],addon:!0,skipCustomSort:pq.isCtrl(s),tempMultiple:r.multiKey&&s[r.multiKey],evt:s})}};


4

Help for ParamQuery Pro / Re: tree grid and dragg and drop

« on: September 25, 2023, 10:06:58 pm »

There is no option to make the whole region in row draggable with mouse.

Rows can be dragged only via an icon displayed in number cell or any cell with help of dragModel.diDrag option

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

5

Help for ParamQuery Grid (free version) / Re: Refresh row in nested grid

« on: September 20, 2023, 10:02:04 pm »

Reference to detail grid can be obtained from corresponding rowData as

Code: [Select]

var detail_grid = $(rowData.pq_detail.child).pqGrid( 'instance' );

//now call any method on detail grid,

detail_grid.refreshRow()

or

detail_grid.updateRow()


6

Help for ParamQuery Pro / Re: Is this possible to export grid in PDF if grid have more than 1 tab

« on: September 20, 2023, 09:36:41 pm »

This example demonstrates export of multiple tabs to pdf or any other format.

https://paramquery.com/pro/demos/import_xlsx_tabs

7

Help for ParamQuery Pro / Re: tree grid and dragg and drop

« on: September 20, 2023, 04:24:24 pm »

This example has every feature for your requirement. https://paramquery.com/pro/demos/dnd_tree

To use row selection instead of checkbox selection,

use

Code: [Select]

selectionModel:{type: 'row'},

and change dragModel.dragNodes callback as below:

Code: [Select]

dragNodes: function(rd, evt){             
    var checkNodes = this.SelectRow().getSelection().map(function(obj){
return obj.rowData;
});
    return (checkNodes.length && checkNodes.indexOf(rd)>-1 )? checkNodes: [ rd ];
},


8

Help for ParamQuery Grid (free version) / Re: How to implement a "details" row in a treeview?

« on: September 18, 2023, 06:15:08 pm »

Yes it can be done by adding

Code: [Select]

pq_detail: {show: true},

to the nodes which are required to be open by default.

9

Help for ParamQuery Grid (free version) / Re: [QA] TreeGrid - Drag & Drop

« on: September 15, 2023, 06:05:15 pm »

It's due to editable: false in lGridOption

It works fine after removing editable: false

https://stackblitz.com/edit/stackblitz-starters-1nptcz?file=src%2FApp.js

Please let me know if you have any other question related to it.

10

Help for ParamQuery Pro / Re: importWb return error

« on: September 15, 2023, 03:28:16 pm »

It won't work with Enterprise SDK.

Please try it with Ultimate SDK and kindly ensure to hard refresh your browser cache.

11

Help for ParamQuery Pro / Re: importWb return error

« on: September 15, 2023, 01:27:25 pm »

Please add following to grid initalization options.

Code: [Select]

tabModel: {tabs: []},


12

News / Re: Upgrade to Pro Version 9.0.2

« on: September 15, 2023, 06:40:51 am »

Yes of course the fix would be included in the source code of next version and this patch won't be required

13

Help for ParamQuery Pro / Re: importWb return error

« on: September 15, 2023, 06:37:59 am »

Please follow this live example:

https://paramquery.com/pro/demos/js-workbook

14

Help for ParamQuery Grid (free version) / Re: How to implement a "details" row in a treeview?

« on: September 13, 2023, 01:30:18 pm »

Sorry for late reply.

Yes, they can be used together and it's quite straightforward.

Add a column to open / close the row details in treegrid colModel.

Code: [Select]

{ title: " ", minWidth: 25, maxWidth: 35, type: "detail" },

add detailModel in treegrid options.

You can load the detailModel data locally or remotely.

15

Help for ParamQuery Grid (free version) / Re: Problem on copy/paste and autofill for select elements

« on: September 13, 2023, 08:33:13 am »

formulas feature is available in free version too.

https://paramquery.com/demos/grid_formula