Bug 117868 - LibreofficeCalc - sep support from MSOffice on CSV files
Summary: LibreofficeCalc - sep support from MSOffice on CSV files
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.4.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: CSV-Import
  Show dependency treegraph
 
Reported: 2018-05-29 06:50 UTC by Marin Sagovac
Modified: 2019-11-24 16:05 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Marin Sagovac 2018-05-29 06:50:34 UTC
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
Comment 1 Joao Farias 2018-05-31 21:59:45 UTC
Marin, thank you for your report.

I could reproduce the issue on version 6.4.0.2 [1] and 6.1.0.0.beta1 on macOS and 6.1.0.0.alpha1 on Windows.

Setting the status to NEW.


[1] - 6.0.4.2
Build ID: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf
CPU threads: 8; OS: Mac OS X 10.13.3; UI render: default; 
Locale: en-US (en_US.UTF-8); Calc: group

[2] - Version: 6.1.0.0.beta1
Build ID: 8c76dfe1284e211954c30f219b3a38dcdd82f8a0
CPU threads: 8; OS: Mac OS X 10.13.3; UI render: default; 
Locale: en-US (en_US.UTF-8); Calc: group

[3] - Version: 6.1.0.0.alpha1
Build ID: cb47f0d320994e001bc38dc2ee9b7d957b15e6ab
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: en-US (en_US); Calc: group
Comment 2 QA Administrators 2019-11-13 03:32:45 UTC Comment hidden (obsolete)
Comment 3 Roman Kuznetsov 2019-11-24 16:05:26 UTC
still repro in

Версия: 6.5.0.0.alpha0+ (x64)
ID сборки: 32dcf3f0fdafcf44457842a8aa4f54d30d856ca9
Потоков ЦП: 4; ОС:Windows 10.0 Build 17763; Отрисовка ИП: GL; VCL: win; 
Локаль: ru-RU (ru_RU); Язык интерфейса: ru-RU
Calc: threaded

but I think it's an enhancement