Re: ugernt
On Wed, 18 Feb 2015 10:23:24 + Gita Vadhwana gita...@live.co.uk wrote: I need help with my Open Office. My document all of a sudden turned into a 2 page book form. I need it to be regular document How can I change it backThank youGita Look at bottom right of OpenOffice window and click on the single page icon. -- Rory O'Farrell ofarr...@iol.ie - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: problem with import of excel file, cells contain new lines
Manuel == Manuel Andres Ramirez manuelandr...@aim.com writes: El 17/02/15 a las 10:06, Brian Barker escribió: 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 newlines. I could correct that manually, but since the file contains hundred of lines this is cumbersome. So the question is whether there exist any formatting function which could resolve the issue. You can use TRIM() or LIMPIAR() in spanish function over the column C and correct the spaces or tabs. Thanks but. I run for example clean(C2) and it returns Err:522 C is the column with the problems smime.p7s Description: S/MIME cryptographic signature
Re: problem with import of excel file, cells contain new lines
At 08:51 18/02/2015 -0500, Manuel Andres Ramirez wrote: El 17/02/15 a las 10:06, Brian Barker escribió: 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 newlines. I could correct that manually, but since the file contains hundred of lines this is cumbersome. So the question is whether there exist any formatting function which could resolve the issue. You can use TRIM() or LIMPIAR() in spanish function over the column C and correct the spaces or tabs. I tried TRIM(), but this seemed to do nothing in this case. It would not remove the tabs or line breaks or non-breaking spaces; it could remove the ordinary spaces, but only when they were trailing - so only if the non-breaking spaces had already been removed. Sorry, I tested with libreoffice in spanish and use LIMPIAR() function, so I translated wrongly as TRIM(), but now I realize that the correct function is CLEAN() Aha! You can see that my Spanish is non-existent! Try with CLEAN() over the Uwe attachment. In fact I had already tried using CLEAN() without success. I found that CLEAN() would remove the line break but only two tab characters at a time, so something like =CLEAN(CLEAN(CLEAN(C1))) was necessary even to remove all five tab characters. But that still left the space and the final non-breaking space. Applying TRIM() did not remove those, nor would VALUE() ignore them, so that transpired to be a dead end. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: problem with import of excel file, cells contain new lines
At 18:29 18/02/2015 +0100, Uwe Brauer wrote: I run for example clean(C2) and it returns Err:522. C is the column with the problems That means that your formula is circular. I'm guessing that you have tried putting =CLEAN(C2) into C2 itself. Apart from the fact that this deletes that value to are trying to recover, it suggests that you want the value in C2 to be a CLEANed version of the value in C2 - which is a CLEANed version of what is in C2! The formula refers back to itself repeatedly, and the calculation can never end. If you were to use a formula to achieve what you need, you would have to put it into a spare column. You could choose to copy the results back into the original cells, but you would need to use Paste Special instead of ordinary paste and to deselect Formulae in the Paste Special dialogue so as to freeze the results. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: problem with import of excel file, cells contain new lines
El 18/02/15 a las 12:56, Brian Barker escribió: At 08:51 18/02/2015 -0500, Manuel Andres Ramirez wrote: El 17/02/15 a las 10:06, Brian Barker escribió: 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 newlines. I could correct that manually, but since the file contains hundred of lines this is cumbersome. So the question is whether there exist any formatting function which could resolve the issue. You can use TRIM() or LIMPIAR() in spanish function over the column C and correct the spaces or tabs. I tried TRIM(), but this seemed to do nothing in this case. It would not remove the tabs or line breaks or non-breaking spaces; it could remove the ordinary spaces, but only when they were trailing - so only if the non-breaking spaces had already been removed. Sorry, I tested with libreoffice in spanish and use LIMPIAR() function, so I translated wrongly as TRIM(), but now I realize that the correct function is CLEAN() Aha! You can see that my Spanish is non-existent! Try with CLEAN() over the Uwe attachment. In fact I had already tried using CLEAN() without success. I found that CLEAN() would remove the line break but only two tab characters at a time, so something like =CLEAN(CLEAN(CLEAN(C1))) was necessary even to remove all five tab characters. But that still left the space and the final non-breaking space. Applying TRIM() did not remove those, nor would VALUE() ignore them, so that transpired to be a dead end. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org Yes, you're right. Maybe, as Andrew sugested in the list , the search and replace could be the solution. Try this. First, select the column C Call the search and replace option in the edit menu. In Search box fill with \n\t\t\t\t\t.. In Replace box left empty Click to open the more options mark option Only in current selection (I'm using a spanish versión, so I don't remember the correct words in english) mark oprtion Regular expression Click Replace all The pattern \n\t\t\t\t\t.. correspond to the weird caracters in cells of column C, if this pattern change, maybe this solution need a fix. Try it, and we'll see. -- Manuel Andrés Ramírez P. Administrador Informático GNU/Linux Registered User:412887 Visite:www.getgnulinux.org/es/ Yo Tengo mi Office Legal y no pagué por su licencia El placer más noble es el júbilo de comprender (Leonardo Da Vinci) - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: odt-file, ascii filter, series of pounds
Le 18/02/2015 01:06, Martin Groenescheij a écrit : 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. Hmm, how do you see that? I checked his first message and there is: Delivered-To: mailing list users@openoffice.apache.org Delivered-To: moderator for users@openoffice.apache.org Same for his second post BTW. So I still think that he's still not subscribed. Hagar - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: odt-file, ascii filter, series of pounds
Hi Hagar, You're correct. I use a filter to mark all emails Delivered-To: moderator This one was not marked (no idea why not), I should have checked before I replied. Sorry, I will check next time. Martin On 19-Feb-15 07:47, Hagar Delest wrote: Le 18/02/2015 01:06, Martin Groenescheij a écrit : 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. Hmm, how do you see that? I checked his first message and there is: Delivered-To: mailing list users@openoffice.apache.org Delivered-To: moderator for users@openoffice.apache.org Same for his second post BTW. So I still think that he's still not subscribed. Hagar - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Trouble!!!
Jochen Steinberg drums - samba-percussion Braustr. 6 24113 Kiel jochensteinb...@mail.de fest: 0431 - 79 94 70 85 mobil 0151 - 40009377 fax: 0431 - 88919072 Hy, I have many NEW problems with OO Calc these days - I work with and MacBook Pro 2013 and Yosemite Systemsoftware: Systemversion:OS X 10.10.2 (14C109) Kernel-Version: Darwin 14.1.0 Startvolume: SSD Startmodus: Normal Benutzername: Jochen Steinberg (jocsberg) Sicherer virtueller Speicher: Aktiviert Zeit seit dem Start: 9 Tage 2:00 What can I do? If I take some cells to another place on the same sheet Open Office breaks down without having stored the work I did. Big Shit! Please help me! Sincerely yours Jochen Steinberg drums - samba-percussion Braustr. 6 24113 Kiel jochensteinb...@mail.de mailto:jochensteinb...@mail.de fest: 0431 - 79 94 70 85 mobil 0151 - 40009377 fax: 0431 - 88919072
Re: problem with import of excel file, cells contain new lines
El 17/02/15 a las 10:06, Brian Barker escribió: 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 newlines. I could correct that manually, but since the file contains hundred of lines this is cumbersome. So the question is whether there exist any formatting function which could resolve the issue. You can use TRIM() or LIMPIAR() in spanish function over the column C and correct the spaces or tabs. I tried TRIM(), but this seemed to do nothing in this case. It would not remove the tabs or line breaks or non-breaking spaces; it could remove the ordinary spaces, but only when they were trailing - so only if the non-breaking spaces had already been removed. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org Brian, Sorry, I tested with libreoffice in spanish and use LIMPIAR() function, so I translated wrongly as TRIM(), but now I realize that the correct funtion is CLEAN() Try with CLEAN() over de Uwe attachment. Hava a nice day. -- Manuel Andrés Ramírez P. Administrador Informático GNU/Linux Registered User:412887 Visite:www.getgnulinux.org/es/ Yo Tengo mi Office Legal y no pagué por su licencia El placer más noble es el júbilo de comprender (Leonardo Da Vinci) - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: odt-file, ascii filter, series of pounds
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 17/02/15 16: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. I trust that you understand that you _FAILED_ to provide enough data for anybody to even begin to look for a solution to your alleged problem. I deliberately use the word alleged, because everything you provided points to PEBKAC. Start with your complete failure to describe your specific problem, and end up with your refusal to answer basic diagnostic questions. jonathon -BEGIN PGP SIGNATURE- Version: GnuPG v1 iQIcBAEBAgAGBQJU5S05AAoJEKG7hs8nSMR7cqUP/2yunQzix8Qd/RkW0/AUb+N1 KBkFvvqOh87ob95uyJB+AVJB6ymVlHf9iyAYMFy+ouGyEHaF9QQClxrxNEnOIjt+ 9B6TvspojsEIVwtvb5eU+qCqI4QhnksYQ79Vci09U18VX043biGcoyGKvRpWyNQb L+7KEjBrwggx46UzcCPvEy1fda7R+MsDBBqMKpDSpd890hJwJ6t5PSfHZmF29IOq z8ieq16IAiRTu9bEUFOdIlpK0vmqDJaFH8tsZ5LpLV6JyTSFzqd1biFciC7NwzYl 19C8gJKgQes0dDVs0TksJfFXC6ncL49Y+mMbj7Sx+ggOhruhUAXCvvkQJ1UBQ5lh 5d2G4fDCySPAFpQAdVAo3Q9B9whcpXRxCNatCDEC/qzKmh6wtknhA4qavOfW1Npk MFcmeWnBlGGYc82DjPvqIBZyVHgd8aaF/AUMcfqBTavQiHg5tOuyO5Ee69BMJCeU 5R5W19U1LEifJ9XhAAbN4fSjz0tq54U4P/BwX0I0PtuVIJf/RyenyW+tLs+NDuKU g3AfT4kJWC7Bd6eQq0RESba3mE3oBdvtfQ5wM3Ai0nOxROZ0LJtxmcHGt+XJFXXh njKVoajMs/nZSOtDk54SQkIOtRlLFJmh1RrymNVK/i5ok9SvNf5EjxUXBIhaRqFw vllAb8pMkbDd7n0viHy5 =czh2 -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
