incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Niall Martin" <>
Subject Re: Trouble with Open Office 3.4 Calc
Date Tue, 21 Aug 2012 20:41:57 GMT
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
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

Best wishes

On 21 Aug 2012 at 11:51, William Smith wrote:

Send reply to:
Date sent:	Tue, 21 Aug 2012 11:51:36 -0400
Subject:	Trouble with Open Office 3.4 Calc
From:	William Smith <>

> 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?

Niall Martin
Phone 0131 4678468
Please reply to: niall<at>

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message