Alternative dialog Find & Replace for Writer

4.275
Average: 4.3 (40 votes)
altsearch_main_en_thumb5.png
  • Fast selection preset regular and extended expressions
  • Searched or replaced text can contain one or more paragraphs
  • Search out block of paragraphs delimited by two text marks
  • Multiple search and replacement in one step
  • Searching: Notes, Text fields, Cross-references and Reference marks to their content, name or mark and their inserting
  • Searching and inserting Footnote and Endnote (from version OOo 2.3 only). It is possible to select at once texts of all footnotes or endnotes and to assign them any style
  • Searching object of Tables, Pictures and Text frames according to their name; it is possible to substitute them by any text, etc.
  • Changing into found or replaced text: paragraph style, character style, list style and Hyperlink's URL and set properties
  • Inserting and replacement: clipboard contents, insert replacement counter and page number
  • Hexadecimal also decimal submission character for search and replaced
  • Searching out manual page and column break and their set up or deactivation
  • Searching similarly or the same manually formatted part of text, according to cursor point
  • Count found occurrences
  • Redirecting result of replacing expression to the other text file
  • Batch mode: saving and loading of search and replacement parameters; it is possible to save several searching and replacing subsequently to the single sequence and that whole quickly execute after
  • Self dialogue for quick assignment of key shortcut to batches
  • Preserve capitalization - If found text begins with a capital letter, also the text replacement will begin with a capital letter
  • Searching for paragraph, character and list style; possibility to choose a style from the menu
  • Built-in help (http://www.volny.cz/macrojtb/HelpAltSearch_en.html)
  • Language: English, Czech, Russian, Spanish, German, French, Dutch, Italian
Download extension
Operating System: System Independent
Version: 1.3.2
Date: 2010-Jun-17
Size: 473.37 KB

License: Opensource
Further product information: Screenshots
Downloads: Today: 1 | Week: 107 | Month: 626 | Year: 117,051

Comments

Txt string broken by space carrige return

I have a text file with carriage returns. In all cases, the carriage returns are proceeded by either a letter or a space. I need to delete all cases of space followed by carriage return. To do this, I'm using s\$ in the find dialog box and leaving the replace box blank. While the find tool accurately locates all cases of s\$, when I click replace, only the space is deleted. Interestingly, if I search using just $, and click replace, the carriage return is deleted. Any suggestions?

I love this extension, but

I love this extension, but sázkové kanceláře since upgrading my system it won't install for me. I sázkové tipy recently installed Ubuntu Lucid 10.04LTS, which comes with OOo 3.2 (OOO320m13, Build:9483, to be precise). The extension shows as installed under the Extension Manager, stavkove kancelarie but no toolbar button or menu item is created. Is there anywhere I can file a bug report or get sázky some support?

wonderfull extension

Great extension ! Works well on ubuntu with open office 3.2.0
Thank you !

regular / extended / properties buttons not working in ubuntu

Hi, I hope this is still being maintained as it's a great extension.
I've got a dual boot set-up and it works perfectly under Wndows 7 with libreoffic 3.4.1

Running Ubuntu 11.04 & libreoffice 3.4.1 it mostly works - except for regular / extended / properites buttons.

Is there a fix for this?

I would also like to report

I would also like to report having problems with this extension - it doesn't react at all. Can this be corrected? I am using the latest OpenOffice. Thank you in advance.

Alt Find & Replace stopped working

Short Description: Alt Search and Replace stopped working after an upgrade. Instead of opening a Search and Replace dialog, it opens a new OOo window for My Macros & Dialogs and displays a 'BASIC runtime error' error message

Long Description: I upgraded Alt Search and Replace about a month ago. Previous version worked to my great satisfaction and delight. Sadly, this most wonderful extension stopped working after updating. When I click on the green binoculars, the application pauses for a moment, clangs an error alarm and opens a
> window: [MyMacros & Dialogs]:AltSearch
> tab: fromTools
> Error Dialog: "BASIC runtime error. An exception occourred. Type: com.sun.star.container.No.SuchElementException Message: {OK button}

Environment:
Vista HP sp2
OOo 3.1.1

Attempted work-arounds:
1. Reinstalled the extension. No joy.
2. Uninstalled the extension, reinstalled the extension, shut down OOo, restarted OOo. No joy
3. Uninstalled the extension, reinstalled the extension, shut down OOo, shut down PC, restarted PC, restarted OOo. No joy.

Comment: From scrolling through this thread, this "No.SuchElementException" problem seems to occour with some frequency. For those of us who are not BASIC programmers, is there a step by step work around for this problem? I really miss having this extension.

Thanks for any help anyone can suggest

Error:

While using, I get an error:

An exception occurred.
Type: com.sun.star.resource.MissingResourceException
Message: StringResourceImpl: No entry for ResourceID: .

There is a similar bug open: http://openoffice.org/bugzilla/show_bug.cgi?id=116928

http://api.openoffice.org/docs/common/ref/com/sun/star/resource/XStringR...

AltSearch icon missing

Hi,
This looks like it would be a good extension, but I can't get it to load. I went through the installation process, and got no complaints or errors. However, the Binocular icon doesn't show (yes, I did shut down OOo and then restarted) in the Tool bar.

I am running OOo 3.1.1 on a Ubuntu 9.10 system if that makes a difference. Any suggestions?

I love AltSearch, but new installs in OOo & LO fail

I've found AltSearch a huge help working with old converted files; the LibreOffice people are nuts to build in the extensions they did and not this one!

Unfortunately, installing your latest version with current official-RPM versions of OOo (and, after completely removing OOo, LibreO) today threw an error similar to someone else's; it was auto-disabled & error reappears if I enable it. Rebooting didn't help.
The error (with the .office and variable after Backend/ changing based on the install):
(com.sun.star.uno.RuntimeException) { { Message = "bad root element in file:///home/xyzzy/.libreoffice/3/user/uno_packages/cache/registry/com.sun.star.comp.deployment.configuration.PackageRegistryBackend/1o6kOG_/addon.xcu", Context = (com.sun.star.uno.XInterface) @0 } }

problem with "entire word" option search

This is a great and useful tool! I use the Italian version on Mac.
However, I detected a problem in the "entire word" option search, that is not working properly and should be arranged because so crucial!
Thanks,
m.

it is great tool! Author!

it is great tool!
Author! thank's a lot for this excellent addon!
may be it will be useful for anybody(and not only me) to get "element of table of contents"(or how it named in english) in "replace" list?
last target is to get table of contents based on text with specific symbol style.

This is desperately needed in Calc!

This tool is amazingly usefull. How hard would it be to make this available for Calc as well as writer? I work with huge spread sheets on a regular basis and often wish I could use regular expressions in find & replace to alter large groups of cells based on patterns. Right now I usually just save the file as a tsv and open it in notepad++ to use regular expressions, but that doesn't always work out as predictably as I would like, and it would be oh so convenient to be able to do the searches right in Calc.

This is desperately needed in Calc!

And what you miss in the native dialog search / replace in Calc?

Great tool!

This is a great tool!

I had been having a hard time replacing fonts or changing font size of pieces of text intersperse within a huge document. It was a extremely tedious.

This tool saved me lots of time.

The only problem I find is that it is not able to search for Asian fonts.

For example, I can search for CharFontName=Times Roman and replace it with an Chinese Font CharFontNameAsian=KaiTi.

But I can't search for CharFontNameAsian=KaiTi.

It seems strange that I can replace the CharFontNameAsian attribute of the text but not able to search based on the CharFontNameAsian attribute. The search only works on the CharFontName attribute.

This would be a refinement I would look forward too!

God bless the author!

God bless the author!

No longer works revised :)

