Slashdot Mirror


Special Edition Using Star Office 6.0

rjnagle writes "I got my cubicle colleague interested in OpenOffice.org when I said, "Here's something that can convert your Word files to PDF ... for free!" By now people hip to the open source concept use OpenOffice.org for everyday applications, yet MS Office is still the predominant application in the home and workplace. Many educated people have still not heard of it. Why?" Read on for Nagle's four-part answer to that question, and his (lengthy) review of Michael Koch's Special Edition Using Star Office 6.0 -- the content applies to StarOffice's free cousin OpenOffice.org as well. Special Edition Using Star Office 6.0 author Michael Koch pages 1078 + index publisher Que rating quality: 5 stars; usability: 4 stars; weight: 1 star reviewer Robert Nagle ISBN 0789728338 summary Great for easing the transition to Openoffice/Staroffice.

First, PC makers rarely have financial inducements to preinstall open source applications, especially when it eats into their upsell margins. Second, people have a misconception that documents produced in MS Office can only be read by MS Office (a fact which leads Richard Stallman to call for an end to all Microsoft Word attachments ). Third, subsidized prices and the wide availability of instructional material ensure that teachers use these commercial products for class and give assignments requiring them. Finally, consumers switching to an open source product need confidence that the open source application has equivalent functionality and adequate documentation to reduce the learning curve.

Fortunately, a first-class user guide on OpenOffice.org/StarOffice has been written, and that book is Michael Koch's Special Edition Using StarOffice 6.0. This book, actually a second edition, covers the new version and gives fuller treatment to StarOffice writer and the HTML editor. Despite the use of "StarOffice" in the title, this book actually covers both StarOffice and OpenOffice.org in depth.

An an aside, let me compliment Que editions for the legibility and usability of layout. (Que also produced the excellent Ed Bott's Special Edition Using Microsoft Office XP). Nice readable texts, lots of boxes, tips and cautions. Every chapter finishes with a helpful troubleshooting section.

Two immediate reactions: 1) Gosh, I didn't know OpenOffice/StarOffice could do all that! I was pleasantly surprised, for example, to learn the number of graphic capabilities the program has. 2) This book covers functionality in considerable depth, with enough content to satisfy the newbie as well as the advanced user. In addition to documenting the office software, the book also includes reference sections on StarOffice Basic, using data sources, building forms and macros. It also includes a chapter on Adabas, the database that comes as part of the StarOffice package (but not with OpenOffice.org).

Koch benefits from the fact that users already start with a good conceptual framework of what MS Office products are supposed to do. The biggest conceptual challenge in moving from MS Office to Star/OpenOffice is getting used to the idea of applying styles to text instead of just clicking on an icon for formatting. MS Office actually has terrific styling capabilities (and a usable interface for managing styles),but Microsoft's friendly GUI discourages users from thinking about document structure. Contrast that to OpenOffice.org, which nudges the user more firmly towards styles. Managing the different layers of styles in OpenOffice.org can be tricky and confusing, so Koch spends a considerable amount of time and space on that. Another chapter on sharing and exchanging information with MS Office users goes into exquisite detail about compatibility and formatting losses when converting documents, as well as the StarOffice XML file format.

