Messages

1

Help for ParamQuery Pro / Apply styles and formatting to cells in exported excel

« on: March 28, 2019, 07:24:56 pm »

I have some styles and formatting applied to grid cells in column render function, like below.
render: function (ui) {     
                    //apply styles and replace every comma by new line for each cell             
                    return { style: "color:red", text: ui.cellData ? ui.cellData.replace(/,/g, '<br/>') : "" };
                }

I would like to have the same implemented in excel exported using exportData.

I tried using options nopretty and cssRules, but syntax is not present anywhere in API.

Could you please help by providing details on how to implement the above in grid?
Also, if there are examples for other options in exportData function, it will be helpful.

2

Suggest new features / Enable Auto filter on excel exported from grid

« on: October 12, 2018, 04:48:03 pm »

When I export data from grid to excel using exportData function, I wish to add Auto Filter option to the excel headers and the user should be able to filter records directly using the header filters.

I could not find anything relevant in Demos and API for this. Please assist.

PQGrid version used is : 3.3.5

3

Help for ParamQuery Pro / pqgrid copy cell not working inside pop-up with jquery draggable

« on: May 03, 2018, 03:47:26 pm »

I'm trying to use pqgrid inside a pop-up to which I have applied jquery draggable. I'm unable to copy the cell value using native select.

Any suggestions?

pqgrid version: 3.3.5

4

Help for ParamQuery Pro / Re: Show Loading on click of Export when data is huge

« on: May 03, 2018, 01:25:48 pm »

pqgrid version: 3.3.5

5

Help for ParamQuery Pro / Show Loading on click of Export when data is huge

« on: May 03, 2018, 01:21:31 pm »

When the grid data is huge, on click of Export there is a significant delay before the file gets downloaded. I wish to show the loading message on click of Export. But $( ".selector" ).pqGrid( "showLoading" ); does not work.

Tried showing a separate loader gif on screen over pqgrid, but that also does not show up until the file gets downloaded. Also tried adding a separate click event handler, but pqgrid's internal handler takes precedence.

Tried using a setTimeout after showing my loader in the export listener. This did half the work - showed my loader image, but there were errors in pqgrid.js

6

Suggest new features / Re: Filtering individual columns based on dropdown and textbox.

« on: September 19, 2017, 11:32:23 am »

Thanks for the prompt response. Appreciate it.

7

Suggest new features / Re: Filtering individual columns based on dropdown and textbox.

« on: September 18, 2017, 06:34:59 pm »

Hi ,

Thanks for the quick response. The link you had shared has the filter at the grid level. I want to implement this feature at column level. My column needs to have two controls
a)Textbox for entering the search text
b)Dropdown for selecting the type of filter (Contains/Begins with)

Please let me know if this is possible. Thanks in advance.

8

Suggest new features / Filtering individual columns based on dropdown and textbox.

« on: September 18, 2017, 05:00:46 pm »

Is it possible to apply filters to indvidual columns in the grid using more than one control(Textbox and dropdown). For example, i want to filter a column named City based on text input. For this i should have an option to select the type of filter (Contains/Equal to) which is going to be a dropdown. Any leads will be highly appreciated. Please see the attached image for reference.

9

Help for ParamQuery Pro / Re: Issue with sorting column containing float values

« on: May 16, 2017, 08:29:10 pm »

Hi ,Thank You for your prompt reply.

Since we are binding it as JSON object, all the values will be bound as string.

Also,I had this doubt as well, so in the render of the column, I return the celldata as parsefloat(ui.celldata) and it still worked incorrectly.

Further, I have one more query. The same logic works fine for Integer and Date, where there is no explicit conversion of values and everything is bindided as JSON object.

Please advise.

Regards,
Lakshmi

10

Help for ParamQuery Pro / Issue with sorting column containing float values

« on: May 16, 2017, 04:33:41 pm »

I am using currently PRO Version of PQ grid. I have already gotten in touch with PQ -Grid team via mail, where-in the reply was to add "datatype:float". I have been using datatype:float in the column and initiating it when getting data, i.e.in  "Getdata" function, as here we use Remote method and column bindings are dynamic. Other data types like Integer, Date works just fine except the float. Please help if there is something that's missing. Once column model is build, it is binding to grid, as below :

Grid.option("colModel", columnmodel);

This is how the obj is built :
columnmodel.push(
            {
                title: "PRICE",
                dataIndx: "price",
                editable: false,
               
            });
//say if Price is in index 0,
        if (columnName == "PRICE") {
            columnmodel[0].dataType = 'float';
        }

It gets sorted wrongly like this :

109.51
111.74
112.57
1124.08
113.14
113.5
Kindly advise