This is a very useful feature, I think, so I'm reposting it.

Anytime you can help people do something without actually have them do anything is great for them and great for you.

Templates are a great way to save time. Set up templates with the styles, graphics, etc. that people need, and they don't need to re-create them. (Or create them in the first place.)

However, getting users to use the templates is another step. For them, choosing File > New > Templates and Documents might not be something some will want to do or remember to do every time.

What if one of the templates you've created is one that many or all users use all the time as the basis for new documents?   You can make it come up when users just choose File > New > [type of document] by setting it as the default template. I.e. the user uses the template but doesn't even need to select it.

First, create a new document and make it how you want it: create styles, apply styles, include canned text, whatever.

Choose File > Templates > Save. Select a category and name the template. Click OK.

Choose File > Templates > Organize.

Open the category your template is in, in the left side.

Right-click on the template and choose Set as Default Template.

Click Close. You're done! Choose File > New > [type of document] and you'll see the effect.

To switch back to the normal original boring blank document, repeat the steps but this time choose Reset Default Template > [type of document]

Let's say you've made this form, or opened one from Word.  If you created it in Writer you choose Insert > Fields > Other, Functions tab, and in the Type list you used Input Field. So far, so good.

You're done, and you start filling in the fields. You click on the first field, you get the window, you enter data...then you have to click OK, and click on the next field, and fill that in....that's not very fast, is it?
 



Close the window. Press Ctrl Shift F9.  That gives you this window with Next functionality built in.

Then to go from one field to another easily:

• Either press Ctrl Enter
• Or click Next

Annoyed by the complexity of pressing Ctrl Shift F9? Make it a different shortcut. Use this blog and this window; note where the function is in the following screen shot.
http://openoffice.blogs.com/openoffice/2007/04/creating_keyboa.html

You might not do it today or tomorrow, but you'll do it someday. You'll need to paste some content from a Web page, or a Word document, or something else that's got some goofiness embedded in it, into your Writer document.

Don't do it.

That is, don't just do a plain paste. Copy > Paste from here

gives you this.

Lots of cleanup.

Plus, when you paste from outside sources you sometimes get lots of sections. Sections are indicated, when you have nonprinting characters and text boundaries showing under the View menu, like this.

Choose Format > Sections and you'll see allllllll the little sections and how complex they are.

Why do you care? It's just icky and unnecessary, the sections will behave differently, you'll pull out your hair. Here's one example. I'm changing the left margin for the whole document, but only the section my cursor was in behaves.

So not to get into too much detail, but a plain paste will not give you what you want.

Choose Copy, then choose Edit > Paste Special (or Ctrl Shift V) and choose Unformatted Text.

And then you get this as your pasted result. MUCH better.

Envelopes can be problematic. Yes. This is primarily because envelopes are not Letter or Legal. Each printer has its own approach to printing, and you'll need to do a little experimenting.

But you can do it. The Envelopes category and the Mail Merge catogory of my blog each has various approaches.

But with this new entry I've tried to clarify what I think is the best and most straightforward approach to making envelopes. The thing is, creating the first doc is a little work, and figuring out how to print is a little work. But once you do it, you don't have to create the envelope document again. You don't have to figure out which way the printers go in. You know. So the second time and all other times, you just open the old doc, whether you made it into a template or just saved it in

C:\myreusabledocs\envelope.odt

and retype the info. Then you print, and you now know how to print.

Just do the hard work once. Then re-use.

THE PART YOU ONLY HAVE TO DO ONCE: CREATING THE ENVELOPE THE FIRST TIME AND FIGURING OUT HOW TO PRINT

A) Make the envelope document once

B) Print

C) Save it as a template so you never have to make it again

THEN ONCE YOU'RE SET UP PRINTING ADDITIONAL ENVELOPES IS MUCH SIMPLER

D) Open the template, retype or paste, and print

Here we go.

THE PART YOU ONLY HAVE TO DO ONCE: CREATING THE ENVELOPE THE FIRST TIME AND FIGURING OUT HOW TO PRINT

A) Make the envelope document once

1. Create a new empty document. This will be your envelope.

2. Now make it look like an envelope. Choose Format > Page, Page tab. Make your window match the settings in this window, then click OK.

 3. This is what it should look like.

 
