Slashdot Mirror
Shortcomings of OpenOffice and Working Around Them?
1mck asks: "Most free office software does the job, and after a hard drive failure, I decided to go MS Office free, so I'm trying out OpenOffice; however, I've noticed that there are a few deficiencies that I'm having a hard time getting around like the 'Shrink to fit' function, and also having PPS files open up directly in 'Presentation' mode rather than in the Edit' mode. Has any one else picked up on other deficiencies in OpenOffice? I realize that it is free, and it won't be as well featured as most purchased software, but when I went on the hunt for the workarounds at the OpenOffice forums, and on the web I've come up with very little to no information at all. Have I chosen the right free software, or would you suggest something else?" What minor irritations and shortcomings have you found in OpenOffice and how have you adjusted to (or worked around) them?
Is it possible that you've expected behavior from OO? I'm not certain that OO's credo is to "replace" M$ Office as an exact copy. However, they probably intend to include *equivalent* functionality in most cases. So, simply opening in a different state ("edit" vs. "Presentation" mode) is a case of you expecting an M$ Office behavior when working with an entirely separate, discrete, different, non-Microsoft Office piece of software.
Well, PPS files are supposed to open in show mode. PPT files get saved as a PPS file so you can give them out so everyone and their grandmother can view them without spending ten minutes finding the "View as Show" option. In MS Powerpoint, you have to open the program, then chose to open the file to open in edit mode. Perhaps you should try that.
Doing cross-references in OpenWriter is clunky and difficult. For each section heading or similar (e.g. Section 2.3.5.13), you need to manually create some kind of bookmark. It is not automatic like MS Word or Framemaker. This is definitely a showstopper for using OpenWriter with complex legal documents and their dozens or hundreds of cross-references.
I realize that it is free, and it won't be as well featured as most purchased software Actually, I think OpenOffice is more "well-featured" than Microsoft Office or any other office suite I have ever used. For example, OOo styles work in many more places and are more general and flexible and OOo's mathematical formula support is better than what comes with MS Office. When I am forced to use MS Office, the limitations of MS Office drive me crazy. OOo is not stripped down bargain software, it's a heavy-duty office suite that happens to be open source. The equivalent of PPS in OOo is PDF--it generates stand-alone presentations that pretty much anybody can view--much better than PPS. I don't know of a "shrink to fit", but I find selecting the text and making the font smaller to be quick and easy.
This is mainly an interop issue because OOo does not behave in the same way as Excel, but there are some circumstances in which OOo does what many consider to be "the wrong thing".
Issue 5658
I realize that
With OpenOffice I can easily "send as pdf-document" or export my presentation into flash animation and publish it on the Web.
With OpenOffice I can save my valuable data in standard format (OpenDocument) so that ten years from now it will still be readable with any standards compliant word processing software no matter what my operating system is.
From my perspective OpenOffice seems to be well featured software compared to the "most purchased software" :-)
Shortcoming: No decent reference/literature managment system available.
Workaround: Use MS Office+Reference Manager/Endnote, unfortunately.
This comment does not exist.
Have you considered using a database? Spreadsheets are suited to being a cross of a desktop calculator and a word processor; if you want to be storing vast amounts of data, I'd recommend using a tool designed for it...
Have you really considered the effort to teach the marketing department how to use a database???
I have a really elegant proof for Fermat's last theorem. If this sig was only a bit longer...
I am migrating our small business (25 users) to OO from MS. I recently switched our power user, who is open-minded and a quick study. She has been pulling her hair out over what would seem to be a couple of trivial details. She even came in to work early the other day because she was behind on some commission spreadsheets due the switch to OO. The rest of the users are doing OK with the switch. I'm afraid the owners are going to scuttle my migration to OO, even though I have shown a $10K savings. It's not that OO is less capable than MS, the problem is that it is different in subtle but apparantly very annoying ways to experienced MS users. For anyone doing a switch, prepare your power users in advance to expect short-term grief from the small things as they recondition.
For the record, the "biggest" problem my power user faces is how the Enter key behaves after entering data across several horizontal cells. In MS, Enter will move the cursor down on row and back to the first column that data was entered. For example, B3 -> B4 -> B5 Enter C3. OO does not have this behavior. The Enter key can be customized, but only to go one cell down (default), up, left, or right. Searching the forums confirmed that other MS users are also frustrated by this missing behavior. I tried a quick macro, but no luck.
Essential commands are not working. I mean, try ^[:wq or even ^[ZZ to write and quit. I tell ya, worthless junk!
I hadn't the slightest objection to his spending his time planning massacres for the bourgeoisie... (P.G. Wodehouse)
(in)Compatibility with MS Ofice has been the deal breaker for OO at my workplace.
I was overjoyed about a year ago when the word came down from our new CEO that we should try to wean ourselves off M$ Office. I had been trying to do that for 5 years, but he did it in one email.
I have, sorry to say, switched back. First, it was trying to print Excel files from Calc. I just can't afford all that wasted paper. Excel went back on my machine.
Then I had to update a manual written in Word. Writer (00 v.2) ate ALL the graphics in the entire manual and went on to balls-up the fonts and formatting. I reported the error and got a message back from the coder that this bug would be fixed in the next release - and that my report was one of hundreds. So Word went back on my machine.
Then there was the boss's powerpoint. He worked all day, built this file in Presenter (or whatever it's called), unfortunately he saved it in ppt format instead of the native format. Went back to it the next day. WHAT A MESS! Every slide had to be redone. Powerpoint went back on his and my machines.
We use Access databases all the time. Base has never been up to the tasks we throw at it, or compatible enough to replace Access.
So that's my sad story of trying to convert an office to OO. I know it's mostly not OO's fault (except for the graphic-eating bug), and their word processor and presentation software is much easier to use (IMHO) than M$'s bizarre shite, but until EVERBODY stops using M$, I'm stuck with it. (at least we haven't bought a NEW version of Office - and have no plans to - just reinstalled the ol' 2000 version)
Stella
I find graphing in OOO to be completely unacceptable.
I am a scientist, and I generate dozens of what Excel likes to call "x-y scatter plots" every day. They tend to be mildly complicated, but thats OK. I like tricks like multiple axes, ease of changing scales and labels and legends, and also the ability to make each graph its own sheet in the workbook.
I have spent time trying, but I have to conclude that OOO is just bad at all of this.
On the other hand, I have been quite pleased with Gnumeric for my spreadsheet needs.
And I also recognize that I am a specialist with a niche need, so I'm not expecting to have my requests fulfilled anytime soon. I realize that the more picky, demanding, and unusual you are the less likely that there is an open source option waiting for you.
My $0.02.