April 16, 2008

Linux Comic Strip!

Check it out. The article

http://www.rlhc.net/blog/2008/04/15/linuxcom-comic-strip-aims-for-a-fun-way-to-educate-new-linux-users/

and the strip.

http://www.hackettandbankwell.com/

Woody_hackett_and_jerome_bankwell_w

Hackett and Bankwell #1

Synopsis: Woody Hackett learns from his business partner, Jerome Bankwell, that they are the new owners of a documentary production studio that still uses Mastersoft, and that he will need to travel to their facilities in the desert in order to get them setup with Ubuntu Linux. At "Interplanetary Pictures," Woody shows their crew how to get started using the Ubuntu GUI following an installation. Guiding them through some basic software installation, Woody demonstrates to Kaori Soto and her associate Calvin Green basic ideas of GUI operation, so that they can use what they've learned to install other programs they might need down the road.    Areas covered in first issue

April 15, 2008

Diggin' DimDim: Open Source Multi-Platform Web Collaboration Software

I think I've found the software I'm going to use for online training, seminars, and one-on-one tutoring and support. It's in Beta, but it looks really good.

DimDim has the key things I need:

- supports Windows, Linux, and Mac (not sure if Linux or Mac can be the host)
- supports sharing a presentation, or my desktop, or a collaborative whiteboard
- supports audio and video (with some webcams)

and is free for up to 20 participants. Click here to see pricing for over 20.

No download for the participants, just the host. They use Flash.

There's a "Collaboration" link on the client side that just processed for a while and didn't give me anything. I'm desperately hoping that that is a to-be-implemented feature that lets me manipulate files on client computers or vice versa. That's a huge, huge nice-to-have for me, bordering on essential. I don't know for sure that it doesn't exist, but I haven't found it yet or found info on it since I'm not sure how broadly to interpret the word "share". I'll update this post when I find out.

Recording and archiving is coming.

Feature list.

I am seriously impressed. I've fallen too soon for other software that turned out to not have what I needed (and plenty that had what I needed but for a robust price), so I'm taking it slow this time. But I think Dimdim Is the One.

Here's what the main window looks like for the presenter. I tried it on two client computers, Windows XP and Novell Suse (that's the gibberish in the chat window that I typed just to try it out).

Dimdim

Audio worked with my Creative Live! Webcam with voice, video didn't.

Sign up if you want to host meetings through DimDim.

Seminars, Support, Remote Training

I want to mention again my ongoing plans to provide all sorts of services through collaboration software, hopefully DimDim. These are in the near future; rates will be announced with the services.

Support -- Got an issue you want help figuring out? Send a request to my calendar for a time, upload the file to the collaboration software or email it to me, and I'll help you with the problem document or task.

Tutoring -- Want to learn something, like mail merges or styles or pivot tables? Just make an appointment and you'll get one-on-one attention.

Remote custom training for groups -- If you just want a few hours of training at a time (which makes it less practical to fly me in) or you have employees in many locations who need training, remote training makes a lot of sense. Contact me to plan topics and dates. We can use DimDim or your own collaboration tool such as WebEx, GotoMeeting, or ReadyTalk.

Regularly scheduled seminars -- I'll ask for requests, then schedule short (half-hour to two-hour) seminars on scheduled topics. Costs for these per person would be lower than signing up for tutoring.

Regularly scheduled free seminars -- I'll schedule free half-hour or hour-long seminars periodically on popular topics like mail merge, configuration, considerations for planning a transition, etc.


Traininglogo




April 14, 2008

Un-displaying the grid lines in OpenOffice.org Calc

Tired of those pesky gridlines being displayed onscreen? Here's how to turn them off.

Thanks to Marek for pointing this out -- I like to consider myself the queen of "it's under tools > options" but I only looked under the View menu before resorting to hack measures.

Choose Tools > Options > Calc, View. Deselect Grid Lines. You can change the color of the grid lines here, too.


Viewgridlines

Note that by default, they don't print. To make them print, choose Format > Page, Sheet tab.

Printgridlines


Traininglogo




Attaching a Document (Including Templates) to an OpenOffice Menu Item or Toolbar

This is huge. Thanks to TerryJ on the users@openoffice.org alias for pointing the way.