4. Type the return address if you want (skip it if you've got that already on your envelopes.)

After typing, you want to take the cursor, the entry place where you type, down and over. Click after the return address and press Enter a few times til the cursor is about as high as you'd want it to be for the regular address.

 5. See the top item circled on the ruler? Click and hold down on the bottom triangle and drag it about halfway over.

6. And now the cursor is where you need it to be to type the address.

7. Type the To address.

8. And now you can format it of course any way you want.

9. If you don't like where the To text is, click above the text and press Enter a few times to lower it or press Backspace a few times to raise it. Just the same way you'd do it in a normal doc.

10. And to move it left or right, select at least part of the To text and drag that bottom triangle left or right. Same way you did it before.

B) Print

Take out some cheap envelopes. You're going to need to experiment a little potentially.

1. Choose File > Print. In the Print window, click Options and in the window (this varies by printer), find the paper size and choose Envelope 10. This is the most important part of printing. You must do this or it won't work.

Click OK in the settings window, then specify your print options and click OK to print.

Now, it's up to you to fiddle with which way to insert the envelope, up or down or one end first or the other. That's allllll your printer.

If you end up getting the address printed 90 degrees off, then make this change to the print setup in your print window too. Print it landscape. How it looks in your printer will vary.

Click OK in the settings window, then click OK to print.

At this point it should  work.

Once you've got it working, write down all the settings you did that work.

Note: You can also choose File > Printer Settings in your document and make the same paper size and landscape/vertical settings there. And theoretically those settings are saved so you don't have to do it again each time you print. If it works for you, great. However, I've found this slightly less reliable.

C) Save it as a template so you never have to make it again!

Had enough formatting? Then just save it as a template so you never have to create it again. You can make it into a template by choosing File > Templates > Save, selecting the My Templates category, naming it, and clicking OK.

Then use the template. When you want another envelope, choose File > New > Templates and Documents, click the Templates icon in the window that appears, and open the My Templates category.

 Inside the category, find your envelope. Double-click it. And you'll get a new untitled envelope document just like the one you made.

Then just type or paste new info.

THEN ONCE YOU'RE SET UP PRINTING ADDITIONAL ENVELOPES IS MUCH SIMPLER

D) Open the template, retype or paste, and print

This is all you have to do once you've done all this stuff.

• When you want to print an envelope, open up that template. (Or skip the whole template-making thing and just open the old document, wherever you saved it.)
• Type or paste in new information.
• Print, being sure that the printer is set for Envelope 10 and, if necessary, Landscape.

That's all.

Notes are easy to use, easy to format, and really, really easy to read, in 3.0. Printing is the same, so not that great but not less than what we had.

You start out the same way. Choose Insert > Note.

You get a box, and you just type. Note two things: first, just the note box there which is just what you'd expect, but also check out the circled icons. Those icons, the enabled ones such as font and bold/italic/underline, are available to use when formatting the note.

Then you finish formatting, and you could have something plain, or something as silly as this.

If you click on the little black triangle in the lower right corner you get a few options.

And you get those options plus formatting options if you just right-click somewhere in the text of the note.

To print notes, just File > Print, and click the Options button. You can print the notes where you want, at the end or after each page. You can also print only notes.

Here's another nice new 3.0 feature. You can view pages side-by-side in editable mode, up to three.

Here's a normal page.

Here are the controls, in the lower right corner, for viewing side by side and zooming. The icons are Single, Double, and Double-with-first-page-on-right-side (more on that later).

You can drag the little slider bubble in the middle and drag it from right to left and back to control magnification. The vertical lines indicate how far you have to be for one, two, and three pages at time.

And the 100% zoom is the regular approach to zoom; right-click on it or double-click it to get different magnification choices.

Here's what you get. Please click each image to see it bigger. When you have the icons set this way, with the single icon showing, the little slider dot to the right of the second line, and magnification at 100%, you only have room to see one page at a time, and even if it were smaller, it would only show one at a time.

I click the Double Page icon and I drag the little slider dot to the left.  It gets smaller but that's all. That's because the slider dot is still to the right of the first vertical line.

Now I drag the slider dot to the left of the first vertical line. The Double Page icon is also still marked, and I get two pages side by side. This is in the low 60% for zoom.

Now see what I get when I drag the slider dot to the left of the second vertical line. There are three pages displayed across.

