Messages

16

Help for ParamQuery Grid (free version) / Re: Problem on copy/paste and autofill for select elements

« on: September 11, 2023, 10:42:19 pm »

Either formulas or rowTemplate option are useful to handle copy/paste and autofill cases.

Please check this example based on formulas:

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

17

Help for ParamQuery Pro / Re: Update Grid Summary and Grouping Summary via Server

« on: September 11, 2023, 10:04:46 pm »

summary and grand summary auto refresh when any cell or row or number of rows are updated via updateRow method.

So I guess there is something incorrect in your implementation. Please share your code how are you updating the cells / rows.

18

News / Upgrade to Pro Version 9.0.2

« on: September 11, 2023, 07:02:49 pm »

Dear All

We are pleased to announce the release of version v9.0.2, a bug fix update for version 9.0.0

Release notes for version 9.0.0 are here: https://paramquery.com/forum/index.php?topic=4627.0

Some of the fixes are related to validation tooltip, copy/paste of text with line breaks, import/export to xlsx w.r.t ISO datetimes and difference of timezones, pivot grandsummary for count function, row selections.

Best Regards
The ParamQuery Team

19

Bug Report / Re: Inquiry about import excel date format (pqgrid 9.x)

« on: September 07, 2023, 03:47:41 pm »

Dear Kim

Its release is anticipated on Monday

If it's urgent for you, then you can download fixed version from here:

https://paramquery.com/pro2/Content/js9.0.2/pqgrid.min.js

Regards

20

ParamQuery Pro Evaluation Support / Re: How to automatically map data columns when uploading an Excel file after moving?

« on: September 05, 2023, 12:46:01 pm »

There is no dataIndx of columns in js workbook ( js equivalent of xlsx file ) so there is no automatic or direct way to map the column positions between grid and js workbook.

One way to do it is by matching the column titles in grid and js workbook provided the column titles are not changed in grid or Excel file after export.

Assign required indx to all cells in all rows in js workbook ( wb.sheets[0].rows[ i ].cells ) and then reorder all cells in all rows using sort method.

21

ParamQuery Pro Evaluation Support / Re: How to automatically map data columns when uploading an Excel file after moving?

« on: September 04, 2023, 11:05:29 am »

When excel file is imported in the grid, the columns in grid have the same order as in Excel file by default.

Kindly share a jsfiddle if you are facing any issues.

22

ParamQuery Pro Evaluation Support / Re: Nested Grids with Angular

« on: September 01, 2023, 06:45:40 am »

It's answered here: https://paramquery.com/forum/index.php?topic=4681.0

23

ParamQuery Pro Evaluation Support / Re: I want to download the professional SDK

« on: August 31, 2023, 11:37:18 am »

Dear sankyuJK

Your forum account has been upgraded to Pro Enterprise.

24

ParamQuery Pro Evaluation Support / Re: I want to download the professional SDK

« on: August 31, 2023, 06:47:56 am »

Hi sankyuJK

Kindly register with the same email with which you made the purchase or share your transaction details.

25

Bug Report / Re: Inquiry about import excel date format (pqgrid 9.x)

« on: August 30, 2023, 02:00:34 pm »

This issue has been fixed, though the corrected version is not available for download yet.

Please check the fix in this example: https://paramquery.com/pro/demos/import_xlsx_tabs and let me know your findings.

Regards

26

Help for ParamQuery Pro / Re: Interaction with table in scaled container

« on: August 29, 2023, 09:23:12 pm »

Hi Jesper

transform creates not one isolated but many layout problems related to key navigation, column resizing, grid maximize, etc functionality due to the aforementioned reason. So it would require changes at many places in the code.

I'm relooking into it for any viable solution.

Regards
Paramvir

27

Help for ParamQuery Pro / Re: select list

« on: August 29, 2023, 07:12:22 pm »

You need to update column.render callback

Code: [Select]

render: function(ui) {
  //console.log(ui.cellData);
  return {   
    //text: itemlistObj[ui.cellData] //this can also be used.
    text: itemlist.find( item => item.value==ui.cellData).label
  }
}

And there is no need to store id_label values in the rowData.

https://jsfiddle.net/2cdg1fLo/

28

Help for ParamQuery Pro / Re: Columns overlaps in case of the Animation mode is on

« on: August 25, 2023, 11:07:00 pm »

Do you get any error in the browser console?

Kindly share a jsfiddle for speedy resolution.

29

Help for ParamQuery Pro / Re: I want to know the status of a row.

« on: August 25, 2023, 07:55:36 am »

Please check beforeValidate and change events.

https://paramquery.com/pro/api#event-beforeValidate

https://paramquery.com/pro/api#event-change

30

Help for ParamQuery Pro / Re: react 18.2.0 set new data in pqgrid treeGrid

« on: August 24, 2023, 10:33:03 pm »

reactive option is not working with treegrid, hence it's not refreshing its UI when its state changes.

Please check this alternative way:

Code: [Select]

bthSearch_Click(event) { 
    this.callRef.current.setData(rGridColData2);
}


Code: [Select]

setData(data) {
    //either use this.
    /*this.grid.option('dataModel.data', data);
    this.grid.refreshDataAndView();*/

    //OR
    this.grid.setData(data);
}

https://stackblitz.com/edit/stackblitz-starters-ng8zwo?file=src%2FApp_disp.js