So you're an IT director. You want to make things easy for your users (and thus easy for your team so they need to answer fewer questions). One way to make things very easy and simple for your users is to create templates.

  • Create a template that has no page number on the first page and a page number, starting at 1 or 2, on the 2nd page. (A user could create this but it involves understanding styles and is just way more difficult than it needs to be.)
  • Create a template that has a watermark background like Confidential.
  • Create a template that has whatever characteristics are needed for a department's tasks.

Now, you could create a template and just set it as the default template so that users get that template when they choose File > New. But if you have multiple documents they need to make, you probably don't want to do that. Or you can do that, but you have more than one template you want to offer.

You could just put your templates in a nice centralized location for your users. However, some users don't view it as all that convenient or obvious to choose File > New > Templates and Documents, the pick the right category and the right template.

Here's how to make it easy, and thus likely, for users to use the templates you provide for them, and thus for them to not even enounter problems, or encounter tasks that are harder than they need to be.

Make a menu and attach templates to menu items on that menu.

Now, this means more up-front work for you, but then it's done.

A)  Make your templates and put them in a central network location. Be sure they're in template format, not document format.

B. Create a new menu.
Choose Tools > Customize, click the Menu tab, click New, then name it and click OK.

Attach1

Attach2

C. Now you just need to add menu items that point to the templates.

First, create the macro.

1. Choose Tools > Macros > Organize Macros > OpenOffice.org Basic.
2. This window will appear. The macro I already created is listed there. In this example I'll create another one that does the same thing.

Macro1

3. In the Macro Name field, type the macro name like OpenTemplate.

4. Click New.
Macro2

5. What you now see in the macro editing area will depend on what was there last. I'm not incredibly familiar with the macro window but I know that what I did worked ;> so you should be able to follow these directions successfully.

Macro3

Regardless of what else is in there, you want to have the following. Find the part that says 
Sub macroname
End sub

and put your macro in the middle.  Leave all the other macros that are there.

6. Now you want to write the following macro. There are variations here but this is what I did that worked.

I show an example first, then syntax.

Example


Sub OpenTemplate

Dim sUrl as String

sUrl = "file:///C:/openofficemacros/sampletemplate.ott" ' note you must use url format
If NOT FileExists( sUrl ) Then : Msgbox( "No file named " & sUrl ) : Exit sub : End If
StarDesktop.loadComponentFromURL( sUrl, "_blank", 0, Array() )

End Sub

Now the syntax


Sub name of macro

Dim sUrl as String

sUrl = "file:///path to file you want to open"'    ' note you must use url format
If NOT FileExists( sUrl ) Then : Msgbox( "No file named " & sUrl ) : Exit sub : End If
StarDesktop.loadComponentFromURL( sUrl, "_blank", 0, Array() )

End Sub

 
7. Click the Save icon and close the macro.
Macrosavesmall

8. If you choose Tools > Macros > Organize Macros > OpenOffice.org Basic again, you'll see the macro name. Here the original one I wrote and the one I added for this example are both shown.

Macro5_showboth

9. From here, you can either:
Select the macro to use and click Assign
OR
Close the window, then choose Tools > Customize, and in the Menus tab,  select the menu you created.
Macroadditem1

10. Click Add next to the empty list for menu items

11. In the window that appears, expand the Macros category at the bottom, and select the macro you wrote.
Macroadditem2

12. Click Add.

13. Close the window.

14. Select the item, click and hold down on Modify.
Rename1

15. In the window that appears, rename the item however you like and click OK.
Rename2

16. Click OK in the Customize window.

17. Now choose the menu and the menu item.

Choosefrommenu

18. The document you created appears. If you created it in template format, then it will be an untitled copy of the document.

Macroadditem4

D. Copy the configuration to other computers.

1. Copy the macro to the same location on other computers.

2. Copy the configuration file where the menu and menu items are stored to the same location on other computers. It's called menubar.xml; there are several depending on what the menu is for. Here's where it is on Windows for a Writer menu; for Calc it would be scalc\menubar\menubar.xml, and so on.

<openofficeinstalldir>\soffice.cfg\modules\swriter\menubar\menubar.xml

Here's what the content looks like in the menubar.xml file.

<menu:menu menu:id="vnd.openoffice.org:CustomMenu1" menu:label="Use These Templates">
  <menu:menupopup>
   <menu:menuitem menu:id="vnd.sun.star.script:Standard.Module1.OpenTemplate?language=Basic&amp;location=application" menu:helpid="vnd.sun.star.script:Standard.Module1.OpenTemplate?language=Basic&amp;location=application" menu:label="Use this for meeting minutes"/>
  </menu:menupopup>
