how do I export data with DropDownProvider columns in grid

485

Pablo De Lucca posted over 12 years ago

how do I export data with DropDownProvider columns. I see the number code in excel!

DataexportMode is DataInGridOnly and the grid shows me the correct description but after export excel show me the codes of these columns

why?

thanks

Pablo

Parents

12679

[Infragistics] Radoslav Minchev posted over 12 years ago

Hi patitene,

This is expected behavior, simply because, the exported values are the cell values not text. You likely can override this behavior by handling cell exported event of the excelExporter. You can check the arguments passed to this event, there should be a reference to the grid cell which actually has been exported.

Hope this helps
Cancel
Reply

Cancel
485

Offline Pablo De Lucca posted over 12 years ago in reply to [Infragistics] Radoslav Minchev

Ok, but where I get the description to replace the code? the arguments of the event has no such descriptions thanks, Pablo
Cancel
Reply

Cancel

Reply

49378

[Infragistics] Petar Ivanov posted over 12 years ago in reply to Pablo De Lucca
Hello patitene,

Thank you for your patience.

After investigating the scenario further it seems that the value of the dropdown item is set as both the value and text of the respective grid cell on the server.

I have asked our engineering staff to examine this further. To ensure that it will receive attention, I have logged this behavior in our internal tracking system with a Development ID of 123288. The next step will be for a developer to review my investigation and confirm my findings or to offer a fix, or other resolution.

Your support ticket regarding this matter is CAS-100718-Q6X0X0.  Feel free to continue to send updates to this case at any time.

You can view the status of the development issue connected to this case by selecting the "Development Issues" tab when viewing this case on the web site.

It is however still possible to achieve your requirement by mathching the respective value with the dropdown provider's item onCellExporting:

Code Snippet

    if (e.WorksheetCell.ColumnIndex == 1 && !e.IsHeaderCell)

    {

        int rowIndex = e.CurrentRowIndex;

        string cellValue = WebDataGrid1.Rows[rowIndex - 1].Items.FindItemByKey("ProductName").Value.ToString();

        DropDownItem item = WebDataGrid1_DropDownProvider1.EditorControl.Items.FindItemByValue(cellValue);

        if (item != null)

        {

            e.Cancel = true;

            string textFromDDProvider= WebDataGrid1_DropDownProvider1.EditorControl.Items.FindItemByValue(cellValue).Text;

            e.WorksheetCell.Value = textFromDDProvider;

        }

    }

}

Please let me know if you need more information.
Cancel
Reply

Cancel

Children

49378

[Infragistics] Petar Ivanov posted over 12 years ago in reply to Pablo De Lucca

Hello Paul,

Thank you for your reply. Glad that you were able to find a solution.

Regarding the development issue I logged, our engineers have confirmed that this is in fact the expected behavior of the grid - the serverside Text property is intended for the developer's use, while the clientside text and value of each item are set internally based on it's editor provider (if present).

Please do not hesitate to contact me if you have any questions.
Cancel
Reply

Cancel
485

Offline Pablo De Lucca posted over 12 years ago in reply to [Infragistics] Petar Ivanov

Thanks Petar:

anyway I found the solution prior to its response, but thanks for considering that in your development team.
My solution works for all columns:

Infragistics.Web.UI.GridControls.DropDownProvider Description = (Infragistics.Web.UI.GridControls.DropDownProvider)WebHierarchicalDataGrid1.EditorProviders.GetProviderById(e.GridCell.Column.Key);
if (Description != null)
e.WorksheetCell.Value = Estado.EditorControl.Items.FindItemByValue (e.GridCell.Text). Text;

tanks,

Paul
Cancel
Reply

Cancel