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 ... 401
1
Duplicate columns can't be used in the colModel.

Every column is supposed to have unique dataIndx.

3
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
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
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
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
formulas feature is available in free version too.

https://paramquery.com/demos/grid_formula

Pages: [1] 2 3 ... 401