</menu:menu>

See this link for the original explanation.


Traininglogo




April 11, 2008

OpenOffice! The Musical! (Friday fun)

There isn't one yet.

But how much fun would it be to follow these folks' lead?

http://improveverywhere.com/2008/03/09/food-court-musical/

Do it in a big office building somewhere, or in a mall, maybe outside the Mac store.

The big "I wish" song that starts off every musical, some ingenue gets up and sings, let's see.

Word 07, what a shill
Just money making for ol'Bill
My numbered lists are strange and wrong
It makes me break into a song....

And so on, and then the cartwheelers come along, and the chorus sings about how they wish there was something free and open and that had built-in PDF (what rhymes with PDF?), etc.

Coverage on the evening news, of course.

Just a thought, as I end my lunch break and prep for this afternoon's Advanced Calc class.


Traininglogo




April 10, 2008

Creating a dropdown list in OpenOffice Calc that references a list of values (repost)

I just started using feature this recently, for my LinuxWorld presentation. It's very nice. Anytime you can reference some text, rather than embedding it in the formatting, it's good.

List2referring_2

Some background: under Data > Validity, you can control what people can enter in spreadsheets, and offer them help in the form of lists, help tips, etc.
Validitywindow

I wrote about the Validity tools here

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

and elsewhere on my blogs. However, what I haven't talked about yet is how to make a dynamic list.

Let's say you've got a spreadsheet documenting the year's performance for the 120 people in your company, one sheet for each person. They're summarizing what they've done this year, and you want them to list the projects they've worked on. You would like to list the Official projects rather than having them type in whatever. So you want a dropdown list. Howeve, you don't want to have those projects typed in that dropdown list because then if you change it, or use this spreadsheet next year, you'll have to correct the list 120 times. (You can copy and paste, but still.)

So you make a list of the projects that references a cell range in a sheet called Projects, say, and all you need to do is update that one cell range to make all the lists update.

List1

Here's how you do it.

1. Click in the cell where you want the list to appear. If you want the list in multiple cells, select multiple cells.

2. Choose Data > Validity.

3. Select Cell Range in the list.

4. Type the range. To type a range in the same sheet , type something like this:

$F$1:$F$20

You need the $ to make the reference absolute.

If the range is in a different sheet, add the absolute sheet reference in front, like this.

$Projects.$F$1:$F$20

5. Click OK.

Then if you need to, just change the contents of the cell range and the list updates. Previous entries in those spreadsheets containing entries no longer in the list do not change.


Traininglogo




April 09, 2008

Personal Information Manager (PIM) on the roadmap for OpenOffice.org

Here's the article.

"In 2006, a Personal Information Manager (PIM) has been added to the roadmap of OpenOffice.org. Users constantly asked for this feature, and it's still seen as a key missing piece towards a full OpenSource Office solution. The PIM targets to complete OpenOffice.org's productivity offering by providing an integrated E-Mail, calendaring and addressbook client. The roadmap presented at OOoCon 2007 lists it as one of the highlights of the upcoming OpenOffice.org 3.0 release."

I definitely get a lot of questions about this. Of course, Evolution or Thunderbird and Sunbird are current options.

Read more.


Traininglogo




April 08, 2008

Selecting two or more drawing objects in an OpenOffice Writer document

I have been spending some time under Tools > Customize, Keyboard tab, looking through the features. I was looking at the Writer features for 2.4 when I came across this little item.

Multiselect

Gosh, I said to myself, could this be the option, very well hidden, that would let me multi-select objects in Writer?

Because, as you may have experienced, it is difficult to select two or more objects at the same time using Ctrl or Select.

Well, not quite. You still can't select two or more pictures or frames at the same time. But Ctrl + F8 does let you select two or more drawing objects at the same time. Select the first one, hold down Shift, and select the next one.

Multiselect2


Traininglogo




April 07, 2008

Download your OpenOffice.org 2.4 and check it out

http://www.openoffice.org/

Check out the nice web site redesign, too.


Traininglogo




Another way to do labels, online

Try this. I haven't worked with it but a reader says it's quite simple, and free.

If you're looking for info on labels with OpenOffice.org, it's all under the Labels category; try also Mail Merge.


Traininglogo




x

April 03, 2008

Off topic: Monty Python Fans, Rejoice

