[users] OOo equivalent of Block Protect
Hi all, Way back in the old days, WordPerfect had a feature called block protect. You highlighted a number of lines and then applied block protect and the protected text could not be separated by a page break. The whole block would be moved to the following page rather than breaking up the block. Does Openoffice have a way of doing the same thing? Cheers, Jonathan -- Registerd Linux user #445917 at http://counter.li.org/ Please do not send me copies of list mail. I read the lists. Thanks! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] No RTL/LTR buttons in toolbar
2008/7/24 Brian Barker [EMAIL PROTECTED]: I fancy you will know more about text direction than I do, but I find that these buttons appear (and resolutely so) when you have Tools | Options... | Language Settings | Languages | Enhanced language support | Enabled for complex text layout (CTL) ticked - and they refuse to appear otherwise. Thank you, I will try that next time I sit at that library. These computers are running Windows XP Professional in the English language, but they are Hebrew enabled (I can type and view Hebrew documents just fine). Doesn't that just mean that your keyboard drivers are correctly set up - but not necessarily OpenOffice? Yes, and that's exactly the point that I wanted to make! To show that the problem is not elsewhere. In the meantime, how do I change a paragraph from LTR to RTL? I thought that it would be in the Format - Paragraph dialog, but there is no relevant option in any of the tabs there. As you suggest, the option is at Format | Paragraph... | Alignment | Properties | Text direction. But again, the Properties element of the Alignment panel appears only when complex text layout has been enabled. Excellent, thanks. I suppose it is worth mentioning that configuration settings such as this are stored (under Windows) in the user's profile, so each user will presumably need to tick the relevant box when they first need the facility. And, if you have local rather than roaming profiles, again on each system! I see. These particular machines have only a default profile for every user, not one for each student. We don't log into them, we just reset them (or not) each time we arrive at one / leave one. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il א-ב-ג-ד-ה-ו-ז-ח-ט-י-ך-כ-ל-ם-מ-ן-נ-ס-ע-ף-פ-ץ-צ-ק-ר-ש-ת A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing?
Re: [users] OOo equivalent of Block Protect
Hi, Jonathan Kaye wrote: Hi all, Way back in the old days, WordPerfect had a feature called block protect. You highlighted a number of lines and then applied block protect and the protected text could not be separated by a page break. The whole block would be moved to the following page rather than breaking up the block. Does Openoffice have a way of doing the same thing? Cheers, Jonathan Writer has two options to control the text flow on a paragraph level. Select the text that should be block protected, right-click in the selected text, choose Paragraph. Click the Text Flow tab. Check Do not split paragraph and/or Keep with next paragraph. Uwe -- [EMAIL PROTECTED] - Technical Writer StarOffice - Sun Microsystems, Inc. - Hamburg, Germany http://wiki.services.openoffice.org/wiki/Documentation http://user.services.openoffice.org/en/forum http://blogs.sun.com/oootnt - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OOo equivalent of Block Protect
On 25 Jul 2008 at 8:38, Jonathan Kaye wrote: Hi all, Way back in the old days, WordPerfect had a feature called block protect. You highlighted a number of lines and then applied block protect and the protected text could not be separated by a page break. The whole block would be moved to the following page rather than breaking up the block. Does Openoffice have a way of doing the same thing? Do not split paragraph - is that what you're after? Format | Paragraph | Text Flow if so. -- Permission for this mail to be processed by any third party in connection with marketing or advertising purposes is hereby explicitly denied. http://www.scottsonline.org.uk lists incoming sites blocked because of spam [EMAIL PROTECTED]Mike Scott, Harlow, Essex, England - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OOo equivalent of Block Protect
At 08:38 25/07/2008 +0200, Jonathan Kaye wrote: Way back in the old days, WordPerfect had a feature called block protect. You highlighted a number of lines and then applied block protect and the protected text could not be separated by a page break. The whole block would be moved to the following page rather than breaking up the block. Does Openoffice have a way of doing the same thing? There are a number of similar facilities in OpenOffice Writer. They are paragraph and paragraph style properties, so you will find them at Format | Paragraph... | Text Flow | Options (or right-click | Paragraph... | Text Flow | Options) and at right-click | Edit Paragraph Style... | Text Flow | Options. o Do not split paragraph means what it says: the entire paragraph is kept together and will not be split by a page or column break. o Keep with next paragraph puts the current paragraph into what you are calling a block with the following paragraph - keeping them together. o Orphan control and Widow control enable you to set the minimum numbers of lines of a paragraph which can be separated from the rest of the paragraph, either at the end of the beginning of a page or column. I trust this helps. Brian Barker - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] conditional sum
At 13:18 20/07/2008 +0200, Guy Voets wrote:
I have a problem with 'conditional sum' (as it was called in Excel).
I believe it's SUM.IF in OOo. I'm spoiled by the way Excel led me
through the motions, and don't quite succeed in doing the same in OOo.
The idea is that when in the sheet 'journaal' two conditions are met
in a range of cells in columns C and D, the amounts in the
corresponding cells in column H will be summed in the result cell in
another (second) sheet This is how OOo translated the formula made
in the Excel sheet
=SOM(ALS($journaal.$C$2:$C$179=nau;ALS($journaal.$D$2:$D$179=zek;$journaal.$H$2:$H$179;0);0))
(SOM.ALS is dutch for SUM.IF)
I don't find an easy way to produce such formula in OOo. One
condition (C=nau) is OK with InsertFunction, but do I have to add
the second condition (D=zek) manually?
This is what I get:
=SOM.ALS(journaal.C2:C179;sec;journaal.G2:G173)
First, a few observations:
o I'm puzzled by your reference to SUM.IF - with a dot. The
function is called SUMIF in the English version, not SUM.IF. I
don't know about the Dutch implementation, of course.
o You say your problem is with SUMIF, but your example (translated
from Excel) does not use this function. Instead, it uses a nested
arrangements of the different - and separate - functions SUM and IF.
o This example doesn't work as given. It is an array function, so
it needs to be entered with Ctrl+Shift+Enter instead of simple Enter,
whereupon it automatically grows braces: {=SUM( ... 0))}. Then it
works. But you probably knew that.
I don't think you can easily use the SUMIF function to achieve what
you need, in fact, since it is designed to examine a single array for
the condition, and you have two arrays and two conditions. The
reason you cannot add a second condition is that SUMIF does not need
or allow one. But you can create a formula like your example (using
SUM and IF):
o In the Function Wizard, select SUM and Next.
o Next to number 1, press the fx button, and then select IF and Next.
o For Test, drag and type to create: $journaal.$C$2:$C$179=nau .
o Before creating the Then_value, enter 0 for Otherwise_value. (You
can go back later if you forget this.)
o Next to Then_value, press the fx button, and then select IF and Next.
o For Test, drag and type to create: $journaal.$D$2:$D$179=zek .
o For Then_value, drag to create: $journaal.$H$2:$H$179 .
o For Otherwise_value, enter: 0 .
o Crucially, tick the Array box at the bottom left.
o Press OK. Bingo!
(Perhaps you could do this, too.)
I think the only way to use SUMIF directly is if you first somehow
condense the two conditions into one. You could do this easily by
concatenating the test arrays in a new column, perhaps on your second
sheet. Put
=$journaal.$C$2$journaal.$D$2
into A2, say, and then fill that down column A. Where both your
conditions are satisfied, this new cell will contain nauzek. (You
can hide this column if you prefer.) Then you can replace your formula with
=SUMIF($A$2:$A$179;nauzek;$journaal.$H$2:$H$179) .
Even that doesn't quite work, since the nauzek could have been
created by concatenating vales of na and uzek instead of nau
and zek. To avoid this problem, interpolate an extra character,
e.g. a space, between the two values. Thus A2 becomes
=$journaal.$C$2 $journaal.$D$2
and the test formula
=SUMIF($A$2:$A$179;nau zek;$journaal.$H$2:$H$179) .
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: OOo equivalent of Block Protect
Jonathan Kaye wrote: Hi all, Way back in the old days, WordPerfect had a feature called block protect. You highlighted a number of lines and then applied block protect and the protected text could not be separated by a page break. The whole block would be moved to the following page rather than breaking up the block. Does Openoffice have a way of doing the same thing? Cheers, Jonathan Thanks to Uwe, Mike and Brian. Just what the doctor ordered proving once again the power of the OOo community. Problem solved and back to work. Cheers, Jonathan -- Registerd Linux user #445917 at http://counter.li.org/ Please do not send me copies of list mail. I read the lists. Thanks! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Trouble with OOo Beta 2
Yes, I meant version 3.0 beta 2... OK? I know it's not a show stopper, but it is a very useful feature and I thought that someone should know that it's not working. Also the spell checker doesn't seem to work either. Should I re-install? David On Thu, Jul 24, 2008 at 7:53 PM, John Boyle [EMAIL PROTECTED] wrote: Harold Fuchs wrote: On 25/07/2008 01:06, John Boyle wrote: David Bird wrote: The direct cursor doesn't seem to be working. I went into the necessary option and made sure that it was activated. I even deactivated it and then reactivated to no avail. Any suggestions? Dave To David Bird: Since there is a stable version 2.4.1 out, I cannot see why you are bothering with the version 2. beta. I bet you really mean version 3.0 which is in beta! Otherwise you are confusing the issue. :-( Do you think he might mean version 3 *Beta 2* as per the web site: quote from web site Beta 2 available The second public beta release of OpenOffice.org 3.0 is now ready for testing. Download this release from our download page. http://download.openoffice.org/3.0beta /quote from web site To Harold Fuchs: Very Possibly, but he sure did not make it clear, either! :-( - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- 'The only thing necessary for the triumph [of evil] is for good men to do nothing. - Edmund Burke
Re: [users] conditional sum
2008/7/25 Brian Barker [EMAIL PROTECTED]:
At 13:18 20/07/2008 +0200, Guy Voets wrote:
I have a problem with 'conditional sum' (as it was called in Excel). I
believe it's SUM.IF in OOo. I'm spoiled by the way Excel led me through the
motions, and don't quite succeed in doing the same in OOo.
The idea is that when in the sheet 'journaal' two conditions are met in a
range of cells in columns C and D, the amounts in the corresponding cells in
column H will be summed in the result cell in another (second) sheet This is
how OOo translated the formula made in the Excel sheet
=SOM(ALS($journaal.$C$2:$C$179=nau;ALS($journaal.$D$2:$D$179=zek;$journaal.$H$2:$H$179;0);0))
(SOM.ALS is dutch for SUM.IF)
I don't find an easy way to produce such formula in OOo. One condition
(C=nau) is OK with InsertFunction, but do I have to add the second
condition (D=zek) manually?
This is what I get:
=SOM.ALS(journaal.C2:C179;sec;journaal.G2:G173)
First, a few observations:
o I'm puzzled by your reference to SUM.IF - with a dot. The function is
called SUMIF in the English version, not SUM.IF. I don't know about the
Dutch implementation, of course.
Yes, in Dutch it's SOM.ALS, there's also AANTAL.ALS (NUMBERIF ?)
=SOM.ALS(A1:A10;0) sums negative values in the A1:A10 array
o You say your problem is with SUMIF, but your example (translated from
Excel) does not use this function. Instead, it uses a nested arrangements
of the different - and separate - functions SUM and IF.
indeed, nested SUM and IF, but I thought SUMIF could do the job (it seemed
to do it, with a single condition, as in the second formula I quoted)
o This example doesn't work as given. It is an array function, so it
needs to be entered with Ctrl+Shift+Enter instead of simple Enter, whereupon
it automatically grows braces: {=SUM( ... 0))}. Then it works. But you
probably knew that.
I don't think you can easily use the SUMIF function to achieve what you
need, in fact, since it is designed to examine a single array for the
condition, and you have two arrays and two conditions. The reason you
cannot add a second condition is that SUMIF does not need or allow one. But
you can create a formula like your example (using SUM and IF):
o In the Function Wizard, select SUM and Next.
o Next to number 1, press the fx button, and then select IF and
Next.
o For Test, drag and type to create: $journaal.$C$2:$C$179=nau .
o Before creating the Then_value, enter 0 for Otherwise_value. (You can go
back later if you forget this.)
o Next to Then_value, press the fx button, and then select IF and
Next.
o For Test, drag and type to create: $journaal.$D$2:$D$179=zek .
o For Then_value, drag to create: $journaal.$H$2:$H$179 .
o For Otherwise_value, enter: 0 .
o Crucially, tick the Array box at the bottom left.
o Press OK. Bingo!
(Perhaps you could do this, too.)
I'll try it out at home, where I have the Calc file in question.
I think the only way to use SUMIF directly is if you first somehow condense
the two conditions into one. You could do this easily by concatenating the
test arrays in a new column, perhaps on your second sheet. Put
=$journaal.$C$2$journaal.$D$2
into A2, say, and then fill that down column A. Where both your conditions
are satisfied, this new cell will contain nauzek. (You can hide this
column if you prefer.) Then you can replace your formula with
=SUMIF($A$2:$A$179;nauzek;$journaal.$H$2:$H$179) .
This might work, since there's a limited and known series of conditions
(sections of an organisation in the first array, types of income or expense
in the second - I put them into two columns because the second series occurs
in different sections)
Even that doesn't quite work, since the nauzek could have been created by
concatenating vales of na and uzek instead of nau and zek. To avoid
this problem, interpolate an extra character, e.g. a space, between the two
values. Thus A2 becomes
=$journaal.$C$2 $journaal.$D$2
and the test formula
=SUMIF($A$2:$A$179;nau zek;$journaal.$H$2:$H$179) .
I trust this helps.
I'm sure it will, as usual.
Many thanks!
Brian Barker
--
Guy
[users] Re: Trouble with OOo Beta 2
David Bird wrote: Yes, I meant version 3.0 beta 2... OK? I know it's not a show stopper, but it is a very useful feature and I thought that someone should know that it's not working. Also the spell checker doesn't seem to work either. Should I re-install? David On Thu, Jul 24, 2008 at 7:53 PM, John Boyle [EMAIL PROTECTED] wrote: Harold Fuchs wrote: On 25/07/2008 01:06, John Boyle wrote: David Bird wrote: The direct cursor doesn't seem to be working. I went into the necessary option and made sure that it was activated. I even deactivated it and then reactivated to no avail. Any suggestions? Dave Hi Dave I just had a look at my beta version (DEV300m25 Build 9330) on linux and the direct cursor works. For spelling I had to install an Australian dictionary by using the (deprecated) DicOOo.sxw which works OK Russell - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Typing - in a cell in OpenOffice
How do I type a hyphen - or a double hyphen -- in a cell without wrestling with auto-complete? Once I type it, if I click anywhere else or move the arrows, it fills in the cell numbers. Thanks, Jason - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Typing - in a cell in OpenOffice
Hit -ENTER- prior to leaving the cell. Jason Cipriani wrote: How do I type a hyphen - or a double hyphen -- in a cell without wrestling with auto-complete? Once I type it, if I click anywhere else or move the arrows, it fills in the cell numbers. Thanks, Jason - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Dennis Sledge Database Applications Programmer Darton College OIT 229 317 6537 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Replacing standard quotes with custom quotes
I have a 500 page document with standard quotes. I want to replace them with custom quotes. Doing CTRL+SHIFT+F to find them all and then manually typing a quote character is a tedious process. There must be an easier way. I tried to record a macro, but it kept the standard quote. I tried Format Auto-Format Apply, but that messed *everything* up -- though the quotes were fine! LOL! I'm sure there's a more efficient way to accomplish this. What is it? Thanks! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Replacing standard quotes with custom quotes
Have you tried: CTRL-Freplace all option? Dennis Tamblyne wrote: I have a 500 page document with standard quotes. I want to replace them with custom quotes. Doing CTRL+SHIFT+F to find them all and then manually typing a quote character is a tedious process. There must be an easier way. I tried to record a macro, but it kept the standard quote. I tried Format Auto-Format Apply, but that messed *everything* up -- though the quotes were fine! LOL! I'm sure there's a more efficient way to accomplish this. What is it? Thanks! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Replacing standard quotes with custom quotes
On Fri, 25 Jul 2008 15:03:54 -0400, Dennis Sledge [EMAIL PROTECTED] wrote: Tamblyne wrote: I have a 500 page document with standard quotes. I want to replace them with custom quotes. Doing CTRL+SHIFT+F to find them all and then manually typing a quote character is a tedious process. There must be an easier way. I tried to record a macro, but it kept the standard quote. I tried Format Auto-Format Apply, but that messed *everything* up -- though the quotes were fine! LOL! I'm sure there's a more efficient way to accomplish this. What is it? Thanks! Have you tried: CTRL-Freplace all option? Dennis Hi, Dennis -- Yes, that was my first line of attack. But I still ended up with the standard quotes. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Typing - in a cell in OpenOffice
Jason Cipriani wrote: How do I type a hyphen - or a double hyphen -- in a cell without wrestling with auto-complete? Once I type it, if I click anywhere else or move the arrows, it fills in the cell numbers. Thanks, Jason Jason -- can you be more specific about what you're trying to do? And what specifically you're typing, with the hyphen? I can't replicate a problem in this regard, so I assume I must be doing something differently than you are. What I tried is typing - test (without the quotes) in a cell. Whether I pressed Enter, or used an arrow key, or clicked in another cell, the text went in exactly as I typed it. Also, it's not clear to me why, if you're in the middle of typing something into a cell, you'd want to click in another cell. Please get back with more specifics. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Replacing standard quotes with custom quotes
On Jul 25, 2008, at 3:23 PM, Tamblyne wrote: On Fri, 25 Jul 2008 15:03:54 -0400, Dennis Sledge [EMAIL PROTECTED] wrote: Tamblyne wrote: I have a 500 page document with standard quotes. I want to replace them with custom quotes. Doing CTRL+SHIFT+F to find them all and then manually typing a quote character is a tedious process. There must be an easier way. I tried to record a macro, but it kept the standard quote. I tried Format Auto-Format Apply, but that messed *everything* up -- though the quotes were fine! LOL! I'm sure there's a more efficient way to accomplish this. What is it? Thanks! Have you tried: CTRL-Freplace all option? Dennis Hi, Dennis -- Yes, that was my first line of attack. But I still ended up with the standard quotes. As far as I know, there is no quick way to do this on Version 2. On Version 3, now in beta, you can do it rather more efficiently by searching for something like ([^a-zA-Z]) with Regular Expression turned on, and then Replacing it with $1“ doing it one at a time, and then searching for ([^a-zA-Z]) and Replacing it with ”$1 After that, search for the remaining characters and fix them manually. Then, of course, you would have to search for apostrophes and left and right single quotes in a similar process. Version 3's Regular Expression support is better than Version 2's, though it is still rather backward compared to the support that has been around for yonks. -- John W Kennedy Never try to take over the international economy based on a radical feminist agenda if you're not sure your leader isn't a transvestite. -- David Misch: She-Spies, While You Were Out - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Replacing standard quotes with custom quotes
John W Kennedy wrote: On Jul 25, 2008, at 3:23 PM, Tamblyne wrote: On Fri, 25 Jul 2008 15:03:54 -0400, Dennis Sledge [EMAIL PROTECTED] wrote: Tamblyne wrote: I have a 500 page document with standard quotes. I want to replace them with custom quotes. Doing CTRL+SHIFT+F to find them all and then manually typing a quote character is a tedious process. There must be an easier way. I tried to record a macro, but it kept the standard quote. I tried Format Auto-Format Apply, but that messed *everything* up -- though the quotes were fine! LOL! I'm sure there's a more efficient way to accomplish this. What is it? Thanks! Have you tried: CTRL-Freplace all option? Dennis Hi, Dennis -- Yes, that was my first line of attack. But I still ended up with the standard quotes. As far as I know, there is no quick way to do this on Version 2. On Version 3, now in beta, you can do it rather more efficiently by searching for something like ([^a-zA-Z]) with Regular Expression turned on, and then Replacing it with $1“ doing it one at a time, and then searching for ([^a-zA-Z]) and Replacing it with ”$1 After that, search for the remaining characters and fix them manually. Then, of course, you would have to search for apostrophes and left and right single quotes in a similar process. Version 3's Regular Expression support is better than Version 2's, though it is still rather backward compared to the support that has been around for yonks. Another possibility: check your settings for replacing quotation marks: 1. Choose *Tools - AutoCorrect*. 2. Click the *Custom Quotes* tab 3. Check the *Replace* check box(es). 4. Make sure you have it set the way you want. Joe Conner, Poulsbo, WA USA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Replacing standard quotes with custom quotes
On Friday, July 25, 2008 1:46 pm Tamblyne wrote: I tried Format Auto-Format Apply, but that messed *everything* up -- though the quotes were fine! LOL! Did you go into ToolsAutoCorrect and uncheck everything except Replace standard quotes with custom quotes before doing the FormatAuto-FormatApply? Arn - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Replacing standard quotes with custom quotes
On Friday, July 25, 2008 4:14 pm AAW wrote: On Friday, July 25, 2008 1:46 pm Tamblyne wrote: I tried Format Auto-Format Apply, but that messed *everything* up -- though the quotes were fine! LOL! Did you go into ToolsAutoCorrect and uncheck everything except Replace standard quotes with custom quotes before doing the FormatAuto-FormatApply? Dang! I meant ToolsAutoCorrectOptions. Arn - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Replacing standard quotes with custom quotes
On Jul 25, 2008, at 5:14 PM, AAW wrote: On Friday, July 25, 2008 1:46 pm Tamblyne wrote: I tried Format Auto-Format Apply, but that messed *everything* up -- though the quotes were fine! LOL! Did you go into ToolsAutoCorrect and uncheck everything except Replace standard quotes with custom quotes before doing the FormatAuto-FormatApply? That will change new quotation marks on the fly; it won't change them in an existing document. -- John W Kennedy The first effect of not believing in God is to believe in anything -- Emile Cammaerts, The Laughing Prophet - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Replacing standard quotes with custom quotes
On Fri, 25 Jul 2008 13:33:17 -0700, JOE Conner [EMAIL PROTECTED] wrote: John W Kennedy wrote: On Jul 25, 2008, at 3:23 PM, Tamblyne wrote: On Fri, 25 Jul 2008 15:03:54 -0400, Dennis Sledge [EMAIL PROTECTED] wrote: Tamblyne wrote: I have a 500 page document with standard quotes. I want to replace them with custom quotes. Doing CTRL+SHIFT+F to find them all and then manually typing a quote character is a tedious process. There must be an easier way. I tried to record a macro, but it kept the standard quote. I tried Format Auto-Format Apply, but that messed *everything* up -- though the quotes were fine! LOL! I'm sure there's a more efficient way to accomplish this. What is it? Thanks! Have you tried: CTRL-Freplace all option? Dennis Hi, Dennis -- Yes, that was my first line of attack. But I still ended up with the standard quotes. As far as I know, there is no quick way to do this on Version 2. On Version 3, now in beta, you can do it rather more efficiently by searching for something like ([^a-zA-Z]) with Regular Expression turned on, and then Replacing it with $1 doing it one at a time, and then searching for ([^a-zA-Z]) and Replacing it with $1 After that, search for the remaining characters and fix them manually. Then, of course, you would have to search for apostrophes and left and right single quotes in a similar process. Version 3's Regular Expression support is better than Version 2's, though it is still rather backward compared to the support that has been around for yonks. Another possibility: check your settings for replacing quotation marks: 1. Choose *Tools - AutoCorrect*. 2. Click the *Custom Quotes* tab 3. Check the *Replace* check box(es). 4. Make sure you have it set the way you want. Joe Conner, Poulsbo, WA USA Hi, Joe -- I do have that set. But the quotes are all standard quotes -- except for the ones I have changed. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Replacing standard quotes with custom quotes
On Fri, 25 Jul 2008 16:19:27 -0500, AAW [EMAIL PROTECTED] wrote: On Friday, July 25, 2008 4:14 pm AAW wrote: On Friday, July 25, 2008 1:46 pm Tamblyne wrote: I tried Format Auto-Format Apply, but that messed *everything* up -- though the quotes were fine! LOL! Did you go into ToolsAutoCorrect and uncheck everything except Replace standard quotes with custom quotes before doing the FormatAuto-FormatApply? Dang! I meant ToolsAutoCorrectOptions. Arn Hi, Arn -- I just tried that and it still trashed the rest of my document, but it did change the quotes! LOL! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Replacing standard quotes with custom quotes
On Fri, 25 Jul 2008 17:32:24 -0400, John W Kennedy [EMAIL PROTECTED] wrote: On Jul 25, 2008, at 5:14 PM, AAW wrote: On Friday, July 25, 2008 1:46 pm Tamblyne wrote: I tried Format Auto-Format Apply, but that messed *everything* up -- though the quotes were fine! LOL! Did you go into ToolsAutoCorrect and uncheck everything except Replace standard quotes with custom quotes before doing the FormatAuto-FormatApply? That will change new quotation marks on the fly; it won't change them in an existing document. John -- Actually (getting smarter as the day progresses) I did try this on a small snippet -- i.e., Format Auto-Format Apply and it *did* change the quotes. Thanks, Arn. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] search for text strings in multiple documents
I am trying to find an article I have lost among a lot of other news articles I kept in ODF format. Is there any way on Windows to do a search of the contents of an ODF file. I tried Windows Vista Search and that ignored most of the files. Thanks Rob - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Keyboard shortcut for selecting values from dropdowns in Calc?
Hi, we have some spreadsheets with dropdowns in cells, where we haven't yet found out how to open the dropdown via keyboard. We always have to click on it in order to select some value. In MS Excel, this was Alt-Arrowdown. We really searched the docs for quite a while... Thanks for any hints, Jörg - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Typing - in a cell in OpenOffice
Jason Cipriani wrote: How do I type a hyphen - or a double hyphen -- in a cell without wrestling with auto-complete? Once I type it, if I click anywhere else or move the arrows, it fills in the cell numbers. On Fri, Jul 25, 2008 at 11:44 AM, Dennis Sledge [EMAIL PROTECTED] wrote: Hit -ENTER- prior to leaving the cell. Thanks. Is there some way to configure it to advance to the right instead of down when I hit enter? Jason - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Typing - in a cell in OpenOffice
On Fri, Jul 25, 2008 at 3:54 PM, Richard Detwiler [EMAIL PROTECTED] wrote: Jason Cipriani wrote: How do I type a hyphen - or a double hyphen -- in a cell without wrestling with auto-complete? Once I type it, if I click anywhere else or move the arrows, it fills in the cell numbers. Jason -- can you be more specific about what you're trying to do? And what specifically you're typing, with the hyphen? I can't replicate a problem in this regard, so I assume I must be doing something differently than you are. What I tried is typing - test (without the quotes) in a cell. Your test is not what I was trying to do. I am only typing a hyphen, nothing else. The solution is to press enter before moving to another cell (although enter moves the cursor down one cell). The reason I'm clicking on other cells is because I'm quickly entering data into various places in a spreadsheet, and sometimes I want to move to another cell, so I click on it. Jason - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
