From ooo-users-return-2518-apmail-incubator-ooo-users-archive=incubator.apache.org@incubator.apache.org Tue Aug 21 20:48:04 2012 Return-Path: X-Original-To: apmail-incubator-ooo-users-archive@minotaur.apache.org Delivered-To: apmail-incubator-ooo-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 959F725E for ; Tue, 21 Aug 2012 20:48:04 +0000 (UTC) Received: (qmail 13311 invoked by uid 500); 21 Aug 2012 20:48:04 -0000 Delivered-To: apmail-incubator-ooo-users-archive@incubator.apache.org Received: (qmail 13268 invoked by uid 500); 21 Aug 2012 20:48:04 -0000 Mailing-List: contact ooo-users-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ooo-users@incubator.apache.org Delivered-To: mailing list ooo-users@incubator.apache.org Received: (qmail 13260 invoked by uid 99); 21 Aug 2012 20:48:04 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Aug 2012 20:48:04 +0000 X-ASF-Spam-Status: No, hits=2.3 required=5.0 tests=RCVD_IN_BRBL_LASTEXT,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: 77.92.64.122 is neither permitted nor denied by domain of niallandjenny@blueyonder.co.uk) Received: from [77.92.64.122] (HELO smtp1.cix.co.uk) (77.92.64.122) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Aug 2012 20:47:56 +0000 Received: (qmail 23982 invoked from network); 21 Aug 2012 20:41:51 -0000 Received: from unknown (HELO ?192.168.0.4?) (rndmartin@82.41.253.252) by smtp1.cix.co.uk with ESMTPA; 21 Aug 2012 20:41:51 -0000 From: "Niall Martin" To: ooo-users@incubator.apache.org Date: Tue, 21 Aug 2012 21:41:57 +0100 MIME-Version: 1.0 Subject: Re: Trouble with Open Office 3.4 Calc Reply-to: niall@rndmartin.cix.co.uk Message-ID: <5033F295.3324.288CAF9@niallandjenny.blueyonder.co.uk> Priority: normal In-reply-to: References: X-mailer: Pegasus Mail for Windows (4.63) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body I download the file, and open in a text editor (Notepad? - I use TextPad). I then highlight the whole less the headings, and copy the highlighted material. I then open the spreadsheet bank statement file, and then paste. A dialogue comes up asking me how It wants the material dealt with. I make sure that the comma separated option is ticked. It is also convenient to set the other separator as single quote. I then OK and all is well. If that is not clear perhaps you could say what exactly you are doing. Best wishes On 21 Aug 2012 at 11:51, William Smith wrote: Send reply to: ooo-users@incubator.apache.org Date sent: Tue, 21 Aug 2012 11:51:36 -0400 Subject: Trouble with Open Office 3.4 Calc From: William Smith To: ooo-users@incubator.apache.org > Open Office 3.4 Calc turns the csv files I get from my bank into > unintelligible rubbish which, in turn, makes them unsuitable for > CSV2OFX. Earlier versions of Calc did not do this. My question is: > can I keep version 3.4 for the text, formula, presentation, etc. > functions and revert back to an earlier version of Open Office calc? > If so, how do I do this? > > WPS > Niall Martin Phone 0131 4678468 Please reply to: niallrndmartin.cix.co.uk --------------------------------------------------------------------- To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org For additional commands, e-mail: ooo-users-help@incubator.apache.org