incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 121305] New: OO sets single additional quotation mark when importing csv, this prevents conversion to number
Date Fri, 02 Nov 2012 18:59:23 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=121305

          Priority: P3
            Bug ID: 121305
          Assignee: ooo-issues@incubator.apache.org
           Summary: OO sets single additional quotation mark when
                    importing csv, this prevents conversion to number
          Severity: critical
        Issue Type: DEFECT
    Classification: Application
                OS: Windows 7
          Reporter: tempory.man@web.de
          Hardware: PC
            Status: UNCONFIRMED
           Version: AOO 3.4.1
         Component: open-import
           Product: spreadsheet

Created attachment 79852
  --> https://issues.apache.org/ooo/attachment.cgi?id=79852&action=edit
Screenshots with integrated explanations to all scenarios

when I import csv-files with text separator " to OO, and select "values in
quatation marks as text" at the import dialog, OO adds an additional '
quotation mark at the left end of the cell.
This makes converting the cells to numbers impossible.
Removing the ' sign with the search&replace dialog is also impossible.

Even if I replace all " text-separators with ' text separators before
importing, the additional ' is set!

If I don't use the option "values in quatation marks as text" all numbers with
3 and more decimal places loose their decimal point, so an importing this way
is also impossible.
I think the . is interpreted as thousands separator which is not a good idea.

Tested with the german version.

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

Mime
View raw message