Topics

1

Help for ParamQuery Pro / scrolling with mouse wheel freezes

« on: June 20, 2022, 11:53:06 pm »

Hello,

I have a grid with 200 rows, when I scroll with scrollbar it is perfectly smooth. But when scrolling with mouse wheel, it scroll a bunch of rows, then freezes for a while, then when I keep scrolling the wheel it moves afterwards a next portion. No obvious reason, no other async calls, etc. VirtualX, virtualY enabled.
Do you have an idea what could be cause?

PQ8, bootstrap4

Thanks,
Jan

2

Help for ParamQuery Pro / Uncaught TypeError: Cannot read properties of undefined (reading 'wdCenter')

« on: May 28, 2022, 10:34:42 pm »

Hi.

when grid is created in hidden div, attempt to show ends with error below (dims is undefined). When div is visible, grid works well.
PQ8.2.1, bootstrap4, jQuery

Thank you for help how to avoid it.

Jan

pqgrid.dev.js:4054 Uncaught TypeError: Cannot read properties of undefined (reading 'wdCenter')
    at pq.cRenderBody.refreshColumnWidths (pqgrid.dev.js:4054:19)
    at pq.cRenderBody.init (pqgrid.dev.js:16008:92)
    at t.paramquery.cRefresh.refresh (pqgrid.dev.js:4951:306)
    at pqgrid.dev.js:4921:7
    at pqgrid.dev.js:4930:23Uncaught TypeError: Cannot read properties of undefined (reading 'wdCenter')

3

Help for ParamQuery Pro / calling addRow but rows not dirty

« on: March 14, 2020, 07:27:50 pm »

Hello,

I am adding rows programmatically

         //set grid data
         $.each(dta.rows, function(i,item) {
            console.log(item);
             grid.addRow({ rowIndxPage: 0, rowData: item, checkEditable: false, history: true });
          });

having trackModel.on=true, dataModel.recIndx correctly set, but after adding rows there is no "dirty" redflag.

After editing any added row and change value, dirty flag appears correctly.

What is missing to make added rows dirty?

THX,
Jan

4

Help for ParamQuery Pro / Export to excel - negative number is exported as text

« on: October 13, 2019, 09:08:31 pm »

Hello,

working with code similar to PQ ver.5.6 Export demo - even in your demo negative numbers are exported to excel as text. Any workaround to have positive and negative integers exported as number?

Thanks.
Jan

5

Help for ParamQuery Pro / filter with simple <select>

« on: May 12, 2019, 10:53:50 pm »

Hello,
in most recent version when using filter with options there is allways opened pqwindow instead of standard <select>. Is it possible to easily use just simple combobox filled with options?
Thanks,
Jan

6

Help for ParamQuery Pro / arrow key navigation - events fired

« on: January 05, 2019, 09:37:43 pm »

Hello,

I am using rowselection similar to your demo https://paramquery.com/pro/demos51 demo: "Row selection". I need to navigate in grid using down/up arrow keys to change row selection. In my grid (and also in your demo) it works only with mouse click, but using arrow keys highlight another cells but selection remains the same. Is there any event to listen after navigation with arrow keys?

Thanks,
Jan

7

Help for ParamQuery Pro / column.exportRender not taken into account?

« on: November 25, 2018, 07:11:15 pm »

I am exporting grid to XLSX using following but all columns are exported regarless the column.exportRender is set to false (neither exportRender callback is not called) - see col0,col1 and col2.

  var blob = grid.exportData({format: 'xlsx', sheetName: 'report', render: true});
  saveAs(blob, "exported-report.xlsx");

    pqdata.colmodel[0].render = checkBoxRender;
    pqdata.colmodel[0].exportRender = false;
    pqdata.colmodel[1].exportRender = false;
    pqdata.colmodel[2].render = function(ui) {if (ui.Export) return ui.rowData['col10']; else return unescapeHTML(ui.cellData)};
    pqdata.colmodel[2].exportRender = function(ui) {console.log('here'); return ui.rowData['col10']};

Any help appreciated.

8

Bug Report / Attempt to print Excel sheet exported from PQGrid cause Excel crashed

« on: October 15, 2017, 10:52:35 pm »

Hello.

Using standard export to excel feature works well, Excel sheet contain desired data. When I try to print the sheet directly exported, Excel crashes (tested on multiple computers). When user saves the excel sheet first, any trouble while printing occurred.

Any idea what is wrong?

Thanks,

Jan

9

Bug Report / Clicking cell at bottom of grid moves it to be whole visible

« on: March 08, 2015, 03:29:27 pm »

Hello,

I can see that clicking the very bottom cell in your "cell selection" demo (which is partially hidden) causes the grid move vertically in order to have the selected cell completely visible. This is good and expected behavior.
But in my grid (which seems to use same parameters as in your demo) repositioning works wrong - it moves the bottom cell somewhere above top of visible area and somehow selects range from that cell to rowdndx+visible rows...

see screens.

Any help appreciated.

Thanks Jan

10

Help for ParamQuery Pro / custom sorting ignored

« on: February 18, 2015, 01:00:09 am »

Hello,

I have the following custom dataType in order to provide custom sorting on date fields using special date format:

var pqcolmodel=[
      {dataIndx: 'col1', title: '&nbsp;', width: '5px', align: 'center', copy: true, minWidth: 30},
      {dataIndx: 'col2', title: 'issued', width: '80px', align: 'right', dataType: function (val1, val2) {return compareDate(val1, val2);}, copy: true, minWidth: 30}
    ];

function compareDate() returns -1, 0, 1 depending on val1 and val2.

this is datamodel:
var pqdatamodel={
  location: 'local',
  data: pqdata1,
  sorting: 'local',
  sortIndx: ['col13'],
  sortDir: ['down']
}

But it seems the custom sorting is never called.
Even this code returns "undefined".

    //getter
    var colM = $( "#grid_md" ).pqGrid( "option", "colModel" );
    var dataType = colM[1].dataType;
    console.debug(dataType);

What do I do wrong?

Thanks,

Jan

11

Help for ParamQuery Pro / How to make column sorting and column order persistent

« on: December 17, 2014, 01:43:33 am »

Hello,

I started to use pqgrid in my applications and users are getting happy and appreciate its functions. They like the most custom sorting and re-ordering columns in grid. Is there any already prepared solution to make user customizations persistent (i.e. using cookies, ...)?
I could imagine I can store sorting options. But how to store re-ordered columns to be able to re-order them after default pqgrid initialization?

Thanks for an idea.

Jan

12

Help for ParamQuery Pro / How to scoll to given value?

« on: December 14, 2014, 01:02:46 pm »

Hello,

I have a grid with primary key column, having multiple pages. Am I able to programatically select proper page and scroll to proper row on there when I know the key value?

Any help appreciated.

Jan

13

Bug Report / tableToArray() error when table contains another table

« on: November 17, 2014, 07:18:31 pm »

I have something like this

<table><tr><td><table><tr><td>afashfjh</td></tr></table></td></tr></table>

when I use tableToArray, it generates doubled lines...

Thanks,

Jan

14

Help for ParamQuery Pro / selectionmodel: {type: 'row', mode: 'single'} prevents from keyboard navigation

« on: November 17, 2014, 01:32:26 pm »

Hello,

when set selectionmodel: {type: 'row', mode: 'single'} - it prevents from keyboard navigation up and down using arrow keys - event is send to body of page. When keep selection type "cell', keyboard works well. Am I doing something wrong?

Thanks, Jan