At 07:42 23/04/2008 +0100, David Lewin wrote:
Having now used OPenOffice for a while, I am a little more at home with it.
I am missing 2 Microsoft Office features:
1. When selecting a column on a spread sheet, and using crtl-F to
find, Windows searched the column only, OpenOffice seems to search
the whole sheet. Can I "force it" to search a highlighted column only?
Yes. In the Find & Replace dialogue, press More Options and then
tick "Current selection only".
2. When using the Find/Replace in Microsoft office, I was able to
use ^p to replace a comma by a comma-followed-by-a-new
paragraph [ this is VERY useful in sorting email lists ]. Does the
same exist in OpenOffice?
Yes.
o In the Find & Replace dialogue, search for comma and replace with
,\n - that's comma-backslash-n. (Think of \n as "new line".)
o Press More Options, and tick "Regular expressions".
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
