[Libreoffice-bugs] [Bug 102368] FILESAVE: data list with comma ", " saved as *.xlsx give wrong data list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=102368

Korrawit Pruegsanusak  changed:

   What|Removed |Added

 Attachment #127612|application/octet-stream|application/vnd.oasis.opend
  mime type||ocument.text

-- 
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

[Libreoffice-bugs] [Bug 102368] FILESAVE: data list with comma ", " saved as *.xlsx give wrong data list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=102368

Korrawit Pruegsanusak  changed:

   What|Removed |Added

 Attachment #127611|application/octet-stream|application/vnd.oasis.opend
  mime type||ocument.spreadsheet

-- 
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

[Libreoffice-bugs] [Bug 102368] FILESAVE: data list with comma ", " saved as *.xlsx give wrong data list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=102368

Martin Spacek  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |DUPLICATE

--- Comment #7 from Martin Spacek  ---


*** This bug has been marked as a duplicate of bug 90104 ***

-- 
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

[Libreoffice-bugs] [Bug 102368] FILESAVE: data list with comma ", " saved as *.xlsx give wrong data list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=102368

--- Comment #6 from Mike Kaganski  ---
Created attachment 129197
  --> https://bugs.documentfoundation.org/attachment.cgi?id=129197=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:
>  
> showErrorMessage="true" showInputMessage="false" sqref="A1" type="list">
>  1,2,3,4
>  0
>
>  

2. When opening in Excel 2013, correcting and saving back, it saves this:
>  
> showErrorMessage="1" sqref="A1">
>   xmlns:x12ac="http://schemas.microsoft.com/office/spreadsheetml/2011/1/ac; 
> xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006;>
>
>  1,"2,3",4
>
>
>  "1,2,3,4"
>
>  
>
>  

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

[Libreoffice-bugs] [Bug 102368] FILESAVE: data list with comma ", " saved as *.xlsx give wrong data list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=102368

--- Comment #5 from vlb  ---
(In reply to Bartosz from comment #4)
> I could confirm bug with .xlsx file format.
> The bug doesn't exists with .xls file format.

Is this bug resolved for LO 5.3?

-- 
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

[Libreoffice-bugs] [Bug 102368] FILESAVE: data list with comma ", " saved as *.xlsx give wrong data list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=102368

Bartosz  changed:

   What|Removed |Added

Summary|FILESAVE: save as *.xlsx|FILESAVE: data list with
   |give wrong data list|comma "," saved as *.xlsx
   ||give wrong data list

-- 
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