You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2015/07/20 08:06:08 UTC

[Issue 126411] New: bad import CSV files with text delimiters

https://bz.apache.org/ooo/show_bug.cgi?id=126411

          Issue ID: 126411
        Issue Type: DEFECT
           Summary: bad import CSV files with text delimiters
           Product: Calc
           Version: 4.1.0
          Hardware: PC
                OS: Linux64
            Status: UNCONFIRMED
          Severity: normal
          Priority: P5
         Component: open-import
          Assignee: issues@openoffice.apache.org
          Reporter: uhrak.servit@seznam.cz

Opening CSV file with "TAB" as field delimiters and _"_ or _'_ as text
delimiters lead to text delimiters are imported ( except first column ) too.
Maybe I don't understand using of text delimiters, but Libre office (4.4.2)
works properly. ( at least of this one )

example :
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU' 
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU' 
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU' 
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU' 
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU' 
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU' 
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU' 
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU' 
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU' 
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU'

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126411] bad import CSV files with text delimiters

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126411

--- Comment #3 from setvit <uh...@seznam.cz> ---
"sample" you can obtain copy & paste ot 

'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU' 
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU' 
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU' 
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU' 
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU' 
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU' 
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU' 
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU' 
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU' 
'Soubor'      'Datum'      'OD'      'Předmět'      'KOMU'

what's wrong ?

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126411] bad import CSV files with text delimiters

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126411

--- Comment #1 from setvit <uh...@seznam.cz> ---
hm .. version 4.0.1 for Window works also properly


I have OpenSuse 13.1 and OpenOffice downloaded from official source ( link to
sourceforge from openoffice.cz )  as version 4.1.1. but Calc show version 4.1.0

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126411] bad import CSV files with text delimiters

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126411

mroe <mr...@gmx.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOT_AN_ISSUE
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #5 from mroe <mr...@gmx.net> ---
The delimiters in your testfile are TAB and Blanks together.

Import the file with

(*) Separated by
[x] Tab
[x] Space
[x] Merge delimiters
Text delimiter: '

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126411] bad import CSV files with text delimiters

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126411

--- Comment #6 from setvit <uh...@seznam.cz> ---
mroe, thanks .

There was a bug between char and keyboard.. :)

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126411] bad import CSV files with text delimiters

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126411

--- Comment #4 from setvit <uh...@seznam.cz> ---
Created attachment 84833
  --> https://bz.apache.org/ooo/attachment.cgi?id=84833&action=edit
test file ..

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126411] bad import CSV files with text delimiters

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126411

--- Comment #2 from mroe <mr...@gmx.net> ---
Please provide a sample CSV that the described behaviour can be reproduced
with.

-- 
You are receiving this mail because:
You are the assignee for the issue.