Slashdot Mirror


Can a Small Business Migrate Smoothly To OpenOffice.org v3?

Pay The Piper writes "As an IT Support Technician in a small corporation, I've been tasked by one of my managers to determine the feasibility of transitioning our small 40 or 50 person office from Microsoft Office 2000 to Open Office 3.0. What are some of the problems I may run into as far as document cross compatibility? Has the Open Office suite evolved to a point that permits easy transition from Microsoft's suite? Besides the obvious 'free vs. expensive' argument, what are some of the pros and cons of transitioning? Are there any reliable ways to view/edit/save a document saved in the OpenXML format through Open Office, or are my co-workers and I still going to be stuck in Microsoftland?" (Given that company-wide rollouts take some time to implement, this early look at the features of OO.o 3.1 may have some relevance, too.)

34 of 503 comments (clear)

  1. OpenXML Plug-In Exists for Novell's OO.o by eldavojohn · · Score: 5, Informative

    Microsoft Office 2000 to Open Office 3.0

    I will say that although I have not had the joy of opening Office 2000 files with OO.o 3.0, I do recall there being some serious issues between powerpoint slides. Some weird rendering going on in OO.o for what reason I do not know. In my line of work, powerpoint is perversely pervasive--to the point of alarm for me. If this is true for you, do some testing before taking the plunge!

    Are there any reliable ways to view/edit/save a document saved in the OpenXML format through Open Office ...

    I regrettably give you the option of getting Novell's OO.o distribution (here) in which you can install an extension for OpenXML.

    The best recommendation I can give you is to do this change only if you can assure that it will not hinder your ability to serve your customer or detract largely from productivity.

    --
    My work here is dung.
    1. Re:OpenXML Plug-In Exists for Novell's OO.o by gravos · · Score: 5, Insightful

      This is a good analysis. Don't listen to the guys below who are just saying YES RAH RAH OPEN SOURCE and who have never worked in IT or had to deal with managers howling at them when a 10 year old document won't open correctly in a new software package.

      I love open source too, but let's be realistic here.

    2. Re:OpenXML Plug-In Exists for Novell's OO.o by Culture20 · · Score: 5, Insightful

      Nothing handles MSOffice files well, not even other Microsoft applications. Their format is a mystery wrapped in an enigma enveloped by a binary blob.

    3. Re:OpenXML Plug-In Exists for Novell's OO.o by Tiber · · Score: 5, Informative

      They fixed it. I'm the Linux Guy at work, and I have to toss together powerpoint presentations.

      Specifically what doesn't work:
      * Slide transparency isn't supported, so anything you paste into slides will be 100% opaque when opened in MS Office
      * Vector art does wild stuff. Whatever coordinate system OO is using, MS isn't. If you use anything that uses vectors, convert them to bitmaps first.

    4. Re:OpenXML Plug-In Exists for Novell's OO.o by homesnatch · · Score: 5, Insightful
      Also, don't compare moving to OpenOffice to Office 2000... Compare it to Office 2007.

      The same whiners that will complain about OO will also complain about MS Office 2007... the GUI change is so drastic. OO's GUI is closer to Office 2000 than Office 2007 is.

    5. Re:OpenXML Plug-In Exists for Novell's OO.o by PitaBred · · Score: 5, Insightful

      MS Office doesn't even handle MS Office files. I've had Excel corrupt many spreadsheets itself, things I saved by Excel that the same app couldn't open again on the same computer.

      That said, OO.o is quite compatible with MSOffice if you don't get too insane with the formatting and such. I have yet to have someone have a problem opening a .doc with Word that I created in OO.o.

    6. Re:OpenXML Plug-In Exists for Novell's OO.o by macxcool · · Score: 5, Interesting

      You should also consider GoOO http://go-oo.org/ which is an improved version of OpenOffice.

    7. Re:OpenXML Plug-In Exists for Novell's OO.o by Anonymous Coward · · Score: 5, Insightful

      which is why it is such a popular malware container. :)

    8. Re:OpenXML Plug-In Exists for Novell's OO.o by digitig · · Score: 5, Interesting

      In my experience, OO.o handles damaged MS Office files far better than MS Office does. I've never known it to fail to open an MS Office 2003 or earlier file, but the formatting can be changed, and of course any VBA in the document is going to be a problem.

      --
      Quidnam Latine loqui modo coepi?
    9. Re:OpenXML Plug-In Exists for Novell's OO.o by Anonymous Coward · · Score: 5, Funny

      Technically it would be binary lob or blob, since binary blob is redundant:)

      Blob = binary large object

      Just thought I would be annoying and point that out ;)

    10. Re:OpenXML Plug-In Exists for Novell's OO.o by characterZer0 · · Score: 4, Insightful

      The problem is that in the eyes of your users, if MS Office corrupts or cannot read a file, it is the file's fault, but if OpenOffice cannot read a file, it is OpenOffice's fault.

      --
      Go green: turn off your refrigerator.
    11. Re:OpenXML Plug-In Exists for Novell's OO.o by jimicus · · Score: 4, Insightful

      Nothing handles MSOffice files well, not even other Microsoft applications. Their format is a mystery wrapped in an enigma enveloped by a binary blob.

      This notwithstanding, if Office 2007 fails to open an old document it will probably be considered "one of those things, document must be corrupted, never mind, these things happen". This may not be the reaction if something similar happens with OO.o

  2. Short and long answers? by Lumpy · · Score: 5, Informative

    Short : YES.

    Long : Yes, but you will have to tell the office whiners to STFU.

    Honestly it's not that hard, it requires some retraining of habits. and requires users to not be raging Luddites.

    If you get management buy in for it, the transition will take weeks before all the whining dies down. the only problem is when you get users that are not smart enough to understand what they were instructed to do because they did it the other way for the past 5 years.

    --
    Do not look at laser with remaining good eye.
    1. Re:Short and long answers? by MyLongNickName · · Score: 5, Insightful

      Your response to this disqualifies you as any kind of authority on this type of question. You are combative, hard headed and have absolutely no empathy for the folks you are supposed to be serving. As a manager, I would NEVER have this type of attitude towards people or allow that type of attitude to germinate in my department. You think your point of view is the only valid ones and anyone who disagrees is an idiot. frankly, you are the type of person that gives IT workers a bad name.

      --
      See my journal for slashdot ID's by year. Mine created in 2005. http://slashdot.org/journal/289875/slashdot-ids-by-year
    2. Re:Short and long answers? by homesnatch · · Score: 5, Funny

      Yes.. Outlook has the ability to send emails for any such messages. Outlook is part of MS Office, so just make sure you have that installed.

    3. Re:Short and long answers? by Chabo · · Score: 4, Funny

      Put the message inside an Excel spreadsheet that uses weird macros. If they can see it, then they're still using MS Office, and they should switch.

      --
      Convert FLACs to a portable format with FlacSquisher
    4. Re:Short and long answers? by Capt.DrumkenBum · · Score: 5, Interesting

      Don't tell them anything about change.
      Users fear change.
      Tell them they are getting an upgraded version of office.

      True enough, less fear, less whining, and less pain for you.

      --
      If I were God, wouldn't I protect my churches from acts of me?
    5. Re:Short and long answers? by 644bd346996 · · Score: 5, Insightful

      If you're doing IT for people who's job descriptions require basic computer skills, it's perfectly okay to tell them to suck it up when they have to transition away from software that is one week shy of a decade old, particularly if you offer some training classes.

      Besides, when has it ever made sense to pamper employees who's skills are ten years out of date?

    6. Re:Short and long answers? by MyLongNickName · · Score: 5, Insightful

      One thing I learned as a software developer, is you can create an application that conforms to specifications but is hated by the end users, even those who designed the spec. What I learned is that you need to take a lot of time up front, and talk with all of the users and other stakeholders. You need to listen to what they say and don't say and then you need to figure out what they really want. It is usually different than what they are expressly asking for. Part of that is respecting everyone in the process, regardless of their attitude. If you can demonstrate that you really want to give them what they need and will help them with that process, you will get very little of the backbiting that original poster expressed.

      Where does this begin? Nothing technical. Nothing taught in school. You have to sincerely respect people from all areas, not just the IT minded. Not just the higher ups. Everyone. Once you start with that frame of mind, doors open. Granted, sometimes it takes a conscious effort to get to that frame of mind. Sometimes, people rub you the wrong way.... they have agendas, and you have to take a deep breath and step back. But calling your users Luddites and worse sure ain't the way to go. Frankly, the attitude disgusts me.

      --
      See my journal for slashdot ID's by year. Mine created in 2005. http://slashdot.org/journal/289875/slashdot-ids-by-year
    7. Re:Short and long answers? by Just+Some+Guy · · Score: 4, Interesting

      But calling your users Luddites and worse sure ain't the way to go.

      But he wasn't saying that all protesters were Luddites. I totally agree with everything you said, but also understand his frustration about people who protest all change, regardless of how carefully planned or coordinated with the end users, seemingly for the sake of having something to complain about. Those were the people he is railing against.

      --
      Dewey, what part of this looks like authorities should be involved?
    8. Re:Short and long answers? by Paladin128 · · Score: 4, Insightful

      You're absolutely wrong. This isn't "just a little bit of re-training". This is a big deal. The thing is, everyone uses MS Office. If someone can't do some little task, chances are they can ask one of their co-workers. You can't ever really under-estimate this kind of knowledge, and what it's worth. The cost of an entire corporation which is switching over all at once to a new piece of productivity software is quite high, in terms of productivity.

      I say this as a low-level project manager who successfully convinced my company to move to OpenOffice 3. We're doing phased deployments, one team at a time, over the course of the next year, that way the whole thing doesn't grind us to a halt. We're sticking with Outlook, at least for now, but the rest of MS Office is going away, starting with Word. Why are we doing this?

      1) cost
      2) extensibility (plugin development)
      3) stability of the ODF format

      We've built some automation tools that leverage ODF to save us hundreds of man-hours per year. ODF is more elegant and stable than any of Microsoft's solutions, and so we built a whole stack of XSLT's and tools around it. We support MS Word formats, but only by running them through OO.o's conversion filters to ODF first.

      If we didn't build this, the cost of switching to OO.o would far outweigh the licensing costs.

      --
      Lex orandi, lex credendi.
  3. Macros by Enderandrew · · Score: 5, Informative

    Do your documents utilize VB macros? If so, you may want to look at Novell's fork of OOo at go-oo.org which improve macro support. Otherwise mainline OOo should open all your MS Office 2000 documents with ease.

    The interface of OOo is closer to MS Office 2000, than MS Office 2007's interface is. Training users should actually be easier than training users on MS Office 2007.

    When I converted my mother to Linux I told her she'd have to give up MS Office. When I installed openSUSE 11 and OOo 3, she thanked me for giving her MS Office. It looked so similar, she couldn't tell the difference.

    The only little bit of advice I'd give you, is to go into the program options and set the default file formats. While I praise ODF, and want the world to adopt it, if you're going to send documents out to the rest of the world, you'll have to save them either in PDF format (which OOo does natively) or save them in MS formats for everyone else.

    When you're done, tell your boss how you just saved the company $400 a pop times 50 people, and ask for a raise.

    --
    http://blindscribblings.com - Tasty pop-culture in conceptual fashion.
  4. Why not pilot it with a small group first? by tubegeek · · Score: 5, Insightful

    Pick a sample of users - some tech-savvy, some not - who interoperate with others still using microsoftware. A pilot should bring out the most pressing points of contact and show whether or not the compatibility level is adequate.

  5. Not a lot by Just+Some+Guy · · Score: 5, Interesting

    Our office of 50+ transitioned back in the early 2.0 days with nary a hitch. A couple of people still have MS Office for specific compatibility reasons (certain spreadsheet macros, that sort of thing) but everyone else from IT to the receptionist has OOo. We spent approximately $0.00 on training, instead going with "here's your new word processor". People who need office suites picked up on it quickly and people who primarily do other things didn't really care.

    --
    Dewey, what part of this looks like authorities should be involved?
  6. i don't see any problem by C0vardeAn0nim0 · · Score: 4, Informative

    short answer: yes.

    long answer: yeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees (sorry Yahtzee!).

    a friend of mine migrated to OOo a year ago and most of his employees didn't even noticed. he owns a small architecture office.

    only the oddball document that doesn't open right in OOo, he opens and converts on his own notebook, the only one in the company that have MS stuff.

    --
    What ? Me, worry ?
  7. Yes, but no. by CannonballHead · · Score: 4, Informative

    Yes, for most things.

    No for powerpoint. From what I've used, OO.org's Impress is simply not as good, has rendering issues, flickers, is a resource hog, is not smooth, etc. Powerpoint is way better.

    Can you do office docs and spreadsheets? Yeah. If not using the aforementioned VB macros and whatnot, it's easy to use openoffice.org for stuff like "word" documents and spreadsheets.

    But presentations ... blech.

  8. Why not both? by Sir+Homer · · Score: 4, Interesting

    The fact is not EVERYONE needs Office, but some people do. Which baffles me why a corporation wouldn't consider deploying OOo to everyone, and give MS Office to the people who depend on weird MS Office features. This way you save the most money while not slowing your business process!

  9. Re:Entirely Depends On Your Integration by Magic5Ball · · Score: 5, Insightful

    For example do you have Word setup to access a database or something ridiculous like that?

    Mail merge is not usually an odd-ball feature for anyone who has more than a handful of friends or clients. As an aside and from experience, attempting to mail merge anything with over 3,000 rows in OOo generally results in pain.

    --
    There are 1.1... kinds of people.
  10. Case study in pub ed: by gandhi_2 · · Score: 4, Interesting

    I renamed the "OO.org Document" icon to "word". Set the defaults to save as ms .doc files. Works great.

  11. 50 people? No problem by Trojan35 · · Score: 5, Insightful

    Your biggest griper will be a finance guy (like me). For him, just buy excel. Forcing him to use something other than excel is cruel and unusual punishment.

  12. We tried that by PhantomHarlock · · Score: 4, Insightful

    We tried migrating a company with 40 users maybe three years ago, to Sun's boxed version. It was a complete and utter failure. Maybe it's gotten better now, but I'd be pretty weary. There were a thousand and one little incompatibilities. Plus some of our people use Excel for things god never intended it to do.

    One thing is we deal with the government a lot, which always has the latest version of Office. Keeping up with that using non-MS software is pretty hard.

    I think if your office only does very general word processing and spreadsheet use, it might work. But a lot of people have noted the powerpoint issues.

    Basically, if it doesn't just work perfectly, it's a support nightmare. When we tried the experiment, I remember we'd author something, send it off, it'd come back with revisions from a customer with real MS office, we'd open it and it'd be all messed up, and that would happen going the other direction as well.

    I don't think I'm ready to try that experiment any time soon. It's not worth the money saved, yet.

  13. Too Many Filetypes / Too Much Incompatability by bhima · · Score: 4, Interesting

    I am currently looking for a job (as I suppose a lot of folks are). At home we all use Macs. My Girlfriend has Apple Pages, so I decided to use it. I was astounded how easy it was to make a resumé that looked pretty good from one of the templates. So I applied for a job and sent them the Word export (as I figured word was a default filetype). Not only does the resumé look really bad, many windows users can not open it. So I exported to PDF, same. So I took it to where I work now opened with the current version of word (disaster!)... spent a while fixing it, saved it... and people have trouble opening docx files in the more common older MS Word application.

    I am a scientist, not a typesetter! And I wound up doing several iterations of this to get something that older versions of MS Word (running on older versions of windows?).

    So bottom line, I used Rich Text and a MS font. I blame this on MS making their applications so picky when opening various competing filetypes.

    --
    Nothing in the world is more dangerous than sincere ignorance and conscientious stupidity.
  14. MS Office file corruption by coats · · Score: 5, Interesting

    If you're exchanging MS Office docs -- particularly ones going through multiple editions of MSWord, it is a commonplace for MS to claim the docs are corrupt and refuse to do anything. Frequently, OpenSource tools like OpenOffice.org or AbiWord read the files perfectly well, and then can save them un-corrupted in ".doc" form. My wife is an attorney, and she has to jump through that hoop all the time.

    --
    "My opinions are my own, and I've got *lots* of them!"
  15. Re:Office 2007 GUI remedy by mewshi_nya · · Score: 4, Insightful

    By *buying* something to fix something that shouldn't have been broken in the first place. Awesome.