Friday Jun 12, 2009

Help for the OpenOffice.org office suite is available in many ways. Every user who seeks some help can find a method that fits best.

  • First, there is the classical installed Help. You know, just press the F1 key, or click any of the Help buttons.

    This once was called "Online Help" because it was available immediately, without any waiting time. And this is still true. By now the word "online" changed its meaning. It is used now for something that is available on the web or by e-mail. And OpenOffice.org offers a lot of online help, too.

  • The web based Help has an overview page at documentation.openoffice.org. From here, links lead to the special pages, as FAQ, How-To, PDF manuals, and more. Many links go to the Wiki pages, where you can read, edit and write helpful information.

  • The Wiki page at http://wiki.services.openoffice.org/wiki/Documentation presents links to the following helpful sections:

    • User Guides for OpenOffice.org 3

    • User Guides for OpenOffice.org 2

    • Frequently Asked Questions

    • SysAdmin/Developer Guides

    • Reference Lists

    • How Tos

    • Tutorials and Screencasts

  • Another way to ask for Help is by e-mail. The mailing lists are "run" by other OpenOffice.org users who voluntarily spend their time and energy to answer all questions. So please ask politely and try to give all necessary information, for example, which version of OpenOffice.org you are using, and on which operation system.

  • If you want to ask your question on a web forum, where other users of the software will give their answers, browse to http://user.services.openoffice.org/en/forum/

  • And don't forget to read the pages of all the enthusiastic OpenOffice.org users on the web, who provide tutorials, how-to instructions, and much more. For example, the pages of Solveig Haugland (link in the right column of this blog) are much recommended.

  • More Help is available, PDF files and printed books, tutorials, videos. Use your favorite search engine, include your search words and the word OpenOffice.org, to find the answers.

We always want to learn how we can improve the Help. If you have ideas, please subscribe to the documentation mail list at dev@documentation.openoffice.org and discuss your ideas.



Wednesday Apr 15, 2009

Once upon a time there were some little office user. Using office all day long. Exchanging files with other little office users. In those days, only one office program was known, so sharing the files was a real no-brainer.

They all lived in a small village in the middle of Happyland. Then suddenly, from one day to the other, the sharing of files got more complicated. Some little office users had updated versions of the software, some not. Some could afford more expensive computers with yet another version of the software. Now sharing files got complicated, and for some little office users, almost impossible. When they complained, they only were told to pay more money for ever more updates. Buy new software that promised to make their own documents compliant to what they had been before. The little office users grumbled a bit, but as they did not know better, they gave in.

Until:-- one day a strong wind blew a fairy from the nearby open land into their village. It was a free fairy, and she had a magic wand that made the sound of foss, foss, fosssss, whenever she waved the wand.

Well, you kids all know for sure what a kind of free fairy that was. The villagers of Happyland gathered together and listened to the fairy's words. They learned about free and open software, and they wondered how they could have ever lived without. So this fairy story about software ends here.

Wait for more fairies to come.

And they lived happily ever after.

Friday Mar 27, 2009

Use the Mouse to Zoom and Scroll

Most users of OpenOffice.org use a mouse device with a scroll wheel.

  • You can turn this scroll wheel up and down to scroll the OpenOffice.org document window up and down.

    But there is more to the scroll wheel than vertically scrolling.

  • Hold down the Shift key while turning the scroll wheel, and you will scroll horizontally through your document, from right to left and back.

  • Hold down the Ctrl key while turning the scroll wheel to zoom the document window in and out.

The scroll wheel also acts as a third or middle mouse button. In OpenOffice.org, you can select what should happen when you press the middle mouse button:

  • Choose Tools - Options - OpenOffice.org - View. Look at the Middle mouse button drop-down list.

You can choose from the three options: No function, Automatic scrolling, Paste clipboard.

When Automatic scrolling is enabled, you click the middle mouse button in a document to see a special icon. This icon looks like a compass rose with four directions. When you now move the mouse, the document scrolls in the same direction. Click any mouse button to exit this scrolling mode.

