incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 119230] New: Importing a .csv file inserts a single quote at the beginning of currency cells
Date Sun, 15 Apr 2012 16:14:00 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=119230

             Bug #: 119230
        Issue Type: DEFECT
           Summary: Importing a .csv file inserts a single quote at the
                    beginning of currency cells
    Classification: Application
           Product: Spreadsheet
           Version: OOo 3.3
          Platform: PC
        OS/Version: Windows XP
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: open-import
        AssignedTo: ooo-issues@incubator.apache.org
        ReportedBy: blnsfu@yahoo.com


My .csv file contains cells that look like this: -$97.00 and $137.00. The
import process inserts a single quote (') as the first character of such cells,
so they look like this: '-$97.00 and '$137.00. 

If you test the first cell (as in =if(A1>0;... where A1 contains '-$97.00), the
condition evaluates to TRUE even though the value appears to be negative
(unless you look at the cell contents carefully.

This problem would merely be irritating except that Find and Replace will not
find the leading '.

Regards.

-- 
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

Mime
View raw message