Recent Posts

Pages: [1] 2 3 ... 10
1
Help for ParamQuery Pro / Re: Radio Button option for the column
« Last post by paramvir on December 06, 2022, 01:47:01 pm »
Please check this example: https://paramquery.com/pro/demos/selection_radio

Kindly let me know if you need further assistance.
2
It can be used in either header or footer, not at both the places.
3
Help for ParamQuery Pro / Radio Button option for the column
« Last post by afterhours2 on December 06, 2022, 05:08:42 am »
Hello,

I am using Paramquery v8.5.0. I am working on a functionality to add radio button to each row of the table, which will enable user select only one row from the list. Data from the select row will be used for further processing.

Below is the code we are currently using for checkbox, need to update this to Radio button functionality

 obj.colModel = [
         {title: "Select", dataIndx: "flag", type: 'checkbox', maxWidth: 30, align: "center", cls:'checkboxColumn',
                resizable: true, editor: false, sortable: false ,editable:true, cb: { all: false, header: true, check: "Y", uncheck: "N" }
            },
            { title: "Employee No", dataIndx: 'empNo', minWidth: 50,maxWidth: 100, align: "center" },
            { title: "First Name", dataIndx: 'firstName' , minWidth: 100,maxWidth: 400, align: "center" }
]

Screenshot attached, need help to update the checkboxes highlighted in yellow to Radio buttons.

Any help on this would be much appreciated

4
Help for ParamQuery Pro / Re: Making only 3 cells in a spreadsheet editable
« Last post by pbassey on December 05, 2022, 06:31:01 pm »
Thanks again.  For this reading this, the row numbers in the spreadsheet are actually one minus the ones referenced in the code.  The row index is zero based.

So this code will actually make rows 14, 17 and 18 editable:

editable: function(ui){
   return (( ui.rowIndx == 13 || ui.rowIndx == 16 || ui.rowIndx == 17 ) && ui.dataIndx == 2 )
},

Thanks again for the help....
5
Hi,

i want to implement pager in both Header and Footer.

when i am trying to add it footer then header pager disappears. If i put it on header then footer pager disappears.

Please suggest, how to put it on both places.
6
Help for ParamQuery Pro / Re: Formula in writable columns
« Last post by paramvir on December 05, 2022, 03:17:48 pm »
Enter the formula =A1*0.3 in second column of 1st row and drag it down.
7
Help for ParamQuery Pro / Formula in writable columns
« Last post by satyaprakashsp on December 05, 2022, 01:12:15 pm »
Hi

I have 2 columns in my grid, in which 1st column is a read-only numeric column, while the 2nd column is an input column where the user has to provide their input based upon the 1st column data within the same row.

My question is, is there any way to enter the cell value with a simple formula like (the previous cell value * 0.3) and then drag the cell to the below cells to copy the same calculations in the below cells.

I am using ParamQuery Pro v8.6.0

Thanks in advance for your quick response.

Best regards
Satya
8
Help for ParamQuery Pro / Re: Making only 3 cells in a spreadsheet editable
« Last post by pbassey on December 03, 2022, 06:18:57 am »
Thank you for the reply.  I just made the change you suggested above, but now, all the cells are protected.  Is there anything else I am missing??
Below is my code. 

var grid2 = pq.grid("#KPMGData", {       
   height: 500,
   width: '100%',
   sortableType: false,
   showTitle: false,
   header: false,         
   autoRow: true,   
   editor: { select: true, type: 'textbox' },
   selectionModel: {column: true},
   animModel:{on: true},
   colModel: [               
      {dataIndx: 0, title: "A", align: "left", width: 300},
      {dataIndx: 1, title: "B", align: "right", width: 100},
      {dataIndx: 2, title: "C", align: "right", width: 100, dataType: "float", format: '###,###.00'},
      {dataIndx: 3, title: "D", align: "right", width: 100},
      {dataIndx: 4, title: "E", align: "right", width: 100},
      {dataIndx: 5, title: "F", align: "right", width: 100},
      {dataIndx: 6, title: "G", align: "right", width: 100},
      {dataIndx: 7, title: "H", align: "right", width: 100},
      {dataIndx: 8, title: "I", align: "right", width: 100},
      {dataIndx: 9, title: "J", align: "right", width: 300,
      {dataIndx: 10, title: "K", align: "right", width: 300}
   ],
   editable: function(ui){
      return (( ui.rowIndx == 15 || ui.rowIndx == 18 || ui.rowIndx == 19 ) && ui.dataIndx == 2 )
   },

                       
   editor:{type:'textarea'},
   editModel: {
   onSave:'downFocus'             
   }
});
grid2.showLoading();
pq.excel.importXl( {url: '/sts/content/files/data/KPMG.xlsx'}, function( wb ){
   grid2.importWb({ workbook: wb, extraRows: 0, extraCols: 20, keepCM: true });     
})     

grid2.hideLoading();   
9
Help for ParamQuery Pro / Re: Making only 3 cells in a spreadsheet editable
« Last post by paramvir on December 03, 2022, 05:44:57 am »
Sorry about that, it's ui.dataIndx instead of plain dataIndx, corrected my previous post.

and remove editable: false from all the columns.

10
Help for ParamQuery Pro / Re: Making only 3 cells in a spreadsheet editable
« Last post by pbassey on December 02, 2022, 11:18:33 pm »
I added your new code snippet to my code below and I get the Javascript error when I click on row 18, dataIndx 2:

"ReferenceError: Can't find variable: dataIndx"

Below is the code I am using:

var grid2 = pq.grid("#KPMGData", {       
   height: 500,
   width: '100%',
   sortableType: false,
   showTitle: false,
   header: false,         
   autoRow: true,   
   editor: { select: true, type: 'textbox' },
   selectionModel: {column: true},
   animModel:{on: true},
   colModel: [               
      {dataIndx: 0, title: "A", align: "left", width: 300, editable: false},
      {dataIndx: 1, title: "B", align: "right", width: 100, editable: false},
      {dataIndx: 2, title: "C", align: "right", width: 100,  dataType: "float", format: '###,###.00'},
      {dataIndx: 3, title: "D", align: "right", width: 100, editable: false},
      {dataIndx: 4, title: "E", align: "right", width: 100, editable: false},
      {dataIndx: 5, title: "F", align: "right", width: 100, editable: false},
      {dataIndx: 6, title: "G", align: "right", width: 100, editable: false},
      {dataIndx: 7, title: "H", align: "right", width: 100, editable: false},
      {dataIndx: 8, title: "I", align: "right", width: 100, editable: false},
      {dataIndx: 9, title: "J", align: "right", width: 300, editable: false},
      {dataIndx: 10, title: "K", align: "right", width: 300, editable: false}
   ],     
   editable: function(ui){
      return (( ui.rowIndx == 14 || ui.rowIndx == 17 || ui.rowIndx == 18 ) && dataIndx == 2 )
   },

   editor:{type:'textarea'},
   editModel: {
   onSave:'downFocus'             
   }
});
grid2.showLoading();
pq.excel.importXl( {url: '/sts/content/files/data/KPMG.xlsx'}, function( wb ){
   grid2.importWb({ workbook: wb, extraRows: 0, extraCols: 20, keepCM: true });     
})     
grid2.isEditableCell( { rowIndx: 14, dataIndx: 3 } );
grid2.isEditableCell( { rowIndx: 17, dataIndx: 3 } );
grid2.isEditableCell( { rowIndx: 18, dataIndx: 3 } );

grid2.hideLoading();   
Pages: [1] 2 3 ... 10