incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Doug <dmcgarr...@optonline.net>
Subject Re: Macro or its equivalent to replace double spaces with single space.
Date Tue, 17 Jul 2012 18:38:54 GMT
On 07/17/2012 01:37 PM, Johnny Rosenberg wrote:
> 2012/7/17 Doug<dmcgarrett@optonline.net>:
>> On 07/17/2012 07:06 AM, Rory O'Farrell wrote:
>>> On Tue, 17 Jul 2012 12:47:01 +0200
>>> Johnny Rosenberg<gurus.knugum@gmail.com>   wrote:
>>>
>>>> 2012/7/17 Srinivasulu Bhattaram<bhattarams@gmail.com>:
>>>>> I am new to Open Office.
>>>>> InWORD 2003 (and also in WORD 2007),
>>>>> I have craeted macros to remove double spaces with single spaces and
>>>>> used
>>>>> them extensively..
>>>>> How to have an equivalent of it in Open Office writer?
>>>>>
>>>>> I do not want to go through   Find    Replace.... kind of thing.
>>>>> seena
>>>> What about letting a macro do the search and replace for you?
>>>>
>>>> I just wrote this one, with inspiration from ”Useful Macro Information
>>>> For OpenOffice.org By Andrew Pitonyak”, which is a PDF that you can
>>>> download somewhere:
>>>>
>>>> REM  *****  BASIC  *****
>>>>
>>>> Sub RemoveRedundantSpaces
>>>>          Dim oReplace as object
>>>>          oReplace = ThisComponent.createReplaceDescriptor()
>>>>
>>>>          With oReplace
>>>>                  .SearchString = "  "
>>>>                  .ReplaceString = " "
>>>>          End With
>>>>
>>>>          While ThisComponent.ReplaceAll(oReplace)>0
>>>>          Wend
>>>> End Sub
>>>>
>>>>
>>>> This macro also takes care of tripple spaces and… well, it just
>>>> removes all spaces until there are only single spaces left. And it is
>>>> fast. Really fast.
>>>> I tested it myself, and it worked in all my test cases. Well, I didn't
>>>> test it THAT thoroughly, but still…
>>>>
>>>> Much better than using the crappy macro recorder anyway. And shorter…
>>>>
>>>> If you write the documents yourself, there is a simple way to prevent
>>>> double spaces in the first place, something like:
>>>> Tools → Options for auto correction… → Click the Options tab → ☒
>>>> Ignore double spaces
>>>>
>>>> You can still make double spaces if you really want to, but it's less
>>>> likely to happen accidently.
>>>>
>>>>
>>>> Kind regards
>>>>
>>>> Johnny Rosenberg
>>>> ジョニー・ローゼンバーグ
>>>>
>>> Or why not use the Language Tool extension, which will flag double spaces
>>> as you type with a blue wiggly underline?
>>>
>> That wouldn't help with text that is already written, that you're editing.
>> --doug
> That's why I wrote ”If you write the documents yourself”. Maybe my
> English failed there, I don't know, it's not my native language,
> sorry.
>
>
> Kind regards
>
> Johnny Rosenberg
> ジョニー・ローゼンバーグ
>
I apologize.  I didn't notice that line.  You are absolutely right.  --doug

---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org


Mime
View raw message