Hi -
I have a dataset bound to an ultrawingrid. One of the column [Status] is assigned a ValueList which contains only two values - Approved or UnApproved. Depending on the value for each row, I display an Image in the Status column cell for that particular row. and I am using the following code
statusList.DisplayStyle = ValueListDisplayStyle.Picture; e.Layout.Bands[0].Columns["MapStatus"].ValueList = statusList; e.Layout.Bands[0].Columns["MapStatus"].CellActivation = Activation.NoEdit;
where statusList is my ValueList.
Now when I export the rows to excel,I am expecting the actual value [ie either Approved/UnApproved] to be exported to excel, which is not happening.The column is empty when exported. Is there something that I am missing here or how do we accomplish this..?
Thanks
Rajesh
Hi Rajesh,
What version of the controls are you using?
What are the contents of the ValueList? Are you populating the list with items that have both a DataValue and DisplayText?
Thanks for your time Mike
The version is 9.2
Following is the code that I have in the Initializelayout event of the Grid
// Create a ValueList with an image for each item. ValueList statusList = e.Layout.ValueLists.Add("Status");
ValueListItem vli = statusList.ValueListItems.Add("Approved");vli.Appearance.Image = XYZ.Resources.Approve;
vli = statusList.ValueListItems.Add("UnApproved");vli.Appearance.Image = XYZ.Resources.Denied;// Set the DisplayStyle to Picture so that the list displays only pictures, and no textstatusList.DisplayStyle = ValueListDisplayStyle.Picture;// Assign the ValueList to the column and disable Edite.Layout.Bands[0].Columns["MapStatus"].ValueList = statusList;e.Layout.Bands[0].Columns["MapStatus"].CellActivation = Activation.NoEdit;
And then I bind the dataset which contains a column named 'MapStatus'. I have added the Approved and Denied icons to the resource file and I set them to the valuelistitem as seen in the code above.Depending on the value [Approved/UnApproved] in the dataset, I am able to see the corresponding image displayed in the cell for the Status Column.But when I export the row, this data is missing.I am not sure whether the images get exported , but at the least the expectation is that the actual cell value [ie Approved/Unapproved] gets exported .
Hi,
I'm a little confused. Why can't you filter?
The code I posted here is going to essentially cover up the cell with an image. But the value was already written into that cell. So Excel should allow you to filter - it will just show the strings on the filter dropdown list instead of the image. There' no way around that as far as I know.
HI MIke
I am continuing this work, after export to excel the image is displayed in the excel sheet, problem is i am not able to Filter the rows based on the MapStaus Image column, as images will not come in the FIlters,please help me to solve this.
Thanks guys
Hello, After some research, the "Ability to export an image to an excel file" has been determined to be a new feature request. I have sent your feature request directly to our product management team. Our product team chooses new feature requests for development based on popular feedback from our customer base. Infragistics continues to monitor application development for all of our products, so as trends appear in requested features, we can plan accordingly.
We value your input, and our philosophy is to enhance our toolset based on customer feedback. If your feature is chosen for development, you will be notified at that time. Your reference number for this feature request is FR14127.
If you would like to follow up on your feature request at a later point, you may contact Developer Support management via email. Please include the reference number of your feature request in the subject and body of your email message. You can reach Developer Support management through the following email address: dsmanager@infragistics.com
Thank you for your request.
Hello rajeshall,
I created the following case for you: 'CAS-84953-YR8GN5' and will update you through it about the progress of this issue.
Please do not hesitate to contact us if you need any additional assistance.