This isn't the first post you've seen on this. And I regret that so many people are still waiting for their bags, stored somewhere in and around Heathrow.
http://www.boston.com/business/articles/2008/04/02/fedex_to_sort_out_heathrow_baggage_mess/

But how great is it that there's already a song just for those who are, well, worried about the baggage retrieval system they've got at Heathrow?

I get too much of a kick out of it not blog about it.


Using Names to have a more readable reference to items in formulas

Who doesn't love a formula like this?

=(E18*F25)/((AVERAGE(C23:C20)) + SUM(D18:D29))

Now, the math is fairly complex and I just made it up to look extra complex, but just looking at it, you're not sure what it's referring to.

If you used names, which let you give more clear, descriptive names to parts of your spreadsheet, it could look like this.

=(TotalSales*TotalMonths) / ((AVERAGE(2006Sales)) + SUM(SalesBonus))

Ahh.....that's a little clearer. (Since it's a random made-up example, it might not make total sense from a business standpoint, but you're at least in the ballpark now.)

That's all very well, but how to do you add the names?

You can assign any name you want by selecting one or more cells and choosing Insert > Names > Define.
Names2insertnamedefine

 

Type the name, click Add, and click OK.
Names3dedfinname

Then you can create formulas like this.

Names7b

Note that you can't do this:
=Ement+Admit

because those names refer to ranges. You can't do  =Ement+Admit because you can't do =B17:B20+E17:E20

You'd need to create more names to refer to just the totals. You'd create another name for the total field where the =SUM(Ement) total is, so that then you can type =TotEment+TotAdmit  (total Entertainment Expenses plus Total Admission Expenses).

 

There's a quicker way to get all your columns named. Let's say you've got this data.

Taxes

Select all the data and choose Insert > Names > Create. In this case it makes sense to select the checkmarks for top row and left column since that's where the labels are. Then click OK.

Aname1

To look at the names created, choose Insert > Names > Define.
Aname2

Now you can create totals, for instance, like this. Note that when you're in a formula and you start to type a name, it will appear in the Formula field as Prepaid_Taxes does here. Press Enter to accept it so you don't have to type the whole name.

Aname3

As mentioned before, you'll probably want to make fields to just refer to the totals. Select the cell and choose Insert > Names > Define. Type the name, click Add, and click OK.

Anames4

And then you can do something like this for the formula. (Yes, you might do a SUM(range) for this but let's say that you've got all these amounts, Bus exp and Salary etc all over on different sheets or farther apart, so you would have to do the + instead. )

Anames5

and get a result.

Anames6total

Tip: If you want some visual help figuring out where all those names come from, now that you don't have the cell references, you can choose Tools > Detective > Trace Precedents.

Caveat2


Traininglogo




March 31, 2008

An equivalent of the Word's Outline View, with the OpenOffice.org Writer Navigator

[Digg it]

Who hasn't had one of these experiences?

  • You're writing your guide to gardening, you're looking at the headings for your garden-preparation chapter, and you realize you have made instructions for the compost pile a level-3 small section when it should really be a chapter of its own.
  • You think, re-reading the first draft of your novel, "No, the dream sequence should come first to grab people, and I'll put the conversation between Grimelda and her guru in chapter five after the chariot race."
  • You are tired of scrolling through your document and you want to just go directly to the section on shoe-making so you can add the cool new stuff about suede. Or you've put in a table, or a graphic, and you want to go directly to it to make some changes.
  • You're writing a 680-page document and you just want to read through the main heading titles and make sure that they're in a good order, that you're using parallel grammatical structure, that you're capitalizing correctly, etc.

In Word you might use the Outline view. In OpenOffice Writer, you use the Navigator.

Press F5 and you'll see the Navigator window.

Nav1

First: What you need to do in your document to make sure the Navigator works for you

You must either use the Heading1 through Heading10 styles on the text that is used as your document headings. Or you can apply other styles to your headings and set them up at the right levels; choose Tools > Outline Numbering. (See this entry for more on outline numbering.)

Applying the heading styles

This picture shows how to apply the Heading1-Heading10 styles in a simpler  example, a document about bread.

Navstyles

Modifying how the heading styles look

If you don't like how the Heading1-Heading10 styles look, right-click on any text with the style you don't like applied to it, and choose Edit Paragraph Style. Make your changes in the formatting window that appears and click OK.

Editparastyle