Cordelia of Buffy the Vampire Slayer once said, "There are books about computers? Isn't that the point of computers, to replace books?" Perhaps I am just cheap, but when evaluating a user guide, I often ask whether the online help isn't good enough. Or whether newgroups/websites/forums are adequate. Or whether the user interface is intuitive or allows you to discover a solution by just playing around. Dozens of heavy thousand-page books clutter my apartment, leading me to wonder whether the convenience of a gigantic dead-tree reference guide outweighs the increase in clutter. Every time I move to another apartment, I keep lugging those gigantic SQL and C++ books I haven't consulted for years, but feel compelled to keep around. (Contrast that with the very portable and handy Oreilly's Linux Server Hacks: 100 Industrial-Strength Tips and Tools, (reviewed on Slashdot), which covers most sysadmin tasks AND can be stashed in a backpack without causing whiplash).

For the last two months (in which I used OpenOffice.org thoroughly), I performed a little experiment. Where was the best place to find answers to my OpenOffice.org questions? I tried consulting the online help, then the book, then the newsgroups and openoffice websites. Here are the results:

  1. Adding page numbers. The book had the best information, though what do you look under in the index? I eventually found it under "Numbers, Writer" (?!). Online help was useless. (The answer is to insert a footer and then insert a page number field in the footer).
  2. I just created a hyperlink in the HTML editor. But the underlined style is bleeding to the text after the link. How do I stop that? Neither the book nor online help provided the answer, although the newsgroup did after 24 hours. (The answer is to press the End key or to select Format >> Default)
  3. How do I create an HTML style with the stylist which specifies the background color of a table cell? (No answer from anywhere, although Koch admits that that the StarOffice HTML editor is "temperamental").
  4. While drawing a flowchart on the Draw program, how do I save the entire image as a jpeg and not just the highlighted part? (By grouping the components together, the book helpfully advises. The online help offers nothing).
  5. On a spreadsheet, what is the keyboard shortcut for bringing the cursor back to the left column? (Keyboard shortcuts are easy to find in the book. Couldn't find it in the online help).

Generally, the book had the most reliable and in-depth information. That was especially helpful when trying to perform a complex action (like creating a table of contents). But the majority of my inquiries had to do with using the interface, not functionality. Often the sheer size of the book made daunting the simple task of finding a function on a dialog or a keyboard shortcut.

That is the paradox of super-sized application manuals. Surely one doesn't read them from cover to cover. But after an application reaches a certain level of complexity, the software interface is no longer intuitive, and you pretty much need a book just to find things in the interface. As one who does technical writing, it may sound funny to say, but often my favorite thing about these super-size manuals are the screenshots. I can't tell you how many times I've browsed through a book and come across a dialog box I never knew existed. On the other hand, when application manuals reach a certain size, navigating through "book interfaces" becomes almost as difficult as navigating through the software interface or help system.

Online help is good when you know what you're looking for (i.e., when you have a specific search term to look for). Books are good when you don't know what you're looking for. With books, the reader can flip through pages in the general vicinity of a topic and randomly stumble upon the right information. Books allow the user to bypass the outlined hierarchy of online help and learn the appropriate terminology for describing the task (which then makes it easier to find things in the online help).

A recent visit to a technical bookstore and a large chain bookstores showed no books on the shelf for StarOffice, but dozens of books on Microsoft Office, That is too bad, because Using StarOffice 6.0 provides much-needed in-depth coverage on an application whose user base will grow as tight budgets cause companies and public sector agencies to examine open source alternatives.

* PDF conversion (as well as docbook and Flash) export are available on the OpenOffice.org 1.1 Beta 2 build.

Other OpenOffice.org Resources:

Kaaredyret has the best English language OpenOffice links page . ooodocs.org has a lively Forum for OO users. Or if you want, you can look at a PDF of the official Staroffice Documentation (400 pages)

ROBERT NAGLE (aka idiotprogrammer )is a technical writer, trainer who doesn't think that open source documentation sucks . He works for Texas Instruments in Houston, Texas. You can purchase the Special Edition Using StarOffice 6.0 from bn.com. Slashdot welcomes readers' book reviews -- to see your own review here, read the book review guidelines, then visit the submission page.

21 of 433 comments (clear)

  1. Easy by Anonymous Coward · · Score: 3, Interesting

    1. Get Star Office.
    2. Open your old MS Office files, see they're all screwed up.
    3. Finally get tired of the sllllloooooowwwwwww buggy office suite that makes it difficult to even put a stupid picture and resize it easily on a page, and go buy MS Office.

    I've tried, I really have. Have since 5.x days, it still sucks.

  2. StarOffice+Education by BJZQ8 · · Score: 4, Interesting

    I will say that in my experience StarOffice does mangle a good percentage of Word files...but the plain-jane files that high school students make are usually done just fine. I'm in the process of piloting about 25 machines with SO instead of Office. We'll see what the kids and teachers think...

  3. Does OO print better than Word? by OECD · · Score: 4, Interesting

    The main problem (from a print shop's perspective) with Word is that it is printer dependent. People compose a document, print it out on their inkjet and expect it to print out exactly the same on any other printer. (It almost never does.)

    Is OO any better at this? Or does it mimic this "feature" for compatibility?

    --
    One man's -1 Flamebait is another man's +5 Funny.
    1. Re:Does OO print better than Word? by ortholattice · · Score: 2, Interesting
      So, Word is smart enough to do WYSIWYG (on your printer). Why is this a problem? Crappier apps will scrunch the fonts or have lines running off the margins.

      The problem is that it can make collaboration impossible. A few years ago we emailed a 40-page .doc to a client to review a detailed spec proposal. We had a phone conference set up with a bunch of people, and some peoples' docs were 39 pages long, others 42 pages. It became so hopelessly confusing trying to figure out where in the document people were talking about that we cancelled the meeting until a physical copy could be faxed to everyone.

      Now we would send out pdf instead of fax, but I think you can understand my point. Actually pdf is kind of nice - sometimes I secretly use LaTeX if I'm going to be the only maintainer, and people always comment on how polished it looks. No one's ever said that about my Word docs, although I admit I'm probably not the most proficient Word expert.

  4. I used OO for a big project by Lord+Ender · · Score: 4, Interesting

    We used OOo to write a 1,000+ page software documentation. It worked very well, except for a few bugs that caused crashes or being unable to edit tables at the tops of pages. But that was in the 1.0.1 days. I think these bugs are fixed now. The thing was, when we tried to convert it to Word it went to total, unreadable shit. In fact, every time I have tried to save anything but the most trivial OOo doc in word format, it has failed horribly. It made files that hung Word upon opening. So, in our experience, OOo is great as long as you never have to share your documents with someone using MS office.

    --
    A slashdotter who didn't build his own computer is like a Jedi who didn't build his own lightsaber.
  5. Gratuitous plug: StarOffice 6.1 by swordgeek · · Score: 4, Interesting

    I don't know what the status of OpenOffice is right now, but for those looking at StarOffice, I say wait!

    6.1 is in its second beta refresh, which from Sun generally means that the next release will be final.

    6.1 has two features that make it VASTLY better than 6.0: antialiased fonts (no more disappearing text in a window!!!) and substantial speed/performance gains. There are, of course tons of other features--much better MS office support, export to PDF, etc. etc.

    6.0 has been my office package for the last year or so, out of necessity. 6.1 will be my package out of choice.

    --

    "People who do stupid things with hazardous materials often die." -- Jim Davidson on alt.folklore.urban
  6. Re:woohoo, pdf conversion... by Daemonik · · Score: 5, Interesting

    See, there's a difference between people who like to tinker with their computers, installing ghostscript, cygwin and the like in order to output a PDF file in "12 Easy Steps!" and the people who have more important things to do so they love a simple "Print to PDF" option.

  7. I'll look hard at OpenOffice... by drdale · · Score: 4, Interesting

    ... when they build in the "reveal codes" feature that WordPerfect has. I think that the market share that WordPerfect lost to Word is one of the greatest tragedies of the computer world; WP is a far superior product, and the "reveal codes" feature is a big reason why. And it looks like OO.o has a sub-project going to build in this ability, although the link to give more information on its status seemed to be broken so I can't say how far along it is.

    --
    This post is dedicated to all of those /.ers who do not dedicate their posts to themselves.
  8. exporting .Doc with OpenOffice by Jenova · · Score: 4, Interesting

    Has anyone tried exporting documents with bullet points to .doc yet?

    Viewing it under word, you would find that the bullet points are plain wrong, sometimes it has embedded numbers in the bullet points.

    This is one of those problems that makes it a no-no while exchanging documents with your customers(who use MS Office).

  9. Re:No... by runderwo · · Score: 2, Interesting
    At least not there enough to get people [who by nature resist change] to change.
    Don't you think that's a bit of a generalization? Maybe *you* resist change, and maybe *many people* resist change; but how many people buy a new car every year? A new house? Move 5 times before finally settling down? Take 3 vacations a year?

    Actually, I could just as easily make the claim that people can't get enough of fresh, new experiences. It's just as much of a generalization. To write off something new on the grounds that "people, who by nature resist change" won't consider it, is naive at best, and perhaps even foolish.

  10. Moving the Mountain by ites · · Score: 3, Interesting
    The Microsoft Mountain is very hard to move, but that does not mean it's not worth trying. OpenOffice.org (I hate that .org part, it's like a third leg) is a top class tool, and we use it for all our work. The nice thing about it is the slow but steady accumulation of features that really count. This is the big plus of OSS, something people often forget. Producing PDF files, for instance... a completely vital part of our business - we never send documents that the client can edit. We used to use Acrobat, "Print to PDF". OK, it works. In OOo we did the save to PostScript, mangle PostScript, etc. Now the latest version of OOo creates PDFs with a single click. This is a _killer_ feature.

    Each release, one or two new killer features that people actually want, and over the years we will see an application that has a reputation as a killer, not just a clone.

    I predict that in 3 years time, MS will be playing catch-up with Mozilla and OOo, finding that OSS is not just an interesting development methodology, but more vitally, a much faster tool for market research. I predict that in 10 years' time, MS will finally produce the villain who designed the Paper Clip, and we can dance on his head.

    --
    Sig for sale or rent. One previous user. Inquire within.
  11. Why it's not more popular... by zerofoo · · Score: 2, Interesting

    Two words: Microsoft Outlook.

    OK, sure, I know you can use Evolution with the exchange connector, but that's not part of Open Office, and you have to pay $60.00 for the connector. I buy open license copies of MS office for that much; there is no additional (user) learning curve, and it comes with outlook.

    Give me a free, open source equivalent and i'll take a look, but for now we've got to stick with MS Office.

    -ted

  12. Excel Macros by Mistah+Blue · · Score: 2, Interesting

    I would gladly use OO if Excel macros worked. I have a worksheet from work that I use that has macros. Until then, Crossover Office takes care of me.

  13. Openoffice.... by 222 · · Score: 2, Interesting

    The company i work for is contracted to deploy computers for schools, and i've deployed about 1500 computers with openoffice.org in the last year or so. Everyone involved (especially the superintendant of the most recent school) seemed thrilled at the idea. I hate to say it, but this really is a matter of exposure, and its up to US to create awareness of opensource software in the non-technical community.
    On a different note, i've been including openoffice and the gimp in the images i use, is there any other software that might be fitting in the k-12 environment that im not aware of?

    1. Re:Openoffice.... by mnemonic_ · · Score: 2, Interesting

      Pornzilla, the missing link.

  14. Re:Mod parent up +1, Insightful by fkittred · · Score: 4, Interesting

    Hi;

    I offer myself as a contradicting example. Daily I use OpenOffice in a business setting. I am CEO of a successful 100 employee company. On a daily basis I use Writer, the Presentation Manager and Calc. The only problem I have had is font differences between platforms: I use OO on FreeBSD on a Thinkpad and most of my employees use Microsoft Office on Dells. Some times when they prepare parts of a presentation and send them to me for integration, I find the differences in fonts create minor problems. I was thinking of asking them all to switch to OpenOffice, but there was some resistance.

    I do admit to being a farmer in my off-hours. However, I wouldn't touch Linux if I could avoid it.... I also have already ordered a copy of Using StarOffice 6.0 in response to this review.

    thanks,
    fletcher kittredge

  15. Re:Mod parent up +1, Insightful by siskbc · · Score: 3, Interesting
    The problems you mention are problems with MS Office compatibility, not as StarOffice/OpenOffice.org as an independent program.

    First, I'll debate usability and the general UI of star office all day long - it's horrible. It's also slow and bloated, all things that have nothing to do with file formats. And, as I said, the spreadsheet is completely unusable.

    Additionally, interoperability with MS is a requirement - there's no such thing as an "independent program" anymore for 99% of the population. You can say it sucks for them that they have to perfectly reverse engineer the MS file format, but that's life. The business world requires MS compatibility. So you can say it's not their fault, but it's irrelevant.

    There's nothing wrong with it for creating documents in most other formats, and at least for me, it's good enough so I can read MS Office documents not available in other formats, which is all that I need MS compatibility for.

    I can show you a lot of MS documents that got so corrupted as to be unusable. This will be an issue of how complex a word processor you need, of course - but if you only need something simple, then I can recommend a lot of WP's that are faster and smaller than 00. Put it this way - it doesn't have the functionality or interoperability of office, and it doesn't have the speed of other options, so it doesn't win in any case.

    Luckily nobody demands that I produce documents in the MS Office formats. If they did, perhaps I'd have to purchase MS Office (for MacOS X).

    This isn't a troll or anything, but what do you DO? Are you in school? Because when you get a job, you WILL have to use MS, unless you are lucky enough to be a hard-core unix geex, at which point you'll end up at a place that lives in LaTeX-nirvana. Otherwise, get ready for shitsville like the rest of us.

    --

    -Looking for a job as a materials chemist or multivariat

  16. There are better ways to work than the MS way. by RealAlaskan · · Score: 3, Interesting
    I use MSOffice at work, and have OO1.1beta2 at home. When I want to look at something from work at home, OO handles it just fine. I'm sure that you could find something that doesn't work, but I haven't.

    It's klunky, it's bloated, slow as hell, and the UI is an absolute joke, ...

    < joke>Sounds as if OO is ready for business use. It's got MSOffice's essential characteristics.</joke>

    When you say ``...It's klunky, it's bloated, slow as hell, and the UI is an absolute joke ... '' do you mean: ``It's different from MSOffice.''? If your mission in life is to run MSOffice, then you will be happiest running Windows and MSOffice. If your mission is to work with data, and produce structured documents, you shouldn't be using an office suite at all.

    1. Re:There are better ways to work than the MS way. by siskbc · · Score: 2, Interesting
      I use MSOffice at work, and have OO1.1beta2 at home. When I want to look at something from work at home, OO handles it just fine. I'm sure that you could find something that doesn't work, but I haven't.

      I will admit, I haven't tried 1.1 yet, as their regular versions are buggy enough to throw me off their betas. My attitude may change when I see that though, so assume my comments are restricted to 1.0.

      When you say ``...It's klunky, it's bloated, slow as hell, and the UI is an absolute joke ... '' do you mean: ``It's different from MSOffice.''? If your mission in life is to run MSOffice, then you will be happiest running Windows and MSOffice.

      Sadly, I was stating that in relative terms...to MS Office! I know, hard to believe, and trust me, I'm not trying to sell copies of MS Office. I spend a decent amount of time cursing it, and have weaned myself away from it as much as humanly possible, but there are things you need an office suite for. Namely, when some jackass sends you a .doc file with crap embedded in it and you need to work with it. Which happens to me all the time.

      But I swear, OO functions worse that MSO in general usability. I'll admit, OO had some cute features I really liked (like a very functional equation editor), but it didn't overcome the way it took over my desktop and sucked RAM like a vampire...again, even compared to MSO.

      If your mission is to work with data, and produce structured documents, you shouldn't be using an office suite at all.

      Well, yes and no. What I do is pretty much what you say, working with data and making structured documents. I'm in grad school and I do a bunch of work with signal processing sorts of things. But when your boss is tied to MS Office, you have little choice, as horrible as it may be compared to LaTeX for writing a paper for publication (ie, "structured document"). And I use Matlab for working with data, but there are a few graphical things matlab does badly, like its errorbar capability is fairly poor compared to excel. Now I know that's a small thing, but that's the last time I used windows and it was last week. So there are still some things that I just have to be able to do, and excel is frequently the best thing I have for the job. And I believe I mentioned by being held hostage to MS Word, much to my chagrin.

      So I don't want to give the wrong impression - I hate MS Office. I would give anything for a decent office suite that does what it does without crashing, taking over my desktop, and requiring me to spend a long time trying to figure out ill-placed menu schemes. When that comes with MS compaitbility, I'll jump all over it. But that's not here now, especially not OO. Though I guarantee I will try 1.1 as soon as it goes general release.

      --

      -Looking for a job as a materials chemist or multivariat

  17. It's not all about replacing Office by soullessbastard · · Score: 2, Interesting
    OpenOffice.org does have its weaknesses when compared with Microsoft Office, one of which is documentation. Books like this help to address that, as well as leeching Sun's StarOffice documentation for free.

    I think this all of the other detriments noted in the comments are to be expected when comparing a product that's been in development for near 20 years against a project that became open source only a few years ago. If you're evaluating OpenOffice.org as a replacement for Microsoft Office on Win32, chances are it will fail. It's much more then simply a Win32 Office replacement. For example, OOo has:

    • support of alternative platforms - Now users on Solaris, FreeBSD, Tru64, IRIX, DarwinPPC, LinuxPPC, LinuxARM, and other platforms still to come can use their computers in a corporate setting. I doubt Microsoft will ever release Office for any of those platforms.
    • Unicode support - Unicode is pervasive in the entire suite, and vertical/right-to-left language support is coming in 1.1. It can be diffiicult to do full Unicode editing in MS Office (at least on a Mac)
    • Language support - You can use OpenOffice.org on a Mac with the interface completely translated into Greek. There are other translations into languages like Estonian, with more being added each day. Microsoft probably won't translate Office into every language, and the entire world doesn't speak English.
    • Full XML support - XML support is a key in OOo 1.0, and uncompressed XML is in 1.1. And the schemas are public. One of the provisions of the SISSL license is that closed source derivatives, like StarOffice, must adhere to the public schemas. This means if you're doing a document content storage & retrieval system, you can store OOo XML documents without losing formatting as is the case with the Office XML exporters in development.
    • Free - Aunt Jane and Uncle Bob shouldn't be forced to pay $300 just to type a resume. And with the advent of Office XP product activation and Office v.X network licensing, it's nice to know there's an alternative that you can use to get your work done on time for a deadline even when your company's run out of licenses!
    • Open source - If you don't like something with it or want to enhance it, you can...if a bug is irking you, you can fix it...that is, if you're willing to trudge through the source. NeoOffice is an example GPL variant that is working to port to Cocoa, and other projects are underway to port to XUL and other platforms.

    Is OOo ready to replace MS Office? No. For certain users, however, it provides options that simply didn't exist before OOo, and options that Microsoft will probably never provide. Complaints about OOo are fine and dandy, but don't overlook the strengths that it provides today and the options that it's given to thousands of users Microsoft has no intention of supporting.

  18. Re:What is missing... by billtom · · Score: 3, Interesting

    Well, I'd agree with you but it's useful to over-generalize and divide MS Office users into two groups:

    1. People who use MS Office as a document creation system.

    2. People who use MS Office as an application development system.

    I think that anyone who is honest in their evaluation of OOo will say that OOo can replace MS Office for type 1 (document) people, but really can't be used as a replacement for type 2 (application) people. And if you're thinking of trying OOo, you need to decide what type you're in and if you're in type 2, you probably shouldn't bother.

    And, if you're in type 2, you might never switch over. I'm not sure if the OOo people have any intention of making OOo the application development tool that MS Office has become. I think that they're focusing more on the document creation angle.