Slashdot Mirror
Special Edition Using Star Office 6.0
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:
- 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).
- 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)
- 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").
- 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).
- 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.
I've been using exclusively OO.o for a number of months. I recently installed MS Office 2003 b2 and took it for a run, and while tight and very modern, it's full of many crazy features and the XML is writes is hopelessly unreadable.
Most people take open source apps for granted, but this is one app that is DEFINITELY worth your cash. Ifd you really want to be part of a free software community, buy StarOffice 6 from Sun.
I've been doing PDF conversion from Word without Acrobat for ages. Its very simple:
.prn by default, but rename it to .ps if you like.. its just postscript. Then run it through ps2pdf (available on cygwin, I believe), part of the Ghostscript package. Bingo, you have your brand-spankin new PDF.
Add a new printer that uses postscript, and have it use the "FILE:" port. That way whenever you print to it, it will print to a file in postscript. Windows will name it
Yes, it does lack some of the more advanced PDF features, such as clickable table of contents, or fill-in forms.. but it gets you a viewable PDF.
-molo
Using your sig line to advertise for friends is lame.
When StarOffice told me to find some files, install a newer compiler, then compile the program, they lost me. And I'm part of their target market, a CS major, working for a linux friendly company. I could have spent more time, but if they don't care to make it easier for me, I don't care to use their product.
There are some very good alternatives to outlook calendaring.
Some of them cost money, but then, if you're not paying for MS Office, maybe you have some cash for a sophisticated, crossplatform calendaring client-server application like Meeting Maker http://meetingmaker.com
I have had to educate some on why we don't take them anymore. Here's the mail I sent out:
As we use many different programs to layout, archive, and read files, we require file formats that do not depend on any one program.
Please send all documents saved as .RTF (rich text format). This is an open standard, and one that all word processors can read. It also saves to a smaller file size, and is better for archiving as it contains no proprietary code.
In MS Word, Your .DOC files can be saved as .RTF as follows.
1. Open your document
2. Go to the 'File' menu
3. Select 'Save As'
4. In the dialog box, type a new name for your document if desired, then in the 'Save As Type' drop down menu, choose '.RTF Rich Text Format'.
5. Click 'Save'
6. You're done!
You may also click the 'Options' button in the 'Save As' dialog box and choose '.RTF Rich Text Format' for the drop down menu "Save Word files as". This reminds you to save them as .RTF files.
In other word processors and page layout programs, you may be able to 'Export' your open file as .RTF.
So far, no complaints. I hold the cards in this situation (do it this way or no publishing), and the computer stuff is completely up to me, so YMMV.
It does feel good to kill the .doc files one by one, and if my explanation has a little FUD in it, oh well.
I learned alot from MS.
I'll start by saying that MS Office is just plain easier to use than anything anyone else has to offer, IMHO.
But that's not to say that it has to be that way. The majority of today's workforce wasn't raised on computer technology. We shouldn't rush to overthrow the tried-and-true in today's corporate market. Open source, Linux, etc., should be implemented in the schools. Today's students will grow up having the means with which to understand the open-sorce movement and perhaps grow it to be a true option in their workforce of tomorrow.
"`Ford, you're turning into a penguin. Stop it.'" -Douglas Adams, THHGTTG
On Mac OS X, you just print and select "Save as PDF..." in any application-- after OS X changed from Display PostScript (the original Mac OS X Server) to PDF (Mac OS X 1.0) for graphics, PDF conversion became quite easy.
Seriously, has anyone actually kept count of how many office alternatives are available to the unix world.
I think I tried openoffice and corel word and a couple other alternatives myself. I need 1 solution that's monopolistically better than anything else on the plaform. Not 10 solutions that are the same.
This is a misconception -- Exchange/Outlook calendaring is a seperate licence from the rest of MS Office.
Also, MS Office dominated the market long before it developed a shared calendar component.
Open. The standard.
Cheers,
Ian
I was interested to read this article as I thought I would have a quick browse of Slashdot while taking a break from writing a huge system design document, which for the first time I am attemption to do in Open Office on Linux rather than Microsoft office. My observations are as follows;
The different components have different strengths. I rate Star / Open Office Writer very highly, it does allow you to structure documents well and it's support for tables is excellent, one of the few areas where it betters Microsoft office.
The Excel replacement I don't think is nearly as mature. I generally use it to open other peoples Excel docuemnts on my Linux box and for this it works very well. However, when it comes to usability features for display, such as ease of splitting into panes, adding autosort or even easily hiding rows or columns it doesn't compare. All the advanced features, such as pivot tables, work much better in Excel.
Presenter and Draw are a mixed bag. I find Presenter now opens most powerpoint documents well enough to read on LInux but authoring is a different story. I tried to use draw this morning to produce a simple flowchart and it simply wasn't very intuative, doing tasks which are simple in Powerpoint such as adding text inside a shape wern't easy. Powerpoint (and all of MS office, for that matter) is very good at presenting the correct context sensative menu options when you right click on something, Star Office has some way to go in this regard.
However, my biggest problem with Star Office on Linux is font support. It simply dosen't seem to interface nicely with the other fonts installed on my Linux box, and reading all the documentation and newsgroups has helped, but it is still a chore. This is particularly apparent when converting Word or Powerpoint documents, quite frequently it will replace fairly common characters like full stops (periods) or quotes with a question mark, often making the supplied document unreadable. I find it strange that some very sophisticated conversion filters for graphics and embedded objects work well but these fail, if anyone could tell me if the book addresses these issues I would be interested to know. I have always found saving OO documents to Microsoft formats to work well.
So, in summary I am going to use OO on Linux as my primary document editor, which just leaves Windows for the occasional Powerpoint, and this book seems like a useful purchase to help with this.
I recently provided a service to my clients using the 1.1 OpenOffice Beta and the SDK. They have a custom php/mysql document management system, and I automatically index all doc,xls,ppt, and pdf files for them. This way, they can search through the contents of their "attachments" quite easily.
The way it works is that OpenOffice can run as a server and listen on a port. There are many examples of document conversion given in the SDK, so that you can essentially use OpenOffice as a Web Services platform. When the document is added into their document management system, I run an external process that converts the documents to pdf, then to text, and then imports them into the MySQL database.
It's pretty darn sweet! The conversion works incredibly well for the purposes of getting the text content out of the various formats.
As a side note, I've been using it for my personal use for quite a while. The filters are absolutely outstanding for working with and using Microsoft file formats. I have incredibly complex documents, and it opens them quite well. The PDF conversion is excellent and is really nice to have. Check out the 1.1 Beta, as it's been really stable in my experience.
Unfortunatly, I work in a very big office and all their mission-critical applications, even those used by our clients (~ 50k), are based on access with either VB or C++ frontends.
Let's just say, it is not convenient and crashes a lot.
- AC wants to keep his job
I've set up pdf printers for my users using redmon and ghostscript - with a little configuration it works great & all they see is a save as box.
From the redmon directions:
PostScript written to a RedMon port can be converted to a PDF file using Ghostscript.
Install a printer driver for a colour PostScript printer, e.g. Apple Color LaserWriter 12/600. If you select a black and white printer such as Apple LaserWriter II NT you will end up with your colour images becoming greyscale.
To use RedMon and Ghostscript to create a PDF writer, you need to use the Ghostscript device pdfwrite. c:\aladdin\pdfwrite.rsp would contain:
-Ic:\aladdin\gs6.0\lib;c:\aladdin\fonts
-sDEVICE=pdfwrite
-r300
-dNOPAUSE
-dSAFER
-sPAPERSIZE=a4
The Ghostscript command would be
c:\aladdin\gs6.01\bin\gswin32c.exe
and the arguments
@c:\aladdin\pdfwrite.rsp -sOutputFile="%1" -c save pop -f -
Make sure you include the space and dash at the end of the line. Failure to do this could result in Ghostscript stalling the print queue. Output should be set to
Prompt for filename
All other settings should be the same as the previous examples.
You may wish to rename the printer from Apple Color LaserWriter 12/600 to Ghostscript PDF writer.
Once they get used to typing doc.pdf instead of just doc in the save as box you're done.
There is actually a very slick alternative to Access for the Open Office world. It is MySQL, see http://www.unixodbc.org/doc/OOoMySQL.pdf. The functionality provided is better than access and has the potential of tighter integration with other database products as it is a SQL based product. It doesn't suck like Access.
Gungah dah lungha.... So I've got that going for me.
There's another book, by Solveig Haugland and Floyd Jones called _StarOffice 6.0 Office Suite Companion_. It's on Sun Press. Reviews and comments can be found at amazon
Get OpenOffice.org 1.1 Beta. The filters have *vastly* improved. There are many features added as well. Don't bother with StarOffice unless you really need comercial support (questions are probbly answered faster on the forums) or the clipart (which you can get elseware anyway). The database app thats distributed sucks, so I won't even count that.
Why is it so hot? Where am I going? What am I doing in this handbasket?
Save your Writer document as .sxw
.zip
.. whaddayaknow .. :)
Rename the file to
Unzip it
Hey look
it's in my head
If you're intrepid enough to compile the sucker (takes over a day) you'll find the icons are simply windows .bmp formatted files that you can replace with whatever you want. This results in the creation of an alternate set of .res files that you can then drop into any OOo distribution. This is the approach that Ximian uses to bundle a different icon set into their 'enhanced' OpenOffice.org included with Ximian Desktop.
It is also possible to use completely alternative widget sets with OOo, as illustrated by the NeoOffice port using Cocoa widgets and Carbon-rendered widgets (screenshots of Neo vs. Office v.X). This approach, however, is still only available to GPL versions of OOo.
If you've got better ideas as to how to achieve cross-platform compatibility and skinning while maintaining the identical look and feel requirement Sun has, stop by the Graphics System Layer project and lend a hand!
And if you're an intrepid graphics designer (who knows a few other intrepid graphics designers...) and would like to make an alternative icon set for the approximately 1000 icons, please pipe up and help us out! Parts of our icon set are the direct result of the truism that programmers are definitely not graphics artists, and others are relics from when Star Division was busy mimicing Win95/Office97. Our community development can only provide the features the community wants if folks volunteer, else OpenOffice.org will continue to gain only the features Sun believes are needed for selling StarOffice, not necessarily those wanted by the user base of its free cousin.
I have to second that. I tried to share a document with bullets made in OO then opened in MS Word, and the bullets were screwed up. OO is a great product when sharing files with other OO users, but it's not up to snuff when interacting with MS Office. Users of OO often talk up the MS Office compatibility, and this is only going to hurt the product when people actually try it. The version I was using was what came with RH9 1.0.2 I think.
I teach programming and put my grades online. To do this, I need to hide the student's name. I had been posting the grades in an Excel generated html page but found that the hidden columns were still in the HTML!!!! What the hell is up with that? So, OpenOffice.org to the rescue. The Calc program not only converted everything from Office, but the HTML is CLEAN and NO hidden data slips into it. I'm sold on Calc, now if we can just get those guys to go over and work on Writer!
Setting his threshold to 5, Sparky eliminated most of the trolls on /.
One side note: It will set itself up as your default printer, so you may need to reset your default printer after it's done w/ its installation.
I'm not sure what the secret to success is, but the secret to failure lies in trying to please everyone -Bill Cosby
the new ximian xd2 joins together openoffice and evolution for an msoffice/outlook combo effect. ximian.com
No they are not. That's in fact the reason that they are called TrueType. The whole deal about TrueType fonts is that the OS either embeds them if the printer is TTF compatible, or rasters them for the printer. Unlike for instance Postscript Type-1 fonts; the Type-1 font for "times" installed on your computer can, and often does differs from the "times" Type-1 font installed in your printer, but the font is not embedded because it is present in the printer - and so, things get screwed up. You need Adobe Type Manager on your windows machine to even get Type-1 fonts to work properly. In Windows terminology Type-1 fonts are called "printer fonts" and are installed by, for example, HP printer drivers - these drivers install the same Type-1 font as is present in the printer so you don't get screw-ups. (However, generating PDF will screw up because HP's Type-1 "times" printer font differs from Adobe's "times" font used in PDF).
OpenType btw is nothing more than a wrapper for both Postscript and TrueType fonts. To get even nit-pickier, TrueType fonts are Postscript Type-43 fonts. OpenType does have additional features to make sure Type-1 fonts behave less screwy - it makes sure they get embedded.
The issue with word screwing up layout is to do with printer-margins. Word will not allow documents to spill over the printer driver's hardcoded margins, even if the piece spilling over is pure white... Microsoft Publisher has no problem whatsoever with this concept, which is handy; you can use the edge of the page to "crop" vector based images.
Note also that word will change all of your pages text margins if you include even 1 footnote (affecting only one page), which does not make sense. TeX doesn't do this, does it?
Word absolutely, unequivocally SUCKS for layout purposes (and for large documents which use footnotes and such).
SCO employee? Check out the bounty
If you understand french, here is a tutorial to install a free (like beer) PDF printer on Windows using GhostScript, RedMon and the Adobe Poscript drivers.
Eight years ago the OEM cost of MS Office was about $40-$50 per machines. Word Perfect Office was about $150.00 per machine OEM. The store I worked for wanted to offer a choice of office suites but we had a damned hard time telling people that the computer with WP Office was $100.00 more than the exact same system with MS Office. At margins of about $200.00 per $2,000.00 computer, we were not willing to eat $100.00 per system just to give people a choice.
That killed off any WP business for our company.
Boobies never hurt anyone. - Sherry Glaser.