Author Topic: Issue with copy select dropdown and paste in some excel file  (Read 3018 times)

cijojohn

  • Pro Ultimate
  • Jr. Member
  • *
  • Posts: 73
    • View Profile
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.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Issue with copy select dropdown and paste in some excel file
« Reply #1 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" }
                            ]
        }        
    },

cijojohn

  • Pro Ultimate
  • Jr. Member
  • *
  • Posts: 73
    • View Profile
Re: Issue with copy select dropdown and paste in some excel file
« Reply #2 on: May 05, 2017, 03:58:13 pm »
can't we do something in earlier demo.

cijojohn

  • Pro Ultimate
  • Jr. Member
  • *
  • Posts: 73
    • View Profile
Re: Issue with copy select dropdown and paste in some excel file
« Reply #3 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

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Issue with copy select dropdown and paste in some excel file
« Reply #4 on: May 09, 2017, 10:34:32 pm »
Currently only the cell values are copied, not the rendered values.