Thursday, 5 June 2014

Working with macros in OpenOffice

I decided to try to write a macro to help me strip the paragraph sign with three spaces that were left liberally interspersed in my document when I stripped it. To do this I recorded a macro.  (see

I assigned a macro so that every time I press 'shift + f10' the macro will delete the paragraph symbol (actually a 'soft return' in this case) and the three spaces. Assigning a key stroke to the macro was a bit tricky (see )

Can I train it to search and destroy, I wonder? I expect many have trod these paths before.

Indeed- I have discovered that you can actually search a document for blank space, or other characters, so instead of using my macro I have just highlighted an example the characters I wanted to search for (which shows as three white spots together) and done a 'search and replace'. This did not work on the paragraph symbol that preceded them, but at least now I only have to manually delete that instead of four characters each time.

Et voila! apparently the soft return is called a 'manual line break' and this page tells you how to search and replace


After wrestling for some time with various mysterious white space problems in Word I decided to try using OpenOffice instead, which is a simple free program very similar indeed to Word.  Having stripped out all the coding, as described in my previous post, I pasted the stripped HTML into an  OpenOffice Template that I downloaded from Catnip4writers .

This seems to be working OK so far. You have to remember to select OpenOffice when opening the document. Crude but effective. And I shall be keeping an eye on what happens when I add breaks, which seemed to cause unexpected spaces to appear when I was using Word.