[data grid] Is there a way to ignore the actions columns on paste in the data grid?

[cullen-hutchison-FHR]

The problem in depth

Hello,

I encountered an issue while copy-pasting full grows in the data grid. One of the columns in our datagrid is an actions column that doesn't carry a value. Copying from this column works as expected, giving a tab-separated list of row values. However, when pasting, the first element from our clipboard gets placed in the actions column, resulting in all columns being off by one.

I have a functional solution using the splitClipboardPastedText prop. I check the length of each row and if it is equal to column definition length - 1, then it "must" be a full row, so I add an empty string to the beginning of the array. Is there another way to go about this or a way to explicitly ignore the actions column on paste?

Recreated our solution on stackblitz

Your environment

`npx @mui/envinfo`

``` System: OS: Linux 6.5 Debian GNU/Linux 12 (bookworm) 12 (bookworm) Binaries: Node: 20.14.0 - /usr/local/share/nvm/versions/node/v20.14.0/bin/node npm: 10.7.0 - /usr/local/share/nvm/versions/node/v20.14.0/bin/npm pnpm: Not Found Browsers: Chrome: Not Found npmPackages: @emotion/react: 11.11.4 @emotion/styled: 11.11.5 @mui/base: 5.0.0-beta.40 @mui/core-downloads-tracker: 5.15.18 @mui/icons-material: 5.15.18 @mui/lab: 5.0.0-alpha.170 @mui/material: 5.15.18 @mui/private-theming: 5.15.14 @mui/styled-engine: 5.15.14 @mui/system: 5.15.15 @mui/types: 7.2.14 @mui/utils: 5.15.14 @mui/x-data-grid: 7.4.0 @mui/x-data-grid-premium: 7.4.0 @mui/x-data-grid-pro: 7.4.0 @mui/x-date-pickers: 7.4.0 @mui/x-date-pickers-pro: 7.4.0 @mui/x-license: 7.2.0 @types/react: 18.3.2 react: 18.2.0 react-dom: 18.2.0 typescript: ~5.4.5 => 5.4.5 ```

Search keywords: clipboard actions datagrid copy paste Order ID: 87778

[michelengelen]

Hey @cullen-hutchison-FHR ... i'll have a look shortly!

[michelengelen]

It looks like we could do better here. I agree. I am just not sure how atm. I'll add this to the board for the team to have a look! Thanks for raising this!