I read back on previous comments and tried rebooting the whole system, which worked. Sorry about that. Relieved as well :).

No longer works

This great extension has always been my favorite. I upgraded to the latest version of OOo, 3.2.1, and now nothing happens. When I click on the icon it simply does nothing. I am running Vista.

Very good!

Thank you so much, this extension is great!
Saved me many times ... the search and replace of Writer has several limitations.
Coming from MSWORD helped me a lot to get used to using Writer.
If you're looking for inspiration ...
http://gregmaxey.mvps.org/VBA_Find_And_Replace.htm
http://www.jambient.com/indexassistant/
This extension will recommend it to everyone! A must try!
Thank you again.

Cannot Install

I cannot install version 1.3.1 into OOo_Dev300m80
I get the msg
(com.sun.star.uno.RuntimeException){{Message = "bad root element in file:
///Users/~/Library/Application Support/OOo-dev/3/user/uno_packages/cache/
uno_packages/7irZ2Z_/AltSearch.oxt/addon.mod", Context = (com.sun.star.uno.Xinterface)@0}}
-------------------
Al Maloney
Using OOo_Dev_DEV300 on Mac OS X 10.6.3
"Velox Versutus Vigilans"

I would really like to use

I would really like to use this extension again.
Is it incompatible with my version of OOo?
Is there something I can do to resolve the problem?
(I have the same problem with TestFonts)
-------------------
Al Maloney
Using OOo_Dev_DEV300 on Mac OS X 10.6.4
"Velox Versutus Vigilans"

Try new release v1.3.2

AltSearch 1.3.2

Thank you Tomas!
That works now.
Can you do the same for TestFonts?
-------------------
Al Maloney
Using OOo_Dev_DEV300 on Mac OS X 10.6.4
"Velox Versutus Vigilans"

Installation problem

Hi - I love this extension, but since upgrading my system it won't install for me. I recently installed Ubuntu Lucid 10.04LTS, which comes with OOo 3.2 (OOO320m13, Build:9483, to be precise). The extension shows as installed under the Extension Manager, but no toolbar button or menu item is created. Is there anywhere I can file a bug report or get some support?

Installation problem

1. Make sure you have installed JRE - ooo Java Runtime Enviroment.
2. Sometimes it is necessary to restart OOo, including quickstarter (if is used). or whole operating system.

still no joy

Hi - thanks for the response. I've switched the the sun java implementation from the Ubuntu partner repository, reconfigured everything, and done a full system restart, but I still can't find anything. There's no toolbar button, no menu entry, and no error of any kind. The Extension Manager still reports that the AltSearch extension is installed though. I've tried removing it and re-installing, also to no avail.

I don't really know how to debug it from here. Does anyone have this extension working on OOo 3.2? On Lucid?

[Edit: I can confirm too that I have the openoffice.org-java-common package installed]

still no joy

On win XP and OOo 3.2 it is working OK.

Try direct run: Tools - Macros - Organize macros - OOo basic: My macros - Altsearch and direct run _Altsearch.

(try JRE instal by terminal: sudo apt-get install default-jre)

problem solved

on the basis of my last comment, it (finally) occurred to me that I might have a corrupt download, so I downloaded again, and sure enough the md5sums were different. Installation of the new file has proceeded as expected. (I'm getting a OOBasic runtime crash if I try to resize the window, but I don't think that issues is specific to this extension :)).

Sorry to have wasted your time, and thank again.

no macros installed!

Hi tombil, thanks for your continued interest in this.

Well, it seems like it's an installation problem of some kind - Altsearch doesn't exist under "My Macros". Can I extract the macro manually from the package and add it myself? Is there a tool I can use to open the package? (File Roller reports "End-of-central-directory signature not found.", and `jar -x` just hangs.... know very little about java programming and nothing about OOo extensions, and don't have time to bone up right now!)

Thanks again!

NoSuchElementException as in a comment below...

... and same error message:

"BASIC runtime error.
An exception occurred.
Type: com.sun.star.container.NoSuchElementException
Message: ."

but my highlighted line in the code reads:

oLibContainer.LoadLibrary(LibName)

(Just in case, I've tried the solution the author proposed in reply to the other comment, a previous version of the extension, but no luck)

Any idea what might be the problem, anybody? This extension is really useful, I'd hate to do without it!

Running OOo 3.1.1

Thanks

Think I found one possible solution

It was installed & working just fine on my system (SimplyMEPIS Linux 8.5, OOo 3.1.1) until I uninstalled the spreadsheet/database programs... It promptly started giving me the same error screen you described, and kept doing it until I decided to try reinstalling the "missing" programs -- at that point it started working again.

some issues with large paragraphs

There is an issue with searching within large paragraphs:
http://www.openoffice.org/issues/show_bug.cgi?id=108273

I wonder if you can make this excellent extension to work where the native one fails.

Does not work with OOo 3.0.1

I have the same problem as Mike. Clicking on the green binoculars or accessing the menu does nothing, and does not produce an error message.

I have OOo 3.0.1 on Ubuntu 9.04, 64 bit version.

You tried to restart?

Sometimes it is necessary to restart OOo, including quickstarter (if is used).
In the worst case the entire operating system too.

AltSearch Broken Under 3.1.1

I just installed OpenOffice.org 3.1.1. I tried to install Mr. Bilek's AltSearch extension (which I've used extensively under OOo 2.4). The green binocular icon appears as expected, but clicking on it produces no response (including no error message). Any suggestions?

Thanks.

Mike

Changing Font Style

This extension has been great, and I appreciate all of the documentation that goes with it - except I was unable to find documentation that explained how to simply replace some text in a regular font with a bolded font. Apparently this involves understanding internal OpenOffice character style attributes. (Does someone know of an easier way that I missed?) Hopefully this will help someone out in a similar situation...

I had text of the form "Region 1" or "Region 11" where I wanted to make every occurrence bold. Here's what I did:

Find (using Regular Expressions): ^Region\s([0-9][0-9]?)
Replace: \C{Quotation}\A{CharWeight=150%}\A{CharPosture=0}

The first part of the replace (\C{Quotation}) was added by choosing "Character Style" from the Replace drop-down list. The second parts were more difficult to determine. The general format of (\A{SOMETHING}) was listed in the replace drop-down as well, but neither CharWeight nor CharPosture were actual options in the PickProperties drop-down. I found that these were the actual options I needed to use by trial and error and eventually found what the available attributes were for each style by going to http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Text/For.... According to the wiki, while things like BOLD and NONE (for CharWeight and CharPosture respectively) are supposed to be valid options for these styles, neither would work and I had to use a numeric value.

The CharPosture part was necessary because whenever I used CharWeight to make the text bold, it automatically italicized the text as well. Including CharPosture=0 was necessary to make it un-italicized again. I'm not sure if this is a bug in OpenOffice or the extension, or just by-design.

Overall, I'm pleased at the power of this extension and it still saved me a lot of time and manual formatting... but there is still room for improvement in the documentation and in making it easier to use. All in all, thanks for making it!

(Using Alternative Find & Replace for Writer version 1.2.1 on OpenOffice.org 3.0.0)

Try character styles

To change the character or paragraph formatting, I use character / paragraph styles. In your case, I'd suggest to create a character style "bold" (or similar), then use the following syntax:

Find: region \d{1,}
Replace: &\C{bold}
Regular Expression: on

If you want to add to every occurance of "region" a ascending number, you may use the following syntax:

Find: region
Replace: & \i \C{bold}
Regular Expression: on
Replace all

"Replace all" is essential in this case, otherwise you will always get "region 0".

Select all footnotes

You say (6th bullet) "It is possible to select at once texts of all footnotes or endnotes and to assign them any style".
I am using oOo 3.0.0 in XPproSP2 and am not a beginner - but need help now. I can get as far as [::BigBlock::] but cannot define "start" and "end" in a functional manner. Note 1 starts with "[superscript] 1Joel" and note 52 ends with "39-47" - both are unique instances. But "1Joel[::BigBlock::]39-47" does not "select all" - nor does "Joel[::BigBlock::]39-47" (ignore superscript).
If I can get this to work - with your help - how do I change the para style?
Note: this is done (hate to say it) in M$Word by: highlight any footnote, CTRL+A, format para - 3 clicks only.
Tnx - Paul

Source code?

Hi! I am interested to have a look at the course code but I was unable to find a link to it. Can someone please give me a hint? Thanks.

EDIT: Stupid me! It is about unpacking the oxt file. I am sorry!

Look to Help (button [?]) on

Look to Help (button [?]) on "footnote":
Using [::Footnote::]\\ with the button [ Find all ], the text of all FNs will be selected (handy for assigning a paragraph style to all FNs at once)

Paragraph styles selected block of text you can set using "Styles and formatting"

Tomas

NoSuchElementException for "Tools" library

AltSearch looks great, but when I try to run it in Writer I get the following error:

"BASIC runtime error.
An exception occurred.
Type: com.sun.star.container.NoSuchElementException
Message: ."
and the following line of code is highlighted.
GlobalScope.BasicLibraries.LoadLibrary("Tools") ' natahnout std. knihovnu

I'm using Windows XP SP2, OO.o version 2.4.1. I am not very experienced in OO Macros.

I suspect a library called Tools is missing; there is a library with that name in the OpenOffice.org Macros container, but it seems to contain no modules. If this is the problem, where can I find the modules?

I would very much like to use this extension, so could someone help me? Many thanks.

Probably you are missing

Probably you are missing BASIC library Tools. Try last version (1.2.1), which should be independent of this library.

Searching paragraphs

The Extension I haven't tried yet. But I need to search for paragraphs and replace them by blanks or tabs. By copy and past I find a text an this text with several paragraphs has to be merged into one large block. It has to be guaranteed, that no paragraph sign is left inside the text.

Sometimes I need the opposite. Each blank or tab sign inside the text should be replaced by a paragraph sign, so that becomes one large column with one word in a line.

--
Moritz

Window size is too small

Just installed in 2.4.1 (linux) and find that the opened window for the macro is too small to be of use.

The box is cuts off just after "Extend" on the right, and just below "Match case" on the bottom.
Same problem in OOo 3.0 (M17).

The search box window shows correctly in OOo 2.3.1.

I think, it maybe caused by

I think, it maybe caused by this OOo issue: http://www.openoffice.org/issues/show_bug.cgi?id=87596

Very good!

I really recommend this extension. It is very flexible, and it allows very complex search and replace operations.
I use it to search for broken cross-references. It is irreplaceable for this, as Writer does not offer any other possibility to do so!
Also, Tomas has put very much effort in the documentation, that I find very helpful indeed.

thanks

Really good extension. It's very useful to convert texts form Writer to Spip. Thanks a lot.
S.

es-Es Localization

I've started spanish localization some weeks ago.
It's almost done.

Really good extension.

Localisation

Localisation of AltSearch is possible in next steps:

1. Download files AltSearch_localisation_v1.1.ods and AltSearchHelp_1.1_en.html. First file contains (almost) all strings, second is help file in html format, created in OOo webWriter, I recommend to translate it just in OOo webWriter and keep used paragraphs and characters styles.

2. Finally send translated files to me, e-mail is inside first file.

When you start to translate it, please report it here, so someone else is not doing the same translation.

Thanks to everyone who offered translation.

Tomas

Update

Updated files for localisation: AltSearch_localisation_v1.2.ods and AltSearchHelp_1.2ed_en.html. Changes compared to the previous version are marked with [v1.2].

Default file for batches (plain text in UTF8): AltSearchScript_en_1.2.txt.

de-De localization

German localization for AltSearch is done.