Then: What you can do with the Navigator

You can:

  • View all the headings in your document: just the top levels, just the top and second levels, and on down
  • Jump from one section to another just by double-clicking
  • Jump to other items in the navigator such as tables, bookmarks, or charts, just by double-clicking
  • Turn chapters into sections by demoting and vice versa
  • Easily drag sections to different places in your document to re-order the document: not just chapters but any section that starts with a Heading1-Heading10 style, or with whatever styles you set up under Outline Numbering.

Viewing the Headings

In the Navigator, press F5. You'll see all the headings. The icon labeled Heading Levels Shown lets you see only Heading1s, only Heading1s and Heading2s, etc.

Nav1_2


Click as shown to view the number of heading levels you want.

Nav1b

Jumping from one section to another

I'm currently at the top of the document.

Nav1_2


I double-click the Breweries and Wineries sub-section and bam, that's what's displayed in the document itself.

Nav2

Jump to other objects in the document: tables, bookmarks, etc.

I double-click the Table1 item (I don't name my tables but you can when you choose Insert > Table) and immediately it's displayed.

Nav3_2

Change chapters to sections and vice versa by promoting and demoting heading levels

Let's say I want the Romance section to be less important, a heading level or two down. It's currently assigned the Heading2 style so it's at level 2.

Nav4

I can just click on it, then click the Demote Level icon as many times as needed to move the section to where I want it. I clicked it once so now Romance is at level 3. (And Jazz and other sections below it were moved down, as well.)

Nav4b_2

Ditto for making sections more important; click the Promote Level icon.

Re-order sections in the document

Let's say I want the chapter Getting Here and Getting Around to be earlier in the document, not last. It's a Heading1 and I don't want to change that, but it's now starting on page 22 (look in the bottom left corner) and I want it earlier in the document.

Nav5_2

I click Promote Chapter and it's now earlier in the document. It's at the same level, as you can see by the applied style, but it's now on page 16 as you can see in the lower left corner.

Nav5b

I can do the same thing with lower-level sections. I can take the By Train subsection here, currently before By Car

Nav5c

click Demote Icon, and now it's the last section in the document, not second to last. It's after the By Car section.

Nav5d

[Digg it]


Traininglogo




March 28, 2008

Photoshop Express online, might be a good choice for casual users. (No Linux support yet.)


"Adobe recently released into public beta (ready to go, though, for all intents and purposes) their online Photoshop Express application. A further distillation of Photoshop Elements accessible via a web browser with Adobe’s Air technology installed, Express is no GIMP, but it’s free, available across platforms, and serves the needs of the MySpace set very well."

Be sure to read the terms of use carefully.

Read more...

In OpenOffice mail merge documents, you see the field names like Name onscreen, not the data like Bob. The data appears when you print.

I just wanted to clarify something since I hate to see people thinking they're doing something wrong when they're doing it right.

Here's an example using labels.  This is how it's supposed to look. You won't see the data onscreen, you'll see the field names like first name. When you print, the correct data will appear.

Labels

If you don't know want to print all the data, you can pick the ones you want in this  window. Just choose File > Print, click yes that you want to print a form letter, and then select the records you want in this window. Select the first record, hold down Ctrl and select the next one, and so on.

Labels2

Or specify a range.

Labels3

Then just click OK.


March 27, 2008

Four Table Tips for OpenOffice Writer: Blank line above a table, splitting tables, automatic optimal column width, and joining tables

Tables generally behave as you might expect. They're fairly straightforward and not too troublesome.

But sometimes the features aren't that obvious. So here's a blog on useful stuff you can't easily see, as well as one feature Word users might expect that isn't there, but for which there is a decent alternate route.

Getting a blank line / carriage return at the top of a document when the table is at the top already
Here's your table. Let's say it's, oh, top performers for Amway from each state, or the exciting new political movers and shakers from each state. And it's right at the top of the page, but you want to write an intro paragraph like "Let's welcome the new political movers and shakers from the Midwest!"

Table

Just click in the top left cell
Pressreturn1

and press Return.

Pressreturn2_2

Splitting a Table
This is relatively straightforward, but there are four ways to split it. Here's your table. Note that the first line is bold and centered. The Table Heading paragraph style is applied to that row in the table.

Split1

First, click at the left of the column that you want to have as the first line of the new table.

Choose Table > Split Table.

Split2

Now you have options.

Split3_3

Copy Heading is just what you would expect. The results look like this.

Copyheading_2

Custom Heading Apply Style is useful only if the line you're splitting on is going to be used as a heading. Here, it's pretty silly. It applies the paragraph style from the heading of the table to the top row of the new table. Also the first row is a heading, i.e. it will repeat at the top of the next page if the table goes far enough to continue to the next page.

Customheadingapplystyel

Custom Heading is the same except that it doesn't apply any paragraph style. But the first row of the new table will still repeat on the next page if the table goes long enough, since it's a heading.

No Heading is the simplest approach -- it splits the table and does absolutely nothing else to it.

Automatically adjusting spacing to fit the text

Let's say you've got this table. You probably want to give the far right column a little more width, definitely, and maybe adjust some of the other columns to suit how much content they have.

Even1_2

Select the entire table. The Table toolbar will appear. The icon you want is the Optimize icon. (The icons shown here are for Ubuntu, use your tooltips if necessary on your version of OpenOffice.org.)

Even2

Click and hold down the arrow for the Optimize icon. All of these are useful but you want the far right icon, Optimal Column Width.

Even3

And here's the result.

Even4

Joining Two Tables

Sorry, there's no quick way to do this. Tables are just normal tables in Writer, and so part of the normal text flow. You can't just join text chunks. However, it's not too much work to copy and paste.

You have a table. You then have a blank line or three, then another table. You want them to be one table.

- Copy the second table (leave out the heading rows).
- Create a blank row at the end of the first table.
- Click in the first cell of that blank row.
- Paste
- Delete the second table now that you've pasted it into the end of the first table


Traininglogo




March 24, 2008

Inserting more than one row at a time in OpenOffice.org Calc

Inserting a row in OpenOffice.org Calc is easy. Let's say you've made this schedule and you need another row  because you need more slots for night life.

Insert1_2

Right-click on the row below where you want the new row to appear, and choose Insert Rows.

Insert2

Bam, you get a new row. Now you have two blank ones so if you decide you need even more new rows, you can select two rows, choose Insert Rows again....

Insert3

and then you get two more new blank rows.

Insert4

That's the way I've always done it.

But then I had a brainwave -- you don't have to select blank rows in order to insert rows. That is, if you want to insert three new rows, just select three rows, period, whether they have content in them or not. Then as usual right-click on the row headings and choose Insert Rows.

Goodinsert1

and you get your three new rows, above the rows that you selected.

Goodinsert2

I'm not sure how I got stuck on the idea that you have to select blank rows if you want to insert multiple rows at a time. But you don't. So here's the summary.

If you want to insert multiple rows, just select that number of rows, right-click on the row headings, and choose Insert Rows. Doesn't matter if there's content in the rows that you select;  the content won't be affected by the Insert Rows action.


Traininglogo




March 21, 2008

OpenOffice.org 3.0 feature preview

Take a read.

Plug it on FS Daily
http://www.fsdaily.com/EndUser/OpenOffice_org_3_0s_new_features_an_early_look

Or read
http://www.oooninja.com/2008/03/openofficeorg-30-new-features.html

March 20, 2008

Facebook for readers

It's not open source related, but it does sound cool.

http://www.goodreads.com/

Any way you want it: OpenOffice.org Calc spreadsheet keyboard shortcuts

I get a lot of requests from people switching office suites who want to know how a feature is done in Microsoft Office, compared to how it works in OpenOffice.org.

It usually ends up that the person wants a list of shortcuts. And I say "but you can have any shortcut you want in OpenOffice.org, it's incredibly configurable." I don't really like to give out lists like that because it gives the impression that it's fixed. If someone wants Ctrl 2 to make text double-spaced and they see it's assigned to the Heading2 paragraph style, they might think there's nothing they can do about it.

All this is kind of a meandering introduction to the following general topics:

You can have virtually any shortcuts you want in OpenOffice.org.

There are a zillion  features you don't know about that you can apply shortcuts to.

It's really easy to do. And once you've got it set to your preferences, you can easily give the file to your friends.


You can have virtually any shortcuts you want in OpenOffice.org.
Choose Tools > Customize, and click the Keyboard tab. Those are the current shortcuts. But to change one, just select something in the Category list, something in the Function list, the Keyboard Shortcut of your choice, and click Modify. Bam, you have your new shortcut.  The world is your oyster.

Nextsheet

There are a zillion  features you don't know about that you can apply shortcuts to.
Sooooo many features that aren't on the menus or toolbars, and possibly not on the right-click menus, are in the Keyboard tab.

As mentioned, choose Tools > Customize, Keyboard tab.

Select the first Category, and scroll through the Functions. Look at all that. You can set up any of those to use a keyboard shortcut you want, or you might see something you like that has a keyboard shortcut with it already.

The keyboard shortcuts are different for OpenOffice.org in general, and for Writer, for Calc, for Impress, and for Draw.

Here are just a few functions for Calc. The first screen shot shows that it's Ctrl Page Down to go to the next sheet, and Ctrl Page Up to go to the previous sheet. You can use this as is or change it.

Scroll1

Scroll2

Scroll3

Here are just a few functions for Writer

Scroll4

Scroll5

Scroll6

Here are just a few functions for Draw

Scroll7
Scroll8

Scroll9

It's really easy to do. And once you've got it set to your preferences, you can easily give the file to your friends.

All right. You've chosen Tools > Customize. You've clicked the Keyboard tab. You've scrolled through and found the feature for making line spacing doubled. And in the Shortcut Keys list you find Ctrl 2, the shortcut you want to use. It's already occupied by being assigned to Heading 2. That's fine. Just click Modify and it'll switch.

Linespacing1

Here's what it looks like now, with Ctrl 2 assigned to double-spacing.

Linespacing2

Now let's say you want to share this and any other shortcut configurations you've made with your friends, or all the folks you support in your job as an IT professional.

* Click Save.
* Name the file and click Save.

Save1

Then give the file to someone else and tell them to:

* Choose Tools > Customize, Keyboard tab.
* Click Load
* Find the file and click Open

Load

Want to give this post a plug on FSDaily?



Traininglogo




March 17, 2008

Printing two-sided brochures in OpenOffice.org Writer: easy as pie, if you know a couple tricks about how to make pie

An email conversation with Don revived my interest in brochures.

I've got a template here for a tri-fold brochure. It uses connected frames.  Right-click on the link and choose to save it to your computer if you'd like to look at it.
 

However, what if you want something more normal, just something like this? You want to rotate a letter or A4 piece of paper 90 degrees, and fold it in half.

Example_1

This means some juggling with the page printing order. For the folding to come out right, you need an eight-page brochure to print like this. Half are on one side of the paper and half are on the other.

Example_2_2

You could do this through mental gyrations.  Or you can do it with the OpenOffice.org Writer brochure setting under print options.

Duplex

You just need to do a few things to make it work well.

Step 1: Set up your page normally (portrait) but....

For whatever reason, the brochure printing prints a little short of filling the eight vertical inches appropriately. So for printing on letter size paper sideways, I recommend an 8 1/2 by 13 page size. Choose Format > Page, Page tab and set the size there. I also recommend mirrored setup and a nice big inner margin as shown.

Pagesize

Step 2: Make your content and heading fonts a little bigger  

The whole document will be shrunk when it's turned and printed so I recommend increasing all font sizes about 2 points, possibly more for extra readability.

Step 3: Print using the brochure options and print Landscape (additional details vary depending on your printer)

Choose File > Print. Click Options. Select the Brochure option. Click OK.

Duplex_2

 

In the OpenOffice.org print window, just click Properties and find the option to print Landscape.

Landscape

 

If your printer also lets you print double-sided, select that option too. And you're done.

If your printer doesn't do double-sided, you'll need to do this instead.

Print the brochure in two passes:

A) Choose File > Print and click Options. Set these options to print only half the pages:
Noduplex_1