When Paste clipboard is enabled, a middle mouse click pastes the contents of the " middle mouse clipboard". This is a function that Solaris and Linux users know well, while it may be new to Windows users, where this X Window selection clipboard does not exist. It is a clipboard that always holds the text that was selected last, no matter in which window. Once that last selection gets cleared, the clipboard is cleared, too. This special clipboard lives independently from the "normal" clipboard that you use from the Edit menu or by Ctrl+C, Ctrl+V, and Ctrl+X.

All these functions require a mouse device and software that supports these functions. As these functions are not OpenOffice.org functions, you will not see a description in the OpenOffice.org Help.


Friday Dec 12, 2008

Some interesting facts about the success of OpenOffice.org and the OOo documentation teams.


Tuesday Nov 25, 2008

This is the OpenOffice.org Help Tips 'n' Tricks Blog. You want to know the main tip and trick how you can get help in OOo? The answer is the F1 key. Help is already installed together with the software suite.

But there are many other ways to get help online. The main online Help portal page is located on the OOo Wiki. The Wiki has the advantage that every user can easily add information to the online Help contents. Another Help portal exists as part of the http://documentation.openoffice.org  project. At that page it is not as easy to change contents and links, however, so it may be a little bit outdated from time to time. That's the difference between last century web pages and Web 2.0 pages.

So let's have a look at the Wiki. Browse to http://wiki.services.openoffice.org/wiki/Documentation to see what's available.

Authors from Sun and from the OOo community are constantly working to improve the Help contents of the Wiki. And the Wiki is a place with many visitors. In October 2008 there have been 360.000 page views for the documentation section of the OOo Wiki, and the numbers are constantly growing.

Have a look at the FAQ pages at http://wiki.services.openoffice.org/wiki/Documentation/FAQ - click the links in the FAQ box. These pages try to answer the most frequently asked questions. The questions and answers that get clicked most often are positioned at the top. So you can easily see where the users really need additional information.

On every FAQ topic page there is a text entry box, where any user can add a pair of question and answer texts to further improve the online Help contents.

Some users don't want to scan through canned answers but prefer posting to mailing lists or in an online forum. Of course these are also available:

The OpenOffice.org Community Forum is located at http://user.services.openoffice.org/en/forum/

A list of available mailing lists can be found at http://www.openoffice.org/mail_list.html

Friday Oct 24, 2008

You want some more fun in your life? May be even get closer to the meaning of life? Working together with other volunteers on community projects may be the answer.

This morning the German TV showed a feature about the fans of a football ("soccer" to some of you) club called Union Berlin. That club has a stadium that needs some repair works. That club doesn't have much money, but a whole bunch of enthusiastic supporters. So the fans decided to help their club: http://www.fc-union-berlin.de/default.php?content=baugalerie And they help in different ways, as construction workers, drivers, or providing sandwiches, and it's an ongoing effort for more than 100 days now.

We learn this: If you think that something needs to be done and it is right to do it, then just do it. It works. 

It's easy to cast some positive light now on the OpenOffice.org community efforts. 

In many countries the OOo community gathers together to meet each other. Community members talk to each other, plan some activities, have fun. Sometimes a congress or fair is the reason to meet, sometimes there is a big (launch) party.

Of course, the next big event is the OpenOffice.org Convention 2008. It will be held in Beijing, China, from November 5th to 7th. Come to meet, discuss, talk and listen to other friends of OOo. The documentation project will be there, too.

Thursday Oct 23, 2008

Up to and including OOo 2, you can install new dictionaries for spellchecking, hyphenation and thesaurus, by opening a wizard document from the Files > Wizards menu.

In OpenOffice.org 3, dictionaries are installed as extensions.

  1. To find new dictionaries for OOo 3, choose Tools > Language > More Dictionaries Online. This opens your default web browser showing the dictionaries page.
  2. Select the dictionary you want and click the Get It button.
  3. Your browser displays a dialog where you can choose either to open the *.oxt file with OOo 3, or to save the file on your drive.
  4. Choose to open the file with OOo and click OK.
  5. This opens the Extension Manager and asks for your permission to install the dictionary. You might need to click the Extension Manager button in the taskbar to see this window. Click OK.
  6. Click Close to close the Extension Manager. Now it might be necessary to restart OOo 3, including to exit the Quickstarter, before you see the new dictionary.
