Messages

16

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.

17

ParamQuery Pro Evaluation Support / Re: When Array data are used as data source, how to control column attribut as json?

« on: March 28, 2024, 01:03:43 pm »

Dear Team,
Do you mean that the first column(datatype is number) in array data will be treated as index(or ID ) of every line?
If the string column is the index of data, how to make it?

18

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.

19

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.

20

Bug Report / Re: Width attribute for the column of pivottable doesn't work.

« on: March 08, 2024, 08:23:11 am »

Thank you very much, it works.

21

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.
                }
            },

22

Help for ParamQuery Grid (free version) / Re: bug in treegrid

« on: February 27, 2024, 02:39:18 pm »

I have to make a patch like this to solve two in-build problem of tree.

        function getChanges(grid) {

            let list =grid.getChanges({ format: 'byVal' });

            list.addList.forEach(item => {
                delete item.id;
                if(!item.pid)item.pid=0;
            });
            list.updateList.forEach(item => {
                 delete item.items;
                if(!item.pid)item.pid=0;
            });

            return list;
        }

23

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.

24

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?

25

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

26

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.

27

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?

28

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.

29

Help for ParamQuery Pro / Re: Bug in pivot demo

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

million thanks, I will try it.

30

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.