🐛下载格式化数据内容有,逗号的会在Excel中按逗号拆分成多个单元格，但是复制格式化数据就不会出现这种情况

[1542769387]

🏷 Version

Package	Version
@antv/s2	2.0.0-next.27
@antv/s2-react	^2.0.0-next.26

Sheet Type

• PivotSheet
• TableSheet

🖋 Description

下载格式化数据内容有,逗号的会在Excel中按逗号拆分成多个单元格，但是复制格式化数据就不会出现这种情况

⌨️ Code Snapshots

const s2DataConfig: S2DataConfig = {
fields: {
rows: ['province', 'city'],
columns: ['type', 'sub_type'],
values: ['number'],
},
meta: [
{
"field": "number",
"name": "数量",
formatter: (value, record, meta) => {
return Number(value).toFixed(3).toString().replace(/(\d)(?=(\d{3})+.)/g,"$1,")
// return ${value / 100} %
},
},
{
"field": "province",
"name": "省份"
},
{
"field": "city",
"name": "城市"
},
{
"field": "type",
"name": "类别"
},
{
"field": "sub_type",
"name": "子类别"
}
],
data: res.data,
};

🔗 Reproduce Link

(https://s2.antv.antgroup.com/examples/react-component/export/#export)

🤔 Steps to Reproduce

将上面的s2DataConfig替换掉链接中的s2DataConfig 点击下载格式化数据和复制格式化数据，会发现下载格式化数据内容有,逗号的会在Excel中按逗号拆分成多个单元格，但是复制格式化数据就不会出现这种情况

😊 Expected Behavior

😅 Current Behavior

💻 System information

Environment	Info
System
Browser

[1542769387]

1.X 使用S2/packages/s2-core/src/utils/export/export-worker.ts 文件中的
export function getCsvString(v: any): string {
if (!v) {
return v;
}

const value = replaceEmptyFieldValue(v);

if (typeof value === 'string') {
const out = value;
// 需要替换", https://en.wikipedia.org/wiki/Comma-separated_values#Example
return "${out.replace(/"/g, '""')}";
}

return "${value}";
}
方法进行格式化后导出的