https://bugs.documentfoundation.org/show_bug.cgi?id=102368
--- Comment #6 from Mike Kaganski <mikekagan...@hotmail.com> ---
Created attachment 129197
--> https://bugs.documentfoundation.org/attachment.cgi?id=129197&action=edit
A file with validity list in A1 having a "2,3" item
This is a complex problem.
1. When saving the file from LO, it creates the following items in sheetN.xml:
> <dataValidations count="1">
> <dataValidation allowBlank="true" operator="equal" showDropDown="false"
> showErrorMessage="true" showInputMessage="false" sqref="A1" type="list">
> <formula1>"1,2,3,4"</formula1>
> <formula2>0</formula2>
> </dataValidation>
> </dataValidations>
2. When opening in Excel 2013, correcting and saving back, it saves this:
> <dataValidations count="1">
> <dataValidation type="list" operator="equal" allowBlank="1"
> showErrorMessage="1" sqref="A1">
> <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>1,"2,3",4</x12ac:list>
> </mc:Choice>
> <mc:Fallback>
> <formula1>"1,2,3,4"</formula1>
> </mc:Fallback>
> </mc:AlternateContent>
> </dataValidation>
> </dataValidations>
Note that it uses x12ac:list, which is discussed here:
https://msdn.microsoft.com/en-us/library/documentformat.openxml.office2010.excelac.list.aspx
- and it is only available since v.2013.
When opening the above Excel-saved file in LO, it doesn't import validity
condition (incl.list) properly (test the attachment).
3. I don't have Excel 2010 to test, but testing with Excel 2007, it seems to be
unable to create such items itself, so possibly it's missing functionality in
versions prior to 2013.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs