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 ... 331
1
Help for ParamQuery Pro / Re: How do I add a class to a column?
« on: January 22, 2021, 04:49:36 pm »
First find the column from dataIndx

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

then add cls property to the column.

https://paramquery.com/pro/api#option-column-cls

2
Quote
Remote data requests occur continuously when the number of lists(result from remote data) is zero. I don't know why remote data requests keep happening.

Please share a jsfiddle so that I can check your code.

Quote
And if the number of remote data is zero, I want to show that 'there is no data' on the grid.

Please include the localization file and this is controlled by the localization string: strNoRows.

It can also be added as a normal option i.e., strNoRows: 'there is no data'

3
Bug Report / Re: Paramquery breaks JQueryUI Dialog functionality
« on: January 21, 2021, 06:09:17 pm »
Thanks for sharing the issue.

Current workaround for this issue is to use array format for buttons option.

Code: [Select]
        buttons: [{
            text: "Apply",
            click: function() {
              saveInterfaceSettings();
            }
          },
          {
            text: 'Cancel',
            click: function() {
                $( this ).dialog( "close" );
            }
          }
        ]

https://jsfiddle.net/y0pvenb4/

4
Get rowIndx of the newly added row ( return value of addRow method ) and pass it to scrollRow method

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

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

5
It's the same method to add new columns.

grid.Columns().add()

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

Example: https://paramquery.com/pro/demos/context_menu

6
When selectionModel.type = 'cell' it turns on Range selections which work similar to a spreadsheet.

And for that there is different API.

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

7
This is not a bug. mapIndices is a property of editor and hence work only with inline editing.

formulas can be used instead of mapIndices to map the key value pairs always.

Example: https://paramquery.com/pro/demos/datamap

8
"34300E7" is exported as "34300E7" by grid but the problem lies in how Excel interprets such strings.

and I don't see any way in Excel to interpret 34300E7 or any strings composed of numbers with letter "E" in them as string.

9
you can try adding format: "0" to such cells in the js workbook.

1) Export the grid to intermediate js workbook

2) Add format: "0" to such cells with large values.

3) Export js workbook to Excel.

10
Help for ParamQuery Pro / Re: Unable to build in vue
« on: January 18, 2021, 11:02:10 am »
Please use this command on terminal to increase the memory for current terminal session

Code: [Select]
set NODE_OPTIONS=--max_old_space_size=4096

or this to save it permanently.

Code: [Select]
setx NODE_OPTIONS --max_old_space_size=4096

11
Help for ParamQuery Pro / Re: Unable to build problems in Vue environment
« on: January 18, 2021, 11:01:05 am »
Please use this command on terminal to increase the memory for current terminal session

Code: [Select]
set NODE_OPTIONS=--max_old_space_size=4096

or this to save it permanently.

Code: [Select]
setx NODE_OPTIONS --max_old_space_size=4096

12
Excel formulas can be used in grand summary row which auto updates itself.

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

13
Help for ParamQuery Pro / Re: Double click event issue
« on: January 13, 2021, 08:42:55 pm »
I'm afraid there is no fix available for double click issue currently.

14
Help for ParamQuery Pro / Re: paramquery memory release or destroy
« on: January 12, 2021, 05:28:59 pm »
Quote
$("#myGrid").PqGrid (obj) before calling $("#myGrid").PqGrid ('destroy'), IE will report false: Error: cannot call methods on pqGrid prior to initialization; attempted to call method 'destroy'.

You could create the grid when popup is opened and destroy it when popup is closed.

Code: [Select]
open: function (evt, ui) {   
    $("#myGrid").pqGrid(obj);
},
close: function () {
    $("#myGrid").pqGrid('destroy');
},

Example: https://stackblitz.com/edit/paramquery-demo-popup?file=index.html

15
This feature is no longer available since v5

However you can customize it to make it work the way you want.

e.g this code would shift the focus and selection to next row when tab is pressed in last column.

Code: [Select]
cellKeyDown: function( event, ui ) {

var ri = ui.rowIndx, grid = this,
ci = ui.colIndx,
totalRows = grid.pageData().length,
totalcolumns = grid.getColModel().length;
if (event.keyCode == $.ui.keyCode.TAB && ci == totalcolumns - 1 && ri < totalRows - 1) {
//debugger;
setTimeout(function(){
grid.Range({r1:ri+1, c1: 0}).select();
grid.focus({rowIndxPage: ri+1, colIndx: 0});
})
}
}

Please note that the above logic is based on the assumption that there are no hidden columns in the beginning and end and no hidden rows at the bottom. Please feel free to customize the code as per your requirements.

Pages: [1] 2 3 ... 331