I'm wondering if anyone else has ran into this issue.
I'm having an issue when copying data from the XamGrid to the clipboard. I have a template column that contains a hyperlink control that represents a customer # in our database. I allow the users to select columns and rows that they want to copy and then click ctrl-c to copy the data to the clipboard. But when they paste it into excel, word, notepad, etc., the customer # column is blank. The header is there, but the data is not. How can keep the column a hyperlink and have the actual data present for export?
Below is the code for template column as well as the class that is used to convert the value into an URI.
Thanks
Hello lonnie3072,
I have been looking into your posts and I have been trying to reproduce your issue with no success. Instead of unbound field with HyperlinkButton I am using our XamGrid’s HyperlinkColumn. I am sending you my sample application(XamGridHyperlink.zip). Please tell me if I have misunderstood you.
I am looking forward to hearing from you.
Using the Hyperlink column does allow the copy function to work properly.
But the issue is that I don't won't to display the actual link in the grid. I want to display a customer # such as 234523 that is a hyperlink like http://www.mypage.com/search.aspx?QueryCustomerID=234523 that will load that's customer's information.
Is there a way to do that with the hyperlink column? If so, I was unable to find any examples of it.
Using the below code, I do have the customer # column appearing the way that I want and the hyperlink works as expected.
When I copy / paste the grid into excel, the customer number column ends up being the value of the url, not the customer #. Is there a way to have the customer # copied instead of the url?
New grid with column displaying column number that is a hyperlink.
I'm selecting all the rows and clicking ctrl-c to copy the data from the grid.
New Hyperlink Column markup
<ig:HyperlinkColumn ContentBinding="{Binding CustomerNumber}" ValueConverter="{StaticResource Conv}" Key="CustomerNumber" HeaderText="Customer #" TargetName="_blank"></ig:HyperlinkColumn>
I have been looking into your post and copying the URL, instead of the customer # is the expected result from the copy operation. I was wondering how exactly would you like this column's valuesto be presented in Excel : plain text only or hyperlink, like in the XamGrid ?
The grid is working just like we want it to. It displays the 'Customer #' but is a hyperlink that opens the page successfully.
When we press 'ctrl-c' to copy that data from the grid, we want that column to be pasted as plain text with just the 'Customer #'.
As is, it paste plain text, but it's the underlying URL. We do not want the URL, just the 'Customer #'.
I am just checking if you require any further assistance on the matter.