Re: Two issues I need help with

And if Ariel's excellent answer isn't complete enough, there is always the
wiki:

http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Regular_Expressions_in_Writer

Some of this stuff may be version dependent?

M

On Thu, Sep 8, 2011 at 5:54 PM, Ariel Constenla-Haile <
[email protected]> wrote:

> Hello Mark,
>
> On Thu, Sep 08, 2011 at 11:25:12AM -0400, Mark Saul wrote:
> > I'm a new user of Open Office.  Can anyone help me with two tasks?
> > Both are related to importing data into a word processing document.
> >
> > 1) Often, text comes in with a 'carriage return' (paragraph sign) at
> > the end of each line, which you have to get rid of.  Can I do this
> > with search-and-replace?
> >
> > In MS-Word, you just searched for '^p' and got all the paragraph
> > signs, which you could delete, replace, etc.  But I can't find the
> > corresponding command in Open Office.
> > Anyone?
>
> Menu Edit - Find & Replace... Ctr + F
> In that dialog, press "More options" and select "Regular expressions".
> You may also press "Help" in order to read the Help files, in the Help
> page look for "List of Regular Expressions", you see the list.
>
> Now, it depends on what you're trying to do. Are you trying to remove
> empty paragraphs? or you simply want to find the end of each paragraph?
>
> To find empty paragraphs:  ^$
> To find the end of the paragraph (the paragraph break): $
> >
> > 2) I try to import data from an open office spreadsheet into a word
> > processing document, simply by copying-and-pasting.  But the data
> > pasted in comes out in graphics format, and then I can't do anything
> > with it.
> >
> > In MS-Word, the data came through in table format, and you could do
> > what you want with it.
>
> Copy in Calc and Paste Special in Writer.
> Paste Special is menu Edit - Paste Special Ctr + Up + V
> You can also press the drop-down arrow in the paste tool bar icon.
> Try selecting "Formatted Text [RTF]" or "HTML", see which suits you.
> >
> > Can anyone help?  I thank you in advance.
>
> Regards
> --
> Ariel Constenla-Haile
> La Plata, Argentina
>



-- 
Martin du Saire
Biological Sciences Technician
USDA-ARS
470 Borlaug Hall
1991 Upper Buford Circle
St. Paul, Minnesota 55108

612-625-9747
[email protected]
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help