GridGroupingControl

[Prem]

I have more than 2000 characters in a word document (multiple lines). I copy it and paste it into a string column in a grouping control grid and it seems to paste the data
across mulitple rows in the grid. Am I missing something?

[Administrator]

The paste support that you are seeing is inherited through GridControlBase (the TableControl property in the GridGroupingControl). This support pastes text using tabs to mark new columns and newlines to mark new rows (as if the text came from rows and columns in Excel). So, the newlines in your Doc text are being pasted across multiple rows in the TableControl.

One way to avoid this behavior is to handle the TableCOntrolCurrentCellKeyDown event and do the paste yourself there. Here is a little code showing how.

//subcribe to the event
          this.gridGroupingControl1.TableControlCurrentCellKeyDown += new GridTableControlKeyEventHandler(gridGroupingControl1_TableControlCurrentCellKeyDown);

//the handler
        void gridGroupingControl1_TableControlCurrentCellKeyDown(object sender, GridTableControlKeyEventArgs e)
        {
            if (e.Inner.Control && e.Inner.KeyCode == Keys.V)
            {
                if (e.TableControl.CurrentCell.IsEditing)
                {
                    GridTextBoxCellRenderer renderer = e.TableControl.CurrentCell.Renderer as GridTextBoxCellRenderer;
                    if (renderer != null)
                    {
                        if (Clipboard.ContainsText())
                        {
                            string s = Clipboard.GetText();
                            renderer.TextBox.SelectedText = s;
                            e.Inner.Handled = true;
                        }
                    }
                }
            }
        }

[Prem]

Thanks Clay.
That worked great.

Thanks again!!

Prem

>The paste support that you are seeing is inherited through GridControlBase (the TableControl property in the GridGroupingControl). This support pastes text using tabs to mark new columns and newlines to mark new rows (as if the text came from rows and columns in Excel). So, the newlines in your Doc text are being pasted across multiple rows in the TableControl.

One way to avoid this behavior is to handle the TableCOntrolCurrentCellKeyDown event and do the paste yourself there. Here is a little code showing how.

//subcribe to the event
          this.gridGroupingControl1.TableControlCurrentCellKeyDown += new GridTableControlKeyEventHandler(gridGroupingControl1_TableControlCurrentCellKeyDown);

//the handler
        void gridGroupingControl1_TableControlCurrentCellKeyDown(object sender, GridTableControlKeyEventArgs e)
        {
            if (e.Inner.Control && e.Inner.KeyCode == Keys.V)
            {
                if (e.TableControl.CurrentCell.IsEditing)
                {
                    GridTextBoxCellRenderer renderer = e.TableControl.CurrentCell.Renderer as GridTextBoxCellRenderer;
                    if (renderer != null)
                    {
                        if (Clipboard.ContainsText())
                        {
                            string s = Clipboard.GetText();
                            renderer.TextBox.SelectedText = s;
                            e.Inner.Handled = true;
                        }
                    }
                }
            }
        }