Messages

1

Help for ParamQuery Grid (free version) / Re: EndSelect and SelectChange couldn't be triggered when use button to add new row

« on: August 21, 2023, 10:24:42 am »

In my case, there are master and slave grids, when click diffrent cell in master grid, endSelect is used to change content in slave grid by querying data from server. If "new product" button could not trigger EndSelect or SelectChang, the data in slave grid will not change, but the focus is in the last row(new row), but the focus is in the new row.
It will make misunderstanding for users.
End-user will find that a empty new row which has a slave grid with related-data of other row(at this time, the focus is in the new row).

2

Help for ParamQuery Grid (free version) / EndSelect and SelectChange couldn't be triggered when use button to add new row

« on: August 21, 2023, 04:22:19 am »

in Batch editing demo, EndSelect and SelectChange events  couldn't be triggered when use "new product" button to add a new row. This will make a lot of trouble in master-slave grid case, developer couldn't control the slave grid when user use "new product" button to add a new row.

3

Help for ParamQuery Grid (free version) / width of the first column of pivottable is uncontrollable

« on: July 10, 2023, 04:26:17 pm »

The width of the first column of pivottable is uncontrollable, even I add width in field property.
It seems that the conditional style is also unavailable in pivottable.
If it is possible, can an example is provided?

4

Help for ParamQuery Pro / Re: Bug in pivot demo

« on: July 06, 2023, 11:24:27 am »

Dear Paramvir,
It really works in my application. You're the best.
I hope you can make a demo in your website, and let more people know it.
It's  really a powerful function.

5

Help for ParamQuery Pro / Re: Bug in pivot demo

« on: July 05, 2023, 04:02:40 pm »

million thanks, I will try it.

6

Help for ParamQuery Pro / Re: Bug in pivot demo

« on: July 04, 2023, 08:06:32 pm »

But for average and count function, you have to keep the original execution order.  Maybe pqGrid should use UDF to mark the division or multipliation formula, then after data loaded in interface to calculate the formula for UDF fields.

7

Help for ParamQuery Pro / Re: Bug in pivot demo

« on: July 04, 2023, 06:44:09 pm »

After pivot table loaded, let pqgrid calculate fumula for all related columns。By this way(only adjust the order of js function excecuted), maybe the efficency of qpGrid can be improved, and its function get more powerful.
I'm tring to find the whereness to change it, but it's really difficult for the code has been compressed.

8

Help for ParamQuery Pro / Re: Bug in pivot demo

« on: July 04, 2023, 02:51:23 pm »

Dear Paramvir,
Do you mean that this issue couldn't be fixed in pqGrid?
You know that this is a very useful function of the pivottable in excel.
I'm tring to debug your code, would you like to inform me where to change the code to fix it?
Or may be after pivot table loaded, let pqgrid calculate fumula for all related columns?

9

Help for ParamQuery Pro / Bug in pivot demo

« on: July 04, 2023, 11:49:56 am »

When  the pivot demo's foumula is changed to  do division(  line 89,  code as below ),  the "sum(total)" column's value is wrong.
Is there any solution for it?

formulas: [['total', function(rd){
    var total = rd.gold /rd.silver;
    return isNaN(total) || !isFinite(total)? "": total;
}]],

In the following pic, in the 1st line, the result should be 2.1, but it becomes 8.

10

Help for ParamQuery Grid (free version) / Re: Trouble in pivot demo

« on: June 28, 2023, 07:49:26 am »

Dear Paramvir，
Should this issue be treated as a bug?

11

Help for ParamQuery Grid (free version) / Re: The comma in format "#,###" make json object in trouble

« on: June 26, 2023, 06:25:37 am »

For the template engine in my program regards "###" as comment symbol, so the js program was disabled partially.
Is there any other way to repalce format "#,###"?

12

Help for ParamQuery Grid (free version) / Re: Trouble in pivot demo

« on: June 22, 2023, 06:15:05 pm »

Dear Paramvir,
Thank you very much for your reply, but when I tried your solution in your demo, almost all results are wrong(even not "infinit").
In the following pic, in the 1st line, the result should be between 2 and 3, but it becomes 8.

13

Help for ParamQuery Grid (free version) / Trouble in pivot demo

« on: June 16, 2023, 07:10:45 pm »

When I change the pivot demo's foumula to make it do division( line 89-------  var total = rd.gold /rd.silver; ), I found the "sum(total)" column's value change to "infinity".
Is there any solution for it?

14

Help for ParamQuery Grid (free version) / The comma in format "#,###" make json object in trouble

« on: June 12, 2023, 01:44:46 pm »

When I use  format "#,###" , it makes json object in trouble in browser. I think many users should have suffered for it.
Here is the code:
let gridColModel= [

{   "title": "production",
    "dataIndx": "actualProdTon",
    "width": "100",
    "dataType": "float",
    "format": "#,###"
}

];

15

Help for ParamQuery Grid (free version) / pivot table with formula for different feilds

« on: June 01, 2023, 06:45:20 pm »

After studied the demo for pivot, I wonder if pqgrid can add formula for different feilds, if it's possible, would you like to provid a sample?. In your demo the formula is for two years in one field which is not what I need.
I made a demo with excel pivot table in attachment, the formula column is marked with yellow,the growthrate column is formula column,growthrate=(qty/lastYearQty-1).