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: [email protected]
ReportedBy: [email protected]
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.
