Re: odt-file, ascii filter, series of pounds

2015-02-17 Thread Martin Groenescheij
On 18-Feb-15 13:24, Julian Thomas wrote: On Feb 17, 2015, at 11:19, tom cuypers wrote: I've received some other answers that convince me my specific problem is unsolvable so it's no use answering your questions. Have you tried: Saving as a csv file Using a good text editor on that file to f

Re: odt-file, ascii filter, series of pounds

2015-02-17 Thread Julian Thomas
> On Feb 17, 2015, at 11:19, tom cuypers wrote: > > I've received some other answers that convince me my specific problem is > unsolvable so it's no use answering your questions. Have you tried: Saving as a csv file Using a good text editor on that file to fix the issues to create a new csv

Re: odt-file, ascii filter, series of pounds

2015-02-17 Thread Martin Groenescheij
On 18-Feb-15 03:19, tom cuypers wrote: Dennis, I've received some other answers that convince me my specific problem is unsolvable so it's no use answering your questions. Even if the problem is unsolvable (in your case), it is preventable by setting the options for AutoRecovery interval a

Re: odt-file, ascii filter, series of pounds

2015-02-17 Thread Martin Groenescheij
On 18-Feb-15 09:47, Hagar Delest wrote: Top posting. For the record, OP is not subscribed so he has missed almost all the replies. For the record, OP was subscribed at the moment he raised the question. He has one point however, this is a longstanding problem that tells that the saving proc

Re: odt-file, ascii filter, series of pounds

2015-02-17 Thread Hagar Delest
Top posting. For the record, OP is not subscribed so he has missed almost all the replies. He has one point however, this is a longstanding problem that tells that the saving process is not safe enough, see this long list: https://forum.openoffice.org/en/forum/viewtopic.php?f=6&t=17677#p81363 I

RE: odt-file, ascii filter, series of pounds

2015-02-17 Thread tom cuypers
Dennis, I've received some other answers that convince me my specific problem is unsolvable so it's no use answering your questions. Tom > From: dennis.hamil...@acm.org > To: users@openoffice.apache.org > CC: tomcu...@hotmail.com > Subject: RE: odt-file, ascii filter, series of pounds > Date

Re: problem with import of excel file, cells contain new lines

2015-02-17 Thread Andrew Pitonyak
So you might need to user a macro unless there is a string  replacement method Does calc support find and replace for these characters... Perhaps with a regular expression. On Feb 17, 2015 10:06 AM, Brian Barker wrote: > > At 09:19 17/02/2015 -0500, Manuel Andres Ramirez wrote: > >El 17/02

Re: problem with import of excel file, cells contain new lines

2015-02-17 Thread Brian Barker
At 09:19 17/02/2015 -0500, Manuel Andres Ramirez wrote: El 17/02/15 a las 06:00, Uwe Brauer escribió: I periodically receive excel files (generated by Office 2010 I think, but saved in the old binary format). Some of these columns cause me problems, since they seem to contain spaces and even

Re: problem with import of excel file, cells contain new lines

2015-02-17 Thread Manuel Andres Ramirez
El 17/02/15 a las 06:00, Uwe Brauer escribió: Hello I periodically receive excel files (generated by Office 2010 I think, but saved in the old binary format). Some of these columns cause me problems, since they seem to contain spaces and even newlines. I could correct that manually, but since

Re: problem with import of excel file, cells contain new lines

2015-02-17 Thread Brian Barker
At 12:00 17/02/2015 +0100, Uwe Brauer wrote: I periodically receive excel files (generated by Office 2010 I think, but saved in the old binary format). Some of these columns cause me problems, since they seem to contain spaces and even newlines. I could correct that manually, but since the file

General Error. General input/output error

2015-02-17 Thread Ron Clough
OO 4.1.1 Win 8.1 Attempting to open files saved in .txt format is for the first time today resulting in the message 'General Error. General input/output error'. I'll appreciate help from the list to solve this problem. Regards, Ron

problem with import of excel file, cells contain new lines

2015-02-17 Thread Uwe Brauer
Hello I periodically receive excel files (generated by Office 2010 I think, but saved in the old binary format). Some of these columns cause me problems, since they seem to contain spaces and even newlines. I could correct that manually, but since the file contains hundred of lines this is cumb