[X] I have searched the Github Issues for similar issues, but did not find anything.
Problem
Currently the univer sheet plugin works with separating different dropdown options like "formula1":"Yes,No,Maybe"
Since "," is a common symbol in text, this leads to problems in data processing when users have dropdown options like "Yes, lets do xyz" "No, lets do abc" since this would be displayed as 4 options in universheet.
I use OpenXML for parsing excel to workbook json and the raw data validation output looks like
Validation XML:
<x:dataValidation type="list" allowBlank="1" showInputMessage="1" showErrorMessage="1" sqref="C10:C12" xr:uid="{69FA879E-BF58-CA46-AAF8-23AF4BAD3C8A}" xmlns:xr="http://schemas.microsoft.com/office/spreadsheetml/2014/revision" xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><mc:AlternateContent xmlns:x12ac="http://schemas.microsoft.com/office/spreadsheetml/2011/1/ac" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"><mc:Choice Requires="x12ac"><x12ac:list>"Yes,lets do xyz","No, I dont want"</x12ac:list></mc:Choice><mc:Fallback><x:formula1>"Yes,lets do xyz,No, I dont want"</x:formula1></mc:Fallback></mc:AlternateContent></x:dataValidation>
<x12ac:list>"Yes,lets do xyz","No, I dont want"</x12ac:list>
In Excel Desktop separator " ; " is used
Proposal: Use different separator for dropdown options that's not a common symbol in text.
Initial checklist
Problem
Currently the univer sheet plugin works with separating different dropdown options like "formula1":"Yes,No,Maybe"
Since "," is a common symbol in text, this leads to problems in data processing when users have dropdown options like "Yes, lets do xyz" "No, lets do abc" since this would be displayed as 4 options in universheet.
I use OpenXML for parsing excel to workbook json and the raw data validation output looks like
Validation XML:
<x:dataValidation type="list" allowBlank="1" showInputMessage="1" showErrorMessage="1" sqref="C10:C12" xr:uid="{69FA879E-BF58-CA46-AAF8-23AF4BAD3C8A}" xmlns:xr="http://schemas.microsoft.com/office/spreadsheetml/2014/revision" xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><mc:AlternateContent xmlns:x12ac="http://schemas.microsoft.com/office/spreadsheetml/2011/1/ac" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"><mc:Choice Requires="x12ac"><x12ac:list>"Yes,lets do xyz","No, I dont want"</x12ac:list></mc:Choice><mc:Fallback><x:formula1>"Yes,lets do xyz,No, I dont want"</x:formula1></mc:Fallback></mc:AlternateContent></x:dataValidation>In Excel Desktop separator " ; " is used
Proposal: Use different separator for dropdown options that's not a common symbol in text.