Copy formatting cell from GridDataBoundGrid

[Elad]

Hi,

I want to copy cell from GridDataBoundGrid.

The cell format is currency.

When I select the cell it's being a text without format.

For Example : 1,000,123$ become 1000123

I want to copy the cell with the format - How can I do it?

(I upgrade VS from oldest version that it work well, in VS2015 it not work weel)/

Thank

[Piruthiviraj Malaimelraj]

Hi Elad, 

Thanks for your interest in Syncfusion products. 

We have analyzed your scenario with VS2015 and 4.6 Framework , but unfortunately we could not able to reproduce the issue at our end. Could you please provide the below details? It would be more helpful for us to provide the solution at the earliest. 

·         Ensure whether the reported issue is reproduced in attached sample. 

·         Let us know , which Syncfusion build version is you are using in your project. 

·         Let us know , if you have any customization regarding copy and paste in your sample. 

·         Please provide the simple video of your sample execution. 

Please refer to the attached video and sample, 

Sample link: 

http://www.syncfusion.com/downloads/support/directtrac/general/ze/Sample7.3_VB-1859696098  

Video link: 

http://www.syncfusion.com/downloads/support/directtrac/general/ze/CellFormatting-1418150719  

 

Regards, 

Piruthiviraj 

[Elad]

Thank you for replying.

I tested your project and realized that the problem occurred when I changed this line

Me.gridDataBoundGrid1.Binder.InternalColumns("Description").StyleInfo.Format = "##,###$"

to 

  Me.gridDataBoundGrid1.Binder.InternalColumns("Description").StyleInfo.CellType = "Currency"

Is there is a way to do copy and paste with format when the format setting is by CellType?

[Piruthiviraj Malaimelraj]

Hi Elad, 

Thanks for the update. 

We could able to understand your scenario. As per our Grid architecture, when the format string is set by using GridStyleInfo.Format property, the formatted text will be copy/paste properly. To avoid the reported scenario, please use anyone of the below suggestions, 

 

Suggestion 1: 

To paste the text with applied formats of “Currency” type columns, customize the Clipboard contents by using ClipboardCopy event. Please make use of the below code, 

 

Code example: 

Me.gridDataBoundGrid1.Binder.InternalColumns("Description").StyleInfo.CellType = GridCellTypeName.Currency 

 

AddHandler Me.gridDataBoundGrid1.Model.ClipboardCopy, AddressOf Model_ClipboardCopy 

 

Private Sub Model_ClipboardCopy(ByVal sender As Object, ByVal e As GridCutPasteEventArgs) 

                Dim range As GridRangeInfo = e.RangeList.ActiveRange 

                Dim text As String = String.Empty 

                Dim data As DataObject = CType(Clipboard.GetDataObject(), DataObject) 

 

                For row As Integer = range.Top To range.Bottom 

                                For col As Integer = range.Left To range.Right 

                                                text &= Me.gridDataBoundGrid1.Model(row, col).FormattedText 

                                                If col <> range.Right Then 

                                                                text &= Constants.vbTab 

                                                End If 

                                Next col 

                                text &= System.Environment.NewLine 

                Next row 

                Clipboard.SetDataObject(New DataObject(text)) 

                e.Handled = True 

                e.Result = True 

End Sub 

Suggestion 2: 

Set the format by using GridStyleInfo.Format property as like below code, 

Me.gridDataBoundGrid1.Binder.InternalColumns("Description").StyleInfo.Format = "##,###$" 

Me.gridDataBoundGrid1.Binder.InternalColumns("CategoryID").StyleInfo.Format = "C" 

Suggestion 3: 

Set the cell type of the columns in where you want to paste the contents also as “Currency”. 

 

Me.gridDataBoundGrid1.Binder.InternalColumns("Column2").StyleInfo.CellType = GridCellTypeName.Currency 

Me.gridDataBoundGrid1.Binder.InternalColumns("Column3").StyleInfo.CellType = GridCellTypeName.Currency 

 

 

Sample link: 

http://www.syncfusion.com/downloads/support/directtrac/general/ze/SampleVB1759000803  

 

Regards, 

Piruthiviraj

[Elad]

Thank you for replying.

Unfortunately, this example doesn't work for me.

When I select the cell it's being unformatted.

What is the main differences between :

  Me.gridDataBoundGrid1.Binder.InternalColumns("Description").StyleInfo.CellType = "Currency"

and:

Me.gridDataBoundGrid1.Binder.InternalColumns("Description").StyleInfo.Format = "C" 

??

and why in oldest version of VS it work perfectly?

[Piruthiviraj Malaimelraj]

Hi Elad, 

 

Thanks for the update. 

 

Query	Response
Unfortunately, this example doesn't work for me.  When I select the cell it's being unformatted.	We could not able to reproduce the issue at our end. Please refer to attached video.  Can you please provide the simple video or screenshots of replication procedure of the scenario? It would be more helpful for us to analyze further on this scenario.    Video link:   SampleVideo
Difference between Currency celltype and “C” format.	The “Currency” cell type can be used to represent monetary values to achieve accuracy in the calculations. You can customize the currency cell appearance (i.e currency symbol, decimal separator, etc..) by using GridStyleInfo. Please refer to the below UG document,  https://help.syncfusion.com/windowsforms/grid/cell-types#currency-cell-type
Why in oldest version of VS it work perfectly?	We have checked this scenario with all VS versions. But unfortunately we could not able to reproduce the issue at our end.     ·         Please ensure whether any assembly conflicts occurred in your project.  ·         Provide the Syncfusion build version details that you are using in sample.

 

 

Regards, 

Piruthiviraj