Messages

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

Help for ParamQuery Pro / Re: Remote data requests occur continuously when the number of lists is zero.

« on: January 22, 2021, 11:00:14 am »

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.

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

Help for ParamQuery Pro / Re: Add row dynamic, and how scrollbar auto scroll to bottom(the new row position)?

« on: January 21, 2021, 03:32:58 pm »

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

ParamQuery Pro Evaluation Support / Re: Add Column to Grid without having any colModel

« on: January 21, 2021, 09:48:56 am »

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

ParamQuery Pro Evaluation Support / Re: about selectionModel and SelectRow

« on: January 21, 2021, 09:46:38 am »

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

Bug Report / Re: Select editor does not update mapped field when drag or paste

« on: January 20, 2021, 09:49:16 pm »

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

Help for ParamQuery Pro / Re: How avoid scientific notation when Excel export

« on: January 20, 2021, 03:21:32 pm »

"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

Help for ParamQuery Pro / Re: How avoid scientific notation when Excel export

« on: January 19, 2021, 03:14:16 pm »

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

Help for ParamQuery Grid (free version) / Re: Update the value of parent grid rows based upon nested records

« on: January 14, 2021, 10:40:46 pm »

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 »

$("#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

Help for ParamQuery Pro / Re: Tab in last column does not go to first column of next row

« on: January 12, 2021, 03:46:56 pm »

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.