Messages

31

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.

32

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?

33

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.

34

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?

35

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 "#,###"?

36

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.

37

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?

38

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": "#,###"
}

];

39

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

40

Help for ParamQuery Grid (free version) / Can blank lines in pivot be hide?

« on: April 25, 2023, 06:13:08 am »

Blank lines in pivot table make bad custumer experience, can they be hide?

41

Suggest new features / Re: upload image in cell

« on: March 19, 2023, 08:10:56 pm »

waiting for the good news.

42

Suggest new features / upload image in cell

« on: March 16, 2023, 07:04:03 am »

Would PQGrid support upload image in cell?
This will make pqgird more useful.
If this function is already available, let me know.

43

Help for ParamQuery Grid (free version) / Formula function may result in difference for data in interface and database.

« on: December 25, 2022, 06:02:40 pm »

When using fomula to input product code in column A and autumatically show product name in column B in sales order, somedays later, the name of a product is changed( in master data), in old sales order the old name should be expected to be show but in the  new created order the new name is expected to be shown. If formula is used, the old sales order will show the new name, even old name is recorded in the table of sales order lines in database. If there is a solution for this condition? 

In some case the price of product always changes, if using formula get price in database, it'll make trouble too， especially when there is redundance design in database table structure.
The price in interface will be different with price in database.
Any advice?

44

Help for ParamQuery Pro / set default value for pqgrid column, there is a "Uncaught TypeError: Cannot rede

« on: November 21, 2022, 07:08:30 am »

Wheng using following code to set default value for pqgrid column, there is a "Uncaught TypeError: Cannot redefine property: id"  problem.
The code comes from https://paramquery.com/forum/index.php?topic=4347.0.
            rowTemplate: {},
            complete: function(){
                let rt = this.option('rowTemplate'), cm = this.getColModel();
                cm.forEach(function(col){
                    let def = col.defaultValue, di = col.dataIndx;
                    if( def !== undefined ){
                        Object.defineProperty(rt, di, {
                            enumerable: true,
                            get(){
                                var val = this[ "_" + di];
                                return val == null? def: val;;
                            },
                            set(val){
                                this[ "_" + di ] = val;
                            }
                        });
                    }
                });
            },

45

Bug Report / Re: Too many item in select, make select editor out of function

« on: November 16, 2022, 07:47:08 am »

It's realy a pity to make so much trouble to spot it as a bug.