Re: Two issues I need help with

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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iQIcBAEBCAAGBQJOaUevAAoJEMjP1bm45QNWrrUP/RXBjYDeb21p19obuYJ9Cu9W
2hmU0mpGzR4a56/Wm+N13OBeBIIJLAGrVccAubTOrjcRy3uaRP+wBd3DWUo45zhM
5ruaHUwlQTbpW0iHPkB5P0RrjA/FXSaLXWZL11cJVdgRybDs991qY9lI0ZE1HbkW
k2bQQdtNDnUAZKBWGli72e1wROsJeCuJw5ecCl7yWdbzoWckbAp/8RQRXYXRFrJJ
6vNai6TEGXRolG1xFQWHxQAlLyh3h40RNyg12dbSyyydOBDWE7W8Ocn38Yra2/Ee
f6+ucC4VLhWYwpO9f70uEAMdV1+7eHBBSGwapmk8c4tkBZTILztTdduhhQRXHNln
AHg+aCoBVPsWCukKfBlcz7BnyR7qLCRi0zD/jHy2ZPHQmKXS+h1PbQNIff0OhSg5
fjgRYlqV5RiEmdJS5bgnEjOMTCaL80feMh60Z2M9NkVmNwFpd2Y1boi4+5LmZdYM
jAFFP7qO6i6hjTa6Dvm+TkGd55LtLwEMHGywBA29kXNMs3dzZ8yQavkh35ZL7Wu5
2AmSW7GTm/BhaI/dALlZeAcJtdFnaJHS1CvdpDc46eC8miJDoT/N91dggWBsPHZu
hjGZnx9oVlpc90a4E0mIwHiiTRvhsOqe2VsNB54ccrh2o3jfyWkqVNyORY4j30EZ
HZ2TsNPSk2BLxsufYeYc
=OReF
-----END PGP SIGNATURE-----