[Libreoffice-bugs] [Bug 117868] New: LibreofficeCalc - sep support from MSOffice on CSV files

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 117868
           Summary: LibreofficeCalc - sep support from MSOffice on CSV
                    files
           Product: LibreOffice
           Version: 6.0.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: LibreOffice
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: marin at sagovac.com

Description:
MSOffice Excell supports delimiter support and automatically recognized which
separator should use if defined in first line for CSV files.

Example of csv file:

sep=|
"LETTER"|"ANIMAL"
"a"|"aardvark"
"b"|"bear"
"c"|"cow"

That part "sep=|" at first line of code recognize automatically by MS and
separated as delimiter.

Steps to Reproduce:
1. Create a CSV document with first line delimeter "sep=|" anda fillup data
2. Open with libreoffice and autodetect sep delimiter type
3. Parse delimeter and open a Libreoffice Calc document using CSV

Actual Results:  
sep=|
"LETTER"|"ANIMAL"
"a"|"aardvark"
"b"|"bear"
"c"|"cow"

Expected Results:
LETTER  ANIMAL
a       aardvark
b       bear
c       cow


Reproducible: Always


User Profile Reset: Yes



Additional Info:
https://kb.paessler.com/en/topic/2293-i-have-trouble-opening-csv-files-with-microsoft-excel-is-there-a-quick-way-to-fix-this

Affects only on MS platform.

Tried on LibreOffice 5 from ubuntu 17.10 without affects.


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:60.0) Gecko/20100101
Firefox/60.0

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180529/79db1552/attachment.html>