You can see the installed dictionaries in Tools > Options > Language Settings > Writing Aids.

Some more information about installing dictionaries for OOo 2 and 3 is here: http://extensions.services.openoffice.org/resources/user/howto_install.

The OOo Wiki has some dictionary information that may be important for users of OOo versions that are part of Linux distributions.

How about a grammar checker? Check the extensions web page for availability of a grammar checker in your language.

Thursday Sep 25, 2008

This text is written in English language, using a Western text input method. The text is written horizontally from left to right. This seems to be so normal. It seems to be the only right way to write text. Or not?

No. I suppose that a majority of the educated inhabitants of this planet do not write in English, and they do not use any of the Western scripts. Instead, they may be used to write in Chinese, Japanese, or Korean glyphs (CJK), or in other writing systems that are called "complex text layout languages" (CTL) by the "normal text layout" users.

Let's have a short look into Wikipedia: There are different writing systems: http://en.wikipedia.org/wiki/Writing_system

There are many of them: http://en.wikipedia.org/wiki/List_of_writing_systems

You can easily get lost just by browsing those Wikipedia topics and the direct links.

So, back to OpenOffice.org. I once blogged about the many languages of OOo. In the meantime, the OOo web page that lists all the OOo languages moved to the Wiki: http://wiki.services.openoffice.org/wiki/Languages

Most of the current developers of OOo are living and working in countries where English language and Western script is not seen as exotic. The download numbers show that most of the current users also live there. But we do not want to exclude anyone from using OOo just because of other languages.

There is quite a long way to go for OOo to really fit the needs of all possible users in all countries of the world. The good news is that we are on our way.

The native language projects cannot be praised enough. Many volunteers offer so many hours of work and enthusiasm. Sometimes a whole language project seems to be run by only one person - and successfully!

Any user can contribute to improving their version of OOo over time. Submit issues or help resolving the issues. Provide documentation in your language. Currently, a spotlight is directed at the Arabic versions, see http://wiki.services.openoffice.org/wiki/Arabization_efforts for a list of work in progress.

The real problems using alien versions of OOo are often unknown to the developers until they are reported by alien users. For example, OOo can be used to write text from right to left since many years. But only now we know that it can be a problem to embed the numbers that can be seen on Egypt car plates (they are called Western Arabic numbers) into Arabic text. The formatting automatism tends to embed those numbers as those 1234567890 numbers that are often called Arabic numbers, without the "Western". This design flaw will be fixed soon.

