[data grid] Commas in exported files are not handled correctly if value is in array

[z0d14c]

Steps to reproduce

(Note: we are still on 6.x but as per the sandbox here it appears to happen in 7.x as well)

Link to live example: https://codesandbox.io/p/sandbox/cocky-haslett-kmw4hv?file=%2Fsrc%2FDemo.tsx%3A8%2C18

Steps:

1. Have data that is in an array and has commas -- e.g. the value is ["Test1, Test2"]
2. Use CSV export
3. Notice that the outputted value takes up more columns than expected, messing up that row's column alignment

This is a case not handled by #1143

Current behavior

The outputted value takes up more columns than expected, messing up that row's column alignment

What you can do right now as a workaround is use the valueFormatter -- although this somewhat bothers me as it seems to potentially affect more than just the csv export functionaltiy
e.g. you can do this:

            valueFormatter: ({ value, ...rest }) => {
              if (Array.isArray(value)) {
                return value.reduce((prev, curr) => {
                  return prev + curr
                }, '')
              }
              return value
            },

Expected behavior

Would be great if this worked as expected without the workaround of using valueFormatter

Context

We have values for our grid that are in arrays. These values can have strings with commas in them. We need to be able to export this data in a way that doesn't break columns.

Your environment

I don't know that this matters -- you can see that it occurs in the sandbox shared above.

Search keywords: commas, csv, export, arrays
Order ID: 77204

[michelengelen]

There is an option to use a different delimiter with the CSV export.
Here is an updated example to showcase that: Delimiter change on CSV export

Does that help you?

[github-actions]

The issue has been inactive for 7 days and has been automatically closed.