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 2012/09/14 19:39:03 UTC

[Bug 115447] Importing CSV file with double-quoted numbers treats numbers as text

https://issues.apache.org/ooo/show_bug.cgi?id=115447

jobeard <jb...@roadrunner.com> changed:

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

--- Comment #1 from jobeard <jb...@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.