https://issues.apache.org/ooo/show_bug.cgi?id=115447
jobeard <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from jobeard <[email protected]> --- 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.
