Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - hyh888

Pages: [1] 2 3
1
Help for ParamQuery Grid (free version) / save data when batch-copy for select column and pivot grid
« on: November 07, 2024, 12:35:14 pm »
When batch-copying data into select(dropdown) column, the new updated data of select(dropdown) column could not be saved to server.
But if use mouse to click the select element one by one to change the data, the changes can be saved to server.
Maybe there's something wrong for pqgrid.
Would you like to provide a sample for saving select batch-copying data?
When set the width of first column(in https://paramquery.com/pro/demos/pivot) to 500px, after press "edit and run", the width of first column keep unchanged(still 158px).


        var colM = [
            //extra column to show grouping (for both pivot and row grouping mode, used along with groupModel.titleIndx )           
            {
                title: 'Group', tpHide: true, menuInHide: true,
                dataIndx: 'grp',
           width:500,//width is changed here , but no expected result.
                menuUI: {
                    tabs: ['hideCols'] //display only hide columns tab in menu.
                }
            },

2
Help for ParamQuery Grid (free version) / How to control summary row style of pivottable
« on: November 06, 2024, 02:30:56 pm »
Dear Team,
Would you like to provide some example to contor the  summary row style of pivottable?

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?

3
Bug Report / Bug in edit select demo version 9 and 10
« on: November 04, 2024, 01:14:46 pm »
In https://paramquery.com/pro/demos91/edit_select, user can batch copy unexpectable data into select-element columns(column 1 and column 3) without being warned.
It's also happen in version 10.
It seems there are many bugs for select in other demos  too.
If there's a way to show warning, would you like to add it in demo?
For select colulmn in https://paramquery.com/pro/demos/datamap, illegal data are unable to copied into grid.
For select colulmn in https://paramquery.com/pro/demos/readonly_cells, illegal data can be copied into grid(column 2) without warning.

4
Suggest new features / Add column head when copy
« on: May 10, 2024, 06:52:46 am »
Dear Team,
When copying data from grid to excel, column head couldn't be pasted to excel. Would you like to copy column head for copy action?
Notice: when copy between pqgrid, the column head shouldn't be pasted, it can be judged by pqgrid.

5
ParamQuery Pro Evaluation Support / When Array data are used as data source, how to control column attribut as json?
« on: March 17, 2024, 05:16:08 pm »
When Array data are used as data source, how to control column attribut as json-data's? Such as width,default value,editor type of the column.

6
Bug Report / bug in demo for select editing--pasted-data couldn't triger ShipViaId to update
« on: March 17, 2024, 12:07:30 pm »
Dear Team,
When  testing demo in https://paramquery.com/pro/demos/edit_select, if I pasted data in column ShipVia, the ShipViaId column will keep being blank, unless clicked and selected data in select of ShipVia column.

7
Bug Report / Width attribute for the column of pivottable doesn't work.
« on: March 08, 2024, 06:58:20 am »
Dear,
In you demo for pivot grid，I change the width attribute of the first column("grp") to 300 in colM, and press "Edit and Run" button , but  it doesn't work.
It seems that firstly the attribute is functioned, but when the  summary  data is loaded , the atrribute is overrided with unknow reason. I can see the width of first column is wide and then shrinked.
I tried to change width of other column, it also doesn't work.
Here is the code:

        var colM = [
            //extra column to show grouping (for both pivot and row grouping mode, used along with groupModel.titleIndx )           
            {
                title: 'Group', tpHide: true, menuInHide: true,
                dataIndx: 'grp',
                  width:300,///////////////////////////////////////////////////// I made change here
                menuUI: {
                    tabs: ['hideCols'] //display only hide columns tab in menu.
                }
            },

8
ParamQuery Pro Evaluation Support / How to change the background color of summary (or subtotal) rows in pivot table?
« on: February 24, 2024, 02:01:12 pm »
Dear Paramvir,
Is there any method for  changing the background color and font color of summary (or subtotal) rows in pivot table?
It seems there is no method for changing width of first column of pivot table too.

9
Help for ParamQuery Grid (free version) / bug in treegrid
« on: September 27, 2023, 06:00:48 am »
When the pid of the top root node in treegrid is 0( for the database in my company required that pid field couldn't be null.), the treegrid couldn't be show out.
When I tried modify the response data which come from server, it wil make a lot of trouble in select box in treegrid.
Is there any way to fix the bug?

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

11
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?

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

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

Pages: [1] 2 3