incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 115447] Importing CSV file with double-quoted numbers treats numbers as text
Date Fri, 14 Sep 2012 17:39:03 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=115447

jobeard <jbeard1185@roadrunner.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jbeard1185@roadrunner.com

--- Comment #1 from jobeard <jbeard1185@roadrunner.com> ---
confirmed:
CVS file download from a site (ie user is not in control of the downloaded
formatting)
"Date","No.","Description","Debit","Credit"
"8/21/2012",,"ATM 3921-008659 BK WEST N       MOORPARK RD THOUSAND OAKSCA    
##9854","40.0000",
"8/21/2012",,"ATM 147372         ARCO AMPM    8344    THOUSAND OAKSCA     
##9854","24.6400",
"8/21/2012",,"ATM CALIFORNIA DO-IT CTR #      THOUSAND OAKS   CA ON
120821##9854","-8.0000",

(notice, there is no single quote anywhere)

imports for debits or credits result in the columns 
'24.6400 
'-8.0000
the extra ' makes the field TEXT and can not be used in arithmetic formulas

NASTY field by field editing is required to remove the extra quote.

OO v3.4.0 and lastest 3.4.1

-- 
You are receiving this mail because:
You are on the CC list for the bug.

Mime
View raw message