Now when I click the Double-Pages-But-With-The-First-Page-On-The-Right, the right-hand of the three icons, and drag the slider back a little, we get this. This view is great for book production, when the first page, an odd page, is always on the right side. (Take a look at any printed book and you'll see the odd pages are on the right.)

Insert > Formatting Mark has a host of goodies for extra control over your text flow, such as a non-breaking space or hyphen.

First, set up OpenOffice so you can get all the options. Choose Tools > Options > Language Settings > Languages and select the indicated Enabled for Complex Text Layout option. Click OK.

Now choose Insert > Formatting Mark and choose the one you want.

You can see the keyboard shortcuts on the menu, and here are a couple as described in the Help.

<!-- @page { margin: 0.79in } P { margin-top: 0.02in; margin-bottom: 0.02in; font-family: "Bitstream Vera Sans", "Arial", "Helvetica", "Lucida", "Geneva", "Helmet", sans-serif, "Andale Sans UI", "Arial Unicode MS", "Lucida Sans Unicode", "Tahoma"; font-size: 10pt } -->

* Nonbreaking space: To prevent two words from being separated at the end of a line, press the Ctrl key when you type a space between the words.

* <!-- @page { margin: 0.79in } P { margin-top: 0.02in; margin-bottom: 0.02in; font-family: "Bitstream Vera Sans", "Arial", "Helvetica", "Lucida", "Geneva", "Helmet", sans-serif, "Andale Sans UI", "Arial Unicode MS", "Lucida Sans Unicode", "Tahoma"; font-size: 10pt } -->Nonbreaking dash: An example of a non-breaking dash is a company name such as A-Z. Obviously you would not want A- to appear at the end of a line and Z at the beginning of the next line. To solve this problem, press Shift+Ctrl+ minus sign. In other words, hold down the Shift and Ctrl keys and press the minus key.

Here's how cropping has been up to 2.4 and in Writer 3.0. It works, but it's a little bleagh. You crop by specifying in your favorite unit of measure how far in from the top bottom left and right to crop an image.

So in 3.0, in Draw but not in Writer, you can crop just like you always wanted to, and can in other applications. You start out the same way as always -- insert the picture, click on the picture, then click on the Crop Picture icon on the picture toolbar.

(This is my good friend Max, but let's say that I was mad at him and wanted to crop him out of the picture.)

When you click on the Crop icon, you get these lovely crop handles.

Just drag'em where you want'em.

And there you go. No more Max.

I click off the graphic and it looks the same, of course.

But! Note that it just crops the display of the graphic. If I cool down and decide not to be mad at him anymore, I can decrop, just by clicking on the crop icon again and dragging the crop handles to include where he used to be.

Note: There's a Crop extension too but there's no Undo associated with it.

Thanks to a colleague for this.

Here's the scenario. You've adopted an OpenOffice.org. You're saving hundreds of thousands of dollars. Or thousands. Or millions. It's a lot.

And OpenOffice.org is working. It's allowing your users to get their work done. You've done your pilot and testing and worked through the initial issues with getting everyone up and running, and you're satisfied that it works.

But you have someone, possibly hundreds of someones, telling you that they absolutely need Microsoft Office for various reasons.

Don't just say no. Consider this approach.

Tell them you'll be happy to consider it if they'll present you with the business case for switching. Give them all the costs, including costs for OS, admin, and hardware, of using MS Office. (For instance, if you're on Linux, switching to MS Office also involves getting Windows.)

Ask them to contrast the amount of time they would save, or whatever the benefit is of getting MS Office, against the amount of money saved per person per year, of using OpenOffice.org.

This is particularly effective with people who claim (sometimes accurately, often inaccurately) that MS Office is quicker. That five clicks are necessary in OOO but two clicks in OpenOffice.org.

click = 1 second
doing the task 10 times a day
1 x 3 x 10 times a day x 5 days a week x 50 weeks a year = 125 minutes or 2.1 hours a year

2.1 hours a year of their time is used on OOo when it wouldn't be on MS Office. (Of course, they would spend this much time just doing the business case.)

This approach, if they actually follow through, points out to them and to anyone with authority over decisions and writing checks that there really isn't much impact. It might feel better, and sometimes at least at first be a little more convenient for some procedures for some users to use Word. But is preference enough? Not when you look at the big picture and the business case.

And of course by saying "sure, we'll listen to your request, just do a business case," you get to be the good guy and the ball is back in their court.

Now, if they do have a business case for getting, for themselves and maybe three other people in the company, a few copies of Excel or whatever, then sure, get it for them. It's all about having the right tools and spending your money on what makes sense.

Reviews
http://www.pcmag.com/article2/0,2817,2332502,00.asp

Download
http://www.openoffice.org/

You can do it!

Here's what you need to do.

Choose Tools > Share Document.

In the window that appears, select the checkbox. Also note the highlighted portion of the text.

Click OK.

You'll see "sharing" in the title bar.

Repeat the previous steps to unshare. You'll see this message.

I don't have a network right now to test and get screen shots on but I tested it during a previous class with a network. Essentially updates of other people's tasks are displayed when you save. Sometimes before. And sometimes there is a lock from another person but only temporarily.

I've been asked if this feature, available in Excel, exists in Calc. I didn't see it til a reader pointed it out. Here it is!

Let's say that you have some nine-digit zip codes, and you'd like to split them into two columns, the regular zip and the extension. The following illustration shows both. (And this post shows other ways to split them and/or deal with sorting them correctly.)

Select the column and choose Data > Text to Columns.

This is what the window looks like by default.

Now you need to specify at what character you want Calc to go "Hey, time for a new column!" In this case it's the dash. It's not listed so you just deselect Tab, select Other, and type the dash. Then scroll through the data and you'll see how it's going to look if you click OK now.

Click OK, and you get exactly what you want. (Note that you could split a column into two or more, splitting a social security number column would give you three columns because it has two dashes, 333-44-5555.)

If  you have phone numbers, you can use this to split the columns twice, once at ) and then once at -.  (You would use Edit > Find and Replace to get rid of the ( at the beginning of the area code.)

Phone number data:

Data > Text to Columns brings up the regular window where, the first time, you specify ) as the separator.

Click OK and you get this.

Then just do it again on the column containing the phone number with the - and split that at the - the same way we split the zip codes earlier in this post.

I created this presentation  for a client, about the 3.0 features in OpenOffice.org. I'm going to do a more detailed article but I thought I would post this since I've done it. Here's the solver.ods spreadsheet you can use to fiddle with.

I got pretty excited about some of them, especially the 3-up layout with lines already in there, and the far easier Impress handout printing.

And for those who like a good cross-reference, you don't need to create them first; you can just point to a heading in a list and select it, to make the cross-reference.

Also very exciting is the PDF editing, which does some very Adobe Acrobat type things. It's in an extension you can get here.

In the words of Douglas Adams, share and enjoy!

I'm afraid the Tools > Mail Merge Wizard has never been one of my favorites. Too complicated.

I always train people to just "roll their own" when making a mail merge document.

http://openoffice.blogs.com/openoffice/2007/01/mail_merge_in_o.html

Everything you can do in the mail merge wizard, you can pretty much do in the roll-your-own approach, especially since you can now print all documents to a single file and then open that and customize it as you like, before printing on paper.

Printing

and viewing/editing the file output. (Click to see the bigger version; you'll see different values in the two letters.)

BUTOne thing you can't do in the roll-your-own approach is do an email mail merge.

Do you really want to go through the complexity and muscle aches of using the Mail Merge Wizard? No. And you don't have to. You're going to mix and match.

Step 1. Create your email the way you want it with the roll-your-own approach.

http://openoffice.blogs.com/openoffice/2007/01/mail_merge_in_o.html

Save it. Keep it open.

Step 2: Set up email configuration. In Writer, choose Tools > Options > OpenOffice.org Writer > Email. This setup worked for me. Key settings are smtp.comcast.net and port 587. You just need to do this once. If you have security on your email, like requiring a password to send, you'll have to click the Server Authentication button and enter additional information.

Step 3: Choose Tools > Mail Merge Wizard. Choose Current Document, or else browse to your document, and click Next.

Choose Email and click Next.

Select the database you're using and the table. Click OK and click Next.

Keep clicking next til you're here. Fill it in by selecting the field from the database that has the emails in it, and anything else you want.  Click Send Documents.

You'll see the progress window (in this test I only sent two emails).

And you're done!

The received email looks like this. Note that I sent it in email format, but with the extra carriage returns I put between the lines in Writer, it looks a little spacey here. You'll want to experiment with and adjust how you format the original Writer documents and what format you send in.

Every advance leads to benefits and to problems.

The 9-digit zip code is great for delivery accuracy. But they aren't required. So you have mixed 5-digits and 9-digits.

Now just try sorting your address info by zip code when there's mixed 5s and 9s. Here's what you get when you sort a standard address list by zip code.  It's like cattle and sheep, they don't mix.

What do you do?

There are three things you can do:
1 - Enforce a 9-digit zip. Everyone without four digits gets -0000 whether they want it or not.
2 - Put a ' in front of every zip code. It doesn't print but it forces the zip code to think of itself as text. (This also helps with not losing leading zeroes.)
3 - Split the column into two, so you have the zip in one column and the four-digit extension in the other. This is kind of like the forcing-9-digit solution.

The explanations follow but if you want to root around in an example spreadsheet, here's a spreadsheet with options 2 and 3.

Solution 1
Solution 1 is self-explanatory.

Solution 2
Just type a '   a regular apostrophe on the keyboard, to the left of the first character of every zip code. It doesn't show but it forces text format.

See? The ' is there in the entry field but it doesn't show in the spreadsheet cell.

Typing ' into thousands of cells takes a while. So you can search and replace. There might be a better way to do this but this at least doesn't suck.

Click in the Zip Code heading in your spreadsheet, then  choose Edit > Find and Replace. Click More Options and fill out the window as shown, searching for ^0, caret zero, and replacing with '0, apostrophe zero.

You'll need to do this once for 0, then for 1, then for 2, and so on. (I've tried to figure out a faster way, plus submit any suggestions.) 

Either replace one at a time if you're cautious, or go nuts and replace all. You might want to select the whole column of zip codes, too, and select the Current Selection Only checkbox.

When you're done, and when you sort that data, the zip codes sort correctly.

Solution 3

You can split your data into two cells with the LEFT and RIGHT functions. I'm throwing in IF too because sometimes you'll want the right-hand four digits (the extension) and sometimes you'll want 0000. (Or just leave it blank, whatever you want to do.)

This is what I want to achieve.

And this is how I get it. The formula for the first column, where I extract the first five digits, is simple.

The right-hand side is a little more complicated since you're dealing with variable-length zip codes. But basically you're saying if the zip code is just five digits, then create a new 4-digit extension, "-0000" (or just "0000" depending on how you want to deal with the dash). And then if it isn't just five digits, then you want to see the right-hand five digits of the zip code (including the dash) or the right-hand four digits (if you want to leave out the dash and put it in manually somehow).

Then you just drag down those formulas to all the zip code cells.

If you want to turn those columns into normal text, just copy them, choose Edit > Paste Special, choose to NOT paste formulas, and click OK.

The pasted results are nothing but numbers.

Now when you sort, you just need to be sure to do it by two levels, first by the main zip code, then by the extension. BE SURE that you set the Ascending or Descending the same for both.

And you get your results, sorted correctly.

Here's a spreadsheet with options 2 and 3.

Mail merges work fine with spreadsheets as the data source. You create a spreadsheet of data, then choose File > New > Database, specify connecting to an existing database, Spreadsheet as the type, then click Next and point to the database itself.

Here are a couple things about formats, though.

Formats don't come through. So if you want your Salary field to have dollar signs, decimals, etc. you need to set the format. Likewise with date or time.

One way to do this is just set the formats when you view them. Press F4 and expand to view the query or table you want. Then just right-click on the column heading and choose Column Format.

Then in the window that appears you can select a category (Currency, Date, Number) and the the specific format you want. Click OK.

You can do the same thing in the database file itself. Open the .odb file, click the Tables or the Queries icon at the left, then double-click on the particular table (the sheet or query).

In the window that appears, right-click on the column heading, choose Column Format as before...

and in the window that appears, as before, make the choice you want. Click OK.

Now, here's a related topic. Can you use the =NOW() function in a spreadsheet and have it interpreted correctly in the database and in mail merges? (Thanks to a Colorado Springs LUG member for this idea.) The answer is Yes.

Here's a spreadsheet with =NOW() showing the absolutely current time and date.

Here's what it looks like, with nothing done to it, in the database view. It needs some tender loving formatting since it's just showing the internal numeric value. Right-click on the column heading and choose Column Format.

Set the format you want. The NOW() function can let you use a date or time format since it contains both.

And now it looks fine in the database view.

When I use this field in a mail merge....

Here's the output when I format the field as a date:

and when I format it as a time.

Never retype when you can do it quicker!

In OpenOffice.org Calc spreadsheets, as in Excel, you can click on a cell, find the little black handle in the lower right corner, and drag it up, left, right, or down, to get additional content.

If it's a number when you drag you'll increment by 1. If it's a value like the days of the week or names of months, it will increment as in January February March.

If it's a formula where you've just typed it normally without absolute  references, then drag it down through a column or row, it will repeat the formula as shown. Here's the first cell with the formula:

Drag down and you get similar formulas referencing the next-door cell, not the original cell.

If it's anything else it will just repeat.

If it's a number or day/week/month (not a formula) that usually increments, and you just want it to repeat, you can:

- Select the cell containing the number, as well as all the cells that you want it to repeat into, and choose Edit > Fill > down or right or whatever fits the cells you've selected

- Or you can hold down Ctrl when you drag and it'll do the same thing: repeat instead of incrementing. This works for incrementing months/days etc and numbers.

Note: for formulas, if you want them to not adjust as you drag, you use absolute references as in Excel. $A$4 instead of A4 for instance.

I wrote this article  for TechTarget about the fabulous Web Wizard and its uses for mass PDF conversion and quick web publishing of existing documents. This is a "classic" post but it's a great feature that bears re-posting about.

You have a lot of control over how OpenOffice is set up. One of them is automatic formatting. I recommend turning off most of it. Here are two things to do that will make OOo work the way you want.

Choose Tools > Autocorrect, Options tab, and unmark everything from the second line on down. This will prevent, among other things, the numbering formatting that  starts when you don't expect it.

Then choose Tools > Options > Writer > Print and unmark the circled option. It will take out that annoying extra page you get sometimes and you don't know why . (It has to do with right-left pagination for books.)

Note: This is a repost but useful. It's important to follow the steps exactly. Everything is case sensitive. Also when you type the two "" quotes, don't put a space between them. If you have spaces in your database, this won't work. Either change the database field names, or create a query based on the table, and change the field names in the query. Then base the labels on the query.

Here it is -- suppressing a blank Address2 field in your mail merges. It's not extremely simple, but it's reasonably straightforward and it works.

Here's the situation we're addressing. Sometimes your addresses have two lines for the address part, sometimes they don't.

Bob Jones
101 Main
Suite 55
Boulder, CO 80022

Marion Silverman
888 105th Ave
Broomfield, CO 82211

But you have to put in the <Address2> field for everybody, since it's a mail merge. The setup has to be the same.

<Firstname> <Lastname>
<Address1>
<Address2>
<City>, <State>, <Zip>

But with this approach, your addresses look like this.

Bob Jones
101 Main
Suite 55
Boulder, CO 80022

Marion Silverman
888 105th Ave

Broomfield, CO 82211

Ick. How do you suppress that second Address2 line and the corresponding carriage return if there's no content for a particular record, for that Addres2 field?

Select the Address2 field in your mail merge document, choose Insert > Section, and create a conditionally hidden section with this formula.

databasename.tablename.fieldname EQ ""

Here are the details, using an example of labels.

1. Create the labels for mail merge as usual. File > New > Labels, select your database and tables, insert the fields, etc.

2. Choose the Synchronize Contents checkbox.

3. Click New Document.

4. Here are the labels.

5. Turn on nonprinting characters if they're not on already.

6. Select the first soft return, shown selected.

7. Press Return or Enter to replace it with a hard return.

8. Repeat, to make them all hard returns.

9. Click Synchronize to update the other labels to be the same.

10. Select the Address2 field.

11. Choose Insert > Section.

12. Name the section Suppress. Select the Hide checkbox and type the following condition. The screen shot shows the syntax.

Syntax
databasename.tablename.fieldname EQ "" � �(the last part is two double quotes together)

Example
databasewithtwoaddresslines.Table1.Address2 EQ ""

NOTE: if you are using the Thunderbird address book as a data source, you need to use square brackets if the field name includes a space (i. e.: [Address 2]=="") to hide the second line of the address if it the Address 2 field is blank.)� I would suggest in general avoiding field, table, or database names with spaces.

http://www.oooforum.org/forum/viewtopic.phtml?t=43528&highlight=

Click the screen shot to see it bigger. It shows the syntax, not an actual example.

13. Click Insert.

14. Click Synchronize.

15. Now preview the data or print the data and you'll see that it prints correctly.

15. If you need to change the section, select it in the first address and choose Format > Section. Select the one named Suppress for the master label and make changes, then click OK. Click Synchronize again in the labels.