Messages

1

Help for ParamQuery Pro / Re: scrolling with mouse wheel freezes

« on: August 06, 2022, 07:07:51 pm »

Hello,

in infinite rows demo it works well.
apparently after upgrade and refresh the problem disappeared.

thank you

Jan

2

Help for ParamQuery Pro / Re: scrolling with mouse wheel freezes

« on: June 21, 2022, 04:16:53 pm »

Hello,

I can confirm this behavior only in chrome, edge works well.
Unfortunately upgrade to 8.4.0 have not solved the problem.

Any other suggestion is welcome.

JK

3

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

4

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')

5

Help for ParamQuery Pro / Re: calling addRow but rows not dirty

« on: March 17, 2020, 03:47:15 pm »

calling addRow(rowList, history: true) completely solved my problem. Thanks for a help.

6

Help for ParamQuery Pro / Re: calling addRow but rows not dirty

« on: March 17, 2020, 03:34:46 pm »

Paramvir,

thank you, for making it more clear.

Is there any way how to put added rows into undo history in order to indicate something is changed?

Thanks,
Jan

7

Help for ParamQuery Pro / Re: calling addRow but rows not dirty

« on: March 15, 2020, 04:28:44 pm »

update: I made this disgusting hack which bring desired behavior, but not solved the reason

         //set grid data
         $.each(dta.rows, function(i,item) {
             var rowIndx=grid.addRow({ rowIndxPage: 0, newRow: {pKey: item.pKey, detail: item.detail, valEnd: item.valEnd, rowState: item.rowState}, checkEditable: false, history: false });
           //this is a nasty hack - grid does not indicate added rows dirty
             //but calling updateRow ends with exception :--(
             try {
               grid.updateRow({ rowIndx: rowIndx, newRow: {pKey: item.pKey, detail: item.detail, valEnd: item.valEnd, rowState: item.rowState}, checkEditable: false, history: true });
             }
             catch (e) {}
          });
 

8

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

9

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

« on: October 16, 2019, 12:57:21 am »

Thank you for an answer, unfortunately we have a productive system which cannot be upgraded easily to ver 6.1. Any workaround or manual fix locally? Thanks. Jan

10

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

11

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

12

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

13

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

« on: December 02, 2018, 04:04:25 pm »

this is it :--)
Thanks

14

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.

15

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

« on: October 19, 2017, 11:47:19 am »

Hello,

googling around it seems to be known Excel2010 behavior cause by wrong workbook.xml file generated by pqgrid.
The fix is to add   
  <bookViews>
    <workbookView />
  </bookViews>
before <sheets> element.  I have attached fixed xml which work for me.
Let me know when new version of fixed pqgrid is released.

Thnx,
Jan