ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: cijojohn on May 04, 2017, 02:53:52 pm

Title: Issue with copy select dropdown and paste in some excel file
Post by: cijojohn on May 04, 2017, 02:53:52 pm

Hi Team,

I am facing issue while copy select dropdown and paste this into some excel file it pasted IDs of selected value.
 
i am using below editor option and i want to use like that only .
             
             editor: {
                  type: 'select',
                  options: [{ '': '' }, { 'SE': 'Speedy Express' }, { 'UP': 'United Package' }, { 'FS': 'Federal Shipping'}]
              },

i use https://paramquery.com/demos/editing_custom# for demo.

Please provide solution asap.

I am attaching scrren shot as well.

Title: Re: Issue with copy select dropdown and paste in some excel file
Post by: paramvir on May 04, 2017, 04:45:47 pm

You need to make changes as for ShipVia column here https://paramquery.com/pro/demos/editing_custom

Code: [Select]

                    { dataIndx: 'ShipViaId', hidden: true }, //hidden column to store ShipVia Id.
    { title: "Shipping Via", dataIndx: "ShipVia", width: 110,
        editor: {
            type: 'select',
            init: function (ui) {
                ui.$cell.find("select").pqSelect();
            },
            valueIndx: "value",
            labelIndx: "text",                        
                            mapIndices: {"text": "ShipVia", "value": "ShipViaId"},
            options: [
                            { "value": "", "text": "" },
                            { "value": "SE", "text": "Speedy Express" },
                            { "value": "UP", "text": "United Package" },
                            { "value": "FS", "text": "Federal Shipping" }
                            ]
        }        
    },


Title: Re: Issue with copy select dropdown and paste in some excel file
Post by: cijojohn on May 05, 2017, 03:58:13 pm

can't we do something in earlier demo.

Title: Re: Issue with copy select dropdown and paste in some excel file
Post by: cijojohn on May 09, 2017, 04:37:14 pm

Hi Team,

Is there a way to copy the rendered value of a drop down?

Similar to how we do export data using rendered option.

Thanks

Title: Re: Issue with copy select dropdown and paste in some excel file
Post by: paramvir on May 09, 2017, 10:34:32 pm

Currently only the cell values are copied, not the rendered values.