Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Dana Comolli
870
How to copy the unformatted cell values to the clipboard
posted

Using the PerformAction(UltraWinGrid.UltraGridAction.Copy) method to copy the collection of selected cells seems to always copy the formatted (ie. displayed) value rather than the actual cell value.  This can lead to significant rounding issues if a user is trying to copy values to Excel and then do some types of calculations on the pasted value.

Is there a way to cause the grid to copy the actual cell values or must we implement this functionality on our own.

Dana

Parents
  • 469350
    Offline posted

    Hi Dana,

    Copying from the grid uses the display text because that's what the user sees. It would be a little odd to expose values the user cannot see via copy and paste when the use cannot other see those values - although I can understand that in some cases it might be useful.

    If the column in question is using the MaskInput property, then you might try setting the MaskClipMode on the column to something like Raw so that it copies the entire value. I'm not sure this will work with the MultiCellOperation copying and it might not work if you are using the Format property of the column in addition to the MaskInput, but it's worth a try.

    If that doesn't work, then I think you will probably need to handle this manually for now. But you should also Submit a feature request to Infragistics.

Reply Children