1
Help for ParamQuery Pro / Re: How can I access the dom object for the grid-overay of the selectionModel?
« Last post by tbum on July 01, 2022, 01:49:35 pm »Thank you
ParamQuery Grid
Recent Posts
2
Help for ParamQuery Pro / Re: How can I access the dom object for the grid-overay of the selectionModel?
« Last post by paramvir on July 01, 2022, 12:10:07 pm »class of the selection overlay is "pq-grid-overlay r11c12r21c23" so you can add the style according to the selected area.
class r11c12r21c23 implies r1: 1, c1: 2, r2: 1, c2: 3
class r11c12r21c23 implies r1: 1, c1: 2, r2: 1, c2: 3
3
Help for ParamQuery Pro / Re: about selectionModel's block
« Last post by paramvir on July 01, 2022, 12:07:14 pm »There is no beforeSelectChange event but the selection can be adjusted in selectEnd event as per your requirement.
Code: [Select]
selectEnd: function(evt, ui){
debugger;
var address = ui.selection.address()[0];
this.Range({r1: address.r1, c1: address.c1, rc:1, cc: address.cc}).select();
}
4
Help for ParamQuery Pro / Re: Change ExcelSheet Cell Color
« Last post by paramvir on June 30, 2022, 04:49:29 pm »The code runs in browser and it has nothing to do with local or production environment.
BTW this example https://paramquery.com/pro/demos/import-xlsx is also running in production environment.
BTW this example https://paramquery.com/pro/demos/import-xlsx is also running in production environment.
5
Help for ParamQuery Pro / How can I access the dom object for the grid-overay of the selectionModel?
« Last post by tbum on June 30, 2022, 02:18:07 pm »How can I access the dom object for the grid-overay of the selectionModel?
I want to set different colors depending on the selected area position.
I want to set different colors depending on the selected area position.
6
Help for ParamQuery Pro / Re: Change ExcelSheet Cell Color
« Last post by Punit on June 30, 2022, 02:17:17 pm »Dear sir,
We use the same code as you give the example URL. this is working fine in local but it takes too time when we publish this code in the production environment.
We use the same code as you give the example URL. this is working fine in local but it takes too time when we publish this code in the production environment.
7
Help for ParamQuery Pro / about selectionModel's block
« Last post by tbum on June 30, 2022, 02:12:46 pm »Code: [Select]
selectionModel: {type: 'cell', mode: 'block', row: true, toggle: true,},
I have specified selectionModel as above.
What I want to do is make a block so that only cells in the same row as the cell that started the first selection are selected.
What can I do?
And no event handlers like beforeSelectChange ? This is to be able to invalidate when an unwanted area is selected.
The exact function I want to make is that I want the selectModel to work only for a specific area. Do you offer such a feature as an option?
Otherwise, I tried to develop it using an event handler.
8
Help for ParamQuery Pro / Re: How to deal with nested json data in bulk edit?
« Last post by paramvir on June 30, 2022, 12:42:09 pm »1. issue is not clear.
2. Make changes in rowTemplate getter and setter according to the structure of data.
Ensure to turn on tracking and add primary key i.e., dataModel.recIndx similar to this example:
https://paramquery.com/pro/demos/editing_batch
2. Make changes in rowTemplate getter and setter according to the structure of data.
Code: [Select]
get() {
....
return this.custom_fields[_indx].userData[0];
},
set(val) {
this.custom_fields[_indx].userData = [val];
}
Ensure to turn on tracking and add primary key i.e., dataModel.recIndx similar to this example:
https://paramquery.com/pro/demos/editing_batch
9
Help for ParamQuery Pro / Re: Remove + Tab button In Excel Sheet
« Last post by paramvir on June 30, 2022, 11:27:46 am »Add noAdd: true to tabModel.
https://paramquery.com/pro/api#option-tabModel
https://paramquery.com/pro/api#option-tabModel
Code: [Select]
tabModel: {
noAdd: true,
tabs: []
},
10
Help for ParamQuery Pro / Remove + Tab button In Excel Sheet
« Last post by Punit on June 30, 2022, 11:08:03 am »Dear sir,
We want to display excel sheet tabs but we want to hide + excel sheet tab button.
We want to display excel sheet tabs but we want to hide + excel sheet tab button.