Another issue that came to our knowledge is that after changing the locale for your OOo Calc, you would also need to change the date and time formatting strings. For example, German users would like to use TT.MM.JJJJ (Tag, Monat, Jahr) as a format string instead of MM.DD.YYYY (Month, Day, Year) when they format the output of a Calc date function. This was possible all the time, but it was never documented because no one complained until now. The localized help would give the localized formatting code, but never a list of all the codes for all locales. (You can find the raw data at http://l10n.openoffice.org/source/browse/l10n/i18npool/source/localedata/data/  )

So we all can and will learn new things every day with OOo.


Wednesday Sep 17, 2008

Sometimes, when you look into the OOo application help, the right side help page is shown with less than 100 percent zoom. This makes reading the help text a difficult task.

Fortunately, it is possible to get back the right view of the help page, although this requires several steps:

1. Close the Help viewer.

2. Choose File - New - HTML Document.

    Now you are in Writer/Web. You can check this in the View menu, which contains now a HTML Source command.

3. Choose View - Zoom. Set the zoom factor to at least 100 percent or higher.

4. Press F1 to open the Help Viewer.

The Help viewer uses the same settings that you define for Writer/Web (html) documents.


Thursday Jul 24, 2008

Some thoughts about using the StarOffice and OpenOffice.org software at schools and universities.

Many students and teachers already use OOo for reports, calculations, presentations, with or without additional extensions.

Some education related extensions on the extensions.services.openoffice.org web site:

  • Writer's Tools with Q and A game,
  • OpenCards extension creates a flashcard learning interface from any presentation file.

Parents are not required to buy any office suites for their kids at school. OOo is free software. StarOffice is free for educational use (see links below). Both software suites can open and save in Microsoft Office 97/2000 formats, if any school policy should require files in that old proprietary format. Both software suites use the ODF format, an open standard that allows free and open access to the documents without any dependency on any commercial company.

What students can do to improve the OOo software: Develop templates and sample documents, graphics for the Gallery, tutorials, extensions.

There is much more to this that can be done in an educational environment. The OOo community is a wide and open continent full of adventures and chances. The OOo community can offer a range of learning opportunities to groups of students with their teachers. And students can earn merits when they actively can help to improve the software, or when they give their feedback to the community.

Most projects are open for kids (if allowed by their parents), for example doing bug hunting parties, translation summer camps, software contests. Some meetings are in real world, some are virtual or by IRC or web based. See http://blogs.sun.com/GullFOSS/tags/events where you can read this final comment:

All people involved did willingly share their experience with all others. So beside the "numbers", we "produced" knowledge and fun for all involved people.

Is there a better outcome of a team effort than "numbers, fun and valuable knowledge"? - I don’t think so.

All development, marketing, documentation, and translation/internationalization efforts for the OOo projects are published at places like openoffice.org, the wiki at wiki.services.openoffice.org, and the forum at user.services.openoffice.org/en/forum/. This is a great chance for young persons to learn how such a big project is organized in a democratic way, and how to take an active role in this open and worldwide project. Every person, young or old, can find some place inside OOo where the contribution and dedication really counts. Every one can contribute work that will help improve the OOo project, and that will look good on the CV when that person later applies for a job in the industry.

More links:

Sun StarOffice in Education

http://www.sun.com/products-n-solutions/edu/solutions/staroffice.html


Sun in the Education Environment

http://www.sun.com/solutions/landing/industry/education.xml


OOo Education Project

http://education.openoffice.org/


Wiki as a portal to work in the OOo Education project

http://wiki.services.openoffice.org/wiki/Education_Project

Friday Jun 20, 2008

Developing software (or hardware) is more rewarding if there are many potential users, now and in the future.

It might be quite nice to develop a new light bulb that is perfectly suited for the homes of Phil and his family in Punxsutawney. But it is much better to develop a new light bulb that can illuminate all homes of the world. A developer would get more help from others on this way, and there would be a wider choice of programming tools. Not to speak of any financial rewards.

You may argue that this is not possible because of the different light bulb sockets, voltages, and other technical and legal restrictions. See? That is why we need open standards that are the same wherever possible. Even for common supplies like electricity or the dimensions of nuts and bolts it is not a simple task to agree on an open standard.

  • The USA agreed to use the metric system in 1866, still it is not in common public use.

  • Some efforts were successful, however. September 3rd, 1967, Sweden changed the whole car traffic from left side to right side driving. That was relatively easy back in those days. Would be more difficult today. See the huge street constructions at the former Chinese/Macau border, where traffic has to change from one side to the other without crashing into each other.

Now, back to software. Is it easy to change software standards, once that people agree something should be changed? Not really. Even when people who use expensive, suppressive, proprietary de facto standards are given the chance to switch to free alternatives (free as in beer, and free as in unrestricted use), they may decide to stick to what they have.

You can take a horse to the water but you can't make him drink. But you can try to make the water so refreshing and delicious that no horse can resist.

Enter ODF. The OpenDocument Format is an approved international standard, like the meter or the second. That means that ODF based software solutions that you develop today will be valid and useful everywhere on the world, now and forever. It is not necessary to waste your time on developing exceptions for one brand of browsers or another brand of operating systems.

Imagine how a world with only open standards will look. You cannot imagine? Neither can I. But there are first steps visible everywhere.

  • Extensions for OpenOffice.org and StarOffice exist for only a short time now. And already more than a hundred extensions were developed, almost all of them for free and fair use.

  • The hybrid file format that is available within the Sun PDF Import extension is an example of an ingenious merger of an open standard and a publicly released de facto standard. The hybrid file format contains the same document in ODF and PDF together in one .pdf file. Users of OpenOffice.org can open this hybrid file and edit the contents like any other Writer, Calc, Draw, or Impress file, then export back to the hybrid format. Users of other PDF reader programs can open the same .pdf file and see the PDF, as they expect. (Requires at least OOo 3 Beta)

  • Or have a look at this video by one of the StarOffice/OpenOffice.org developers which shows how to use the WebDAV support of OpenOffice.org to use Writer and Calc as editors for web sites. Perfect web sites, created and edited without the need to learn html.

By the way, googling for "the beauty of open standards", I found a nice blog about open standards by David A. Wheeler that is worth reading.

Friday Jun 13, 2008

The intended use of PDF

You certainly know that OpenOffice.org can export your documents to Adobe's Portable Document Format (PDF). An introduction to this format can be found on the Wikipedia: http://en.wikipedia.org/wiki/Portable_Document_Format

This format was designed as an electronic equivalent of a page printed on paper. That is, it was not designed to be a format that can be edited.

Some users still want to edit a PDF file for some reasons. Workarounds were developed to enable editing of PDF files. For example, you can print the PDF document, then scan the printed page using an OCR program, edit the results, and generate a new PDF file from them. Currently, many OCR programs can open PDF files directly, thus saving the extra steps of using a printer and a scanner.

To export the current document as PDF

  1. Choose File – Export as PDF.

  2. In the PDF Options dialog box, select the PDF export options, then click Export.

    The application help explains the options that you can select on the five different tab pages. 

  3. In the Export dialog box, select a path and type a name for the PDF file. Click Export.

If you later want to export as PDF again using the same PDF options, you can click the Export Directly As PDF icon on the Standard toolbar. This command does not display the PDF Options dialog box.

Editing PDF files

Starting with OpenOffice.org 3.0, a new extension can be used to import a PDF file for editing. This extension is still in its early stage of development, so do not expect a perfect roundtrip from PDF to ODF and back to PDF. However, the extension can be used for first tests right now.

Currently you need a recent developer version of OOo 3.0, which is available from http://download.openoffice.org/680/ or other web sites. Keep in mind that this is not a software to be used in productive environments, it is for experimental testing only.

Once you have installed the OOo 3.0 software, you can install the PDF Import extension. Download the extension from http://extensions.services.openoffice.org/project/pdfimport

To import a PDF file to OpenOffice.org 3

  1. Choose File – Open.

  2. Select the PDF file and click Open.

    You may set the file type to “PDF” to shorten the list of files, or enter *.pdf into the file name field to only select from files with that extension.

In the current state of development, the PDF file opens in OpenOffice.org Draw. Each page of the PDF file is shown on a page of the Draw document. You can double-click the text boxes and edit the text, or you can move the text boxes and the images, or use any of the Draw commands and icons.

To save a document as PDF file in OOo 3

When you are ready with editing the file, you can save the document.

A click on the Save icon will show the Save As dialog box, where you can enter a name for the new Draw document that you are currently editing. This creates an ODG file but not a new PDF file. You will get a PDF file by exporting as PDF, like before:

  1. To create a new PDF file, choose File – Export As PDF.

  2. In the PDF Options dialog box, you may want to enable the Create Hybrid File checkbox (see below).

  3. Click Export.

  4. You can enter a new name for the edited PDF document, or keep the old name to overwrite the previous document.

The ODF-PDF hybrid file 

Once you have installed the PDF Import extension for OOo 3, the PDF Options dialog shows a new checkbox on the General tab page: Create Hybrid File.

A hybrid file is a PDF file that contains the document in both formats, ODF and PDF. Most PDF viewer software will ignore the ODF bits and show the hybrid file as a normal PDF file. But in OOo 3, the hybrid file will open in the same module of OOo that created the hybrid file: Writer, Calc, Impress, or Draw. So the OOo 3 user can edit the original layout of the hybrid file, in the highest possible quality without any conversion losses, and then export as PDF again.

I bet that soon there will be many hybrid ODF-PDF files on the Web. These files enable users of OpenOffice.org 3 to edit the contents without problems. Of course you can choose to disable the Create Hybrid File checkbox, thus creating a normal PDF file without the additional ODF bits.

You can browse to the OOoNinja page for a nice report about this new feature:

http://www.oooninja.com/2008/06/pdf-import-hybrid-odf-pdfs-extension-30.html




Tuesday Jun 03, 2008

LinuxTag in Berlin this year was an interesting event, and well attended.  The OpenOffice.org Documentation Project did a presentation on Friday (30 May) to introduce the Documentation Project to those that have not really heard much about us, and to encourage people to participate.  Some highlights of the presentation:

  • The Documentation project objectives are to:
    • Make it easy for users to access documentation.
    • Make sure the content is targeted.
    • Make sure that the documentation is up to date and technically accurate.
  • The Application help is currently more than 2300 XML files containing over 400,000 words and localized in around 100 languages.
  • The Documentation Wiki is getting around 500,000 page views per month (and this number is increasing each month), and makes up 20% of the total OpenOffice.org Wiki traffic.
  • Challenges to using the Wiki include, a lack structure, a lack of a defined workflow, and no established editorial process.
  • New things are coming to the Wiki such as the ability to build PDF books based on Wiki pages, and maybe even ODT documents as well.

So, what can the OpenOffice.org community in general do to help out the Documentation Project?   Contribute to the Wiki documentation!  This can be anything from adding new articles or examples,  to spelling corrections.  The great thing about the documentation being in the Wiki is that anyone can make a correction or add new information, and that correction or new information is seen immediately.  If you see a problem in a document, but do not have the solution, use the Wiki Discussion page to enter your comment, or raise a question on the dev@documentation.openoffice.org  mailing list. 

Friday Apr 04, 2008

A conversation

A: Look here, darling, I've got something to tell you right now, and it is of highest priority.

B: You make me curious. Continue.

A: I've found some reasons to feel some affection towards you.

B: Can you be more precise in this statement, please?

A: I've found four reasons to feel an affection towards you increased up to 100 percent.

B: Go ahead ...

A: These are the reasons, in order from top to bottom:

  1. You look so beautiful.
  2. You give me reason to live.
  3. I get excited when I think of you.
  4. We can exchange more than words.

B: This is a numbered list, shouldn't it be a bullet list?

A: You're right as always, darling. I love the way you edit my words right out of my mouth.

B: Thank you for saying that. Al least you got the punctuation right. But you could have read the Sun Editorial Style Guide, Chapter 3, and follow that advice.

A: You're welcome, darling - better I wake up now.


This can happen to a tech writer when mixing up the following:

  • reviewing a newly written Sun book all day long
  • reading High Fidelity by Nick Hornby late at night
  • trying to live a personal life, as much as possible, if possible at all

Tuesday Mar 18, 2008

Sometimes you want to send your current OpenOffice.org document by e-mail. You have several options how to start this task easy and fast from within OOo.

Sending e-mail to another happy OOo user

If you know that the recipient also uses OpenOffice.org (and all your friends should do so by now), you just click the “Document as E-mail” icon on the Standard toolbar. This icon looks like a mail envelope. Alternatively you can choose “File – Send – Document as E-mail”.

This opens your default mail program with a “send new mail” window. The current OOo document is automatically saved in its current state as a temporary file, and this temporary file is already appended as an attachment to your e-mail window. The OpenDocument format (ODF) is used for the attached file, which has several advantages. First, it is open, which means that your recipient will be able to read the document by using open software. Then, the file format uses the ZIP compression by default, which means a small file size and fast transmission.

Just fill in the recipient's address, a subject line, and some additional text as a mail body, if you like so. Then click the Send button.

Sending e-mail to a poor Microsoft Office only user

If you suspect that the recipient may not be able to read open standard documents, you can use the Microsoft Office format for the attachment. Of course, this does not mean that you must use that old format yourself. You can easily create a snapshot of the current state of your current document and send that temporary file by e-mail. Then continue working on your current OOo document as normal.

To send the current text document as a Microsoft Word file, choose “File – Send – E-mail as Microsoft Word”. That's all to do. Again, your default mail program will open, and this time a Word file is attached.

If you are working on a Calc spreadsheet, you can send this as an Excel file. Your current Impress presentation can be sent easily as a PowerPoint file. I'm sorry, but no Microsoft Office equivalent exists for the wonderful, multi page, multi layer OOo Draw line art application.

By the way, Thunderbird is a good e-mail program, and its Lightning extension keeps track of your events and tasks. Both are free and open software, too.

This blog copyright 2009 by fpe