https://bugs.documentfoundation.org/show_bug.cgi?id=117196
Bug ID: 117196
Summary: CSV import not happening correctly
Product: LibreOffice
Version: 5.1.6.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
My version:
Version: 5.1.6.2
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial2
CPU Threads: 2; OS Version: Linux 4.4; UI Render: default;
Locale: en-US (en_US.UTF-8); Calc: group
I have the following CSV plain text file, a few lines from which are:
"
Agilent Technologies,
114.49
AbbVie,
28.15
AmerisourceBergen,
20.38
Abbott Laboratories,
236.76"
There are spaces, tabs, newlines, and COMMAS between the text (company names)
and the numbers (P/E ratios).
I want to open it in calc with ONLY the comma as delimiter. I open the file in
Calc, and select delimiter as ONLY the comma. Calc doesn't split the two
fields into separate columns (as it should) instead it puts them in separate
rows!
Steps to Reproduce:
in description above
Actual Results:
Agilent Technologies
114.49
AbbVie
28.15
AmerisourceBergen
20.38
Abbott Laboratories
236.76
Expected Results:
Agilent Technologies|114.49 (in separate column) and SO FORTH
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Ubuntu Chromium/63.0.3239.84 Chrome/63.0.3239.84 Safari/537.36
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