B) In the print window, click Properties and set up the printer to print  landscape. Print.

C) Then put the pages that you've printed into the printer again, choose File > Print again, and choose these options instead to print the other half of the pages AND to reverse order.

Noduplex2

And of course print Landscape this time too.

Here's a template if you'd like to download it and fiddle with it. Right-click on the link and choose to save it to your computer.

Download the template, with screenshots and directions.

Download the template without screenshots or directions.


Traininglogo




March 14, 2008

Linux Deployments in Schools

Looking at Linux? Here's a list to investigate to help you with planning and your pilot.

http://www.itwire.com/content/view/16984/1141/

(originally found on http://opsamericas.com/?p=627)

And here's another site:

http://opsamericas.com/?p=333

I think an essential component of switching over is to truly understand, through observation, the skillset of your users. A lot of learning is done by rote and thus users look more expert on a familiar platform than they are. Switching over, for a rote user, takes more effort than for someone who understands "General important functions go under the File menu, Format menu probably has stuff not on the toolbar, I should look under Tools for anything techier, never press Return to go to the next line within a paragraph," etc.

March 13, 2008

Switching to OpenOffice.org: specific step-by-step tips to customize and make OpenOffice.org your own

I wrote this article for my friend Russell over at FanaticAttack.  Lots of comments (I clearly need to do better at publicizing my own blog! ;>  ).  Check it out; it's definitely one of my more explicit, step-by-step guides.

Excerpt....

Here are some setup tips to help you get OpenOffice.org humming.

Automatic Settings

Some of the default settings aren’t quite what I would recommend, but it’s very easy to make the changes.

First, choose Tools > AutoCorrect.

In the Word Completion tab, turn off word completion if it bugs you by unmarking the Enable Word Completion option. If you like it but want to change what key you use to accept the suggestion, you can do that too.

AutoCorrect

General Settings

A window you want to get to know: choose Tools > Options. I strongly recommend that you go through every option in that window since many are very useful. To get the options for text documents you need to have a Writer document open first; to get the options for spreadsheets you need a Calc document open first, and so on.

  • I like to choose Tools > Options > OpenOffice.org > View. Select Large as the icon size.
  • You might also want to turn on backups. Choose Tools > Options > Load/Save > General and select Always Create Backup Copy. The backups are created at the location specified for backups under Tools > Options > OpenOffice.org > Paths.
  • If you find the color selection in OpenOffice.org lacking, you can create your own under Tools > Options > OpenOffice.org > Colors.

Printing

Writer printing: Tools > Options > OpenOffice.org Writer, Print: you might want to turn off the option for printing automatically inserted blank pages unless you’re heavy into the first page of a new section starting on the right-hand page.

Calc printing: Tools > Options > OpenOffice.org Calc, Print: it’s best to turn off both options here. If you want to select two or more sheets to print when you’re ready to print, just select one sheet tab, then hold down Ctrl and click on each additional sheet you want to print.

Print Calc

Read more....



Traininglogo




March 12, 2008

Creating Booklets from PDFs

So you can make PDFs from OpenOffice.org documents. Excellent. What if you've got a PDF already that you didn't create, and you want it in a format like this?

Booklet

Stephen Abrams linked to from David Rothman  writes about BookletCreator, a free tool that lets you  create booklets from PDF files. It reorders pages so that after printing and folding the pages you get a small book.

Btw, I've got an upcoming blog on how to create booklets from Writer documents. It's scheduled down the line a week or two.


Traininglogo




March 11, 2008

Norwegian translation of an article on transitioning to Openoffice.org

Thanks to Rosetta Media  for getting the translation done.

http://www.rosetta.no/demofiler/mykovergang.pdf

http://www.rosetta.no/rosetta/kprog.html

My parents will be so proud! (They love all things Norwegian. We all have tshirts about rommegrot.)

Expand the Editing Capabilities of OpenOffice with XSLT

Here's something I don't cover at all, so I'm glad to see this tutorial from Jonathan Levin.

"This tutorial shows you how to use OpenOffice's import/export filters to open your XML data as though it's just a plain document. From there, users can edit the document much more naturally and then save it back to its native format. You can also use this feature to easily turn your documents into XML data. "

http://www.devx.com/ibm/Article/37361?trk=DXRSS_LATEST


Traininglogo




March 10, 2008

Is anyone writing extensions for OpenOffice.org envelopes?

We've got the extension library full of great stuff. Notably, lately, the fabulous pagination extension that makes "no page number on first page" so easy.

Envelopes are something else that I get a lot of questions on.

Is anyone out there working on making envelopes easier with a nice extension? I've been told that the approach to envelopes used in Corel WordPerfect is a good, simple approach.

If there's something out there already, or if anyone's going to write something, let me know when it's done and I'll shout it from the virtual rooftops!

 



Traininglogo




You want this extension for yourself and everyone you know who uses OpenOffice Writer: the easy "no page number on first page" option and much, much more.

Charles Brunet, thank you. The people who created the extension capability for OpenOffice.org, thank you.

I've been longing, for years, for a simple "no page number on first page" checkbox.  This is great. I'm only sorry I didn't see it til today.

Pag1

Everybody, now,