[data grid] Clipboard copy places unnecessary quotations when copied text contains a quotation

[louisaaron]

Steps to reproduce

Link to live example: https://www.loom.com/share/c38d8abb4a464b3185bafff09eea2939?sid=731700af-53e5-4884-960d-252ff196b419

Steps:

1. Type content into a cell which includes a quotation mark. For example, Test " Text
2. Copy it
3. Paste it into another cell

Current behavior

Extraneous quotation marks are added

Expected behavior

Text should be pasted as it was copied

Context

Trying to copy and paste cells with text which contain a quotation mark

Your environment

npx @mui/envinfo

  Don't forget to mention which browser you used.
  Output from `npx @mui/envinfo` goes here.

Search keywords: Copy Paste Quotations
Order ID: 85118

[MBilalShafi]

Thanks @louisaaron for reporting.

I can confirm the issue. It's in the clipboard copy rather than paste. It's because of the following code block:

mui-x/packages/x-data-grid/src/hooks/features/export/serializers/csvSerializer.ts

Lines 11 to 16 in e12acf2

	if ([delimiterCharacter, '\n', '\r', '"'].some((delimiter) => value.includes(delimiter))) {
	if (shouldAppendQuotes) {
	return `"${value.replace(/"/g, '""')}"`;
	}
	return `${value.replace(/"/g, '""')}`;
	}

Looking at the git diff, it might be a regression introduced in #12357

I'm adding it to the board for the team to prioritize.

[louisaaron]

Awesome thanks @MBilalShafi !

[cherniavskii]

Duplicate of #12456

[github-actions]

⚠️ This issue has been closed. If you have a similar problem but not exactly the same, please open a new issue.
Now, if you have additional information related to this issue or things that could help future readers, feel free to leave a comment.

@louisaaron: How did we do? Your experience with our support team matters to us. If you have a moment, please share your thoughts in this short Support Satisfaction survey.