oh and who came up with libreoffice ? built to work with the open odf format. err I thought that odf was the openoffice format that works across platforms, or is that the problem, is that why ubuntu does not come preloaded with openoffice but libreoffice ? just to make sure it distinguishes itself from windows...... and further complicates the transition
Wow. Simon, you seem to have found lots of issues with Linux, but you have to remember that a distro maker has little control on how all the component apps work - they are all separately managed open source projects.
With regards to OpenOffice/LibreOffice, you can set then to default to DOC/XLS/PPT formats, but of course they initially default to the open document formats, and the Microsoft formats are just not open.
Once you stop wanting Linux to behave just like Windows, you can actually see what it does do well.
As a server, it is just incredible. I have used Linux for a number of servers, and they usually just keep working for years with hardly any maintenance. With Windows servers, there are always issues, and you have to regularly reboot. Linux has no 10 connection limit (like windows Workgroups), no licensing issues or management. I often set up a simple Linux server and then run several specific servers (including Windows) as virtual machines. The reason is that if the hardware dies, I can put the virtual machine on another PC and have it running exactly as before with zero setup. I have just found that virtual machines are extremely robust under Linux, and if you try and do the same thing under Windows, there are problems.
At the moment, I have a server running from home that is Ubuntu 10.04 (no windowing GUI) fileserver running three virtual machines - a Windows XP used as a license server for several programs including Maya. A second virtual machine running the totally brilliant Redmine web based project management system (love it) , an OpenVP server, and a SVN server; and a third server used as a Wordpress development server. The server was set up 3 years ago, and I don't do anything to it (except for occasional updates) - it just runs. The main Ubuntu fileserver uses Windows NTFS formatted volumes for storing files, so that I can read the same drives in any Windows PC. I use Sata drives in a removable caddy for backup, and I can plug and unplug then while the server is running. Try doing that on Windows with standard Sata (not esata - just ordinary Sata) drives.
If you don't like the sluggishness of Gnome or KDE on slowish hardware, there are distro's with lightweight GUI alternatives that are extremely fast.
As a workstation, picking the right distro is the key. There are several designed to look like Windows, there are some like Centos designed for stability, there are some optimized for Multimedia. Take your pick.
You have a choice of using the application build versions that come with the distro which has the advantage of easy updates, but the application version can easily be out of date.
Alternately, you can compile the latest version of an app on your Linux system. A bit more techy, but usually not that hard. It is then up to you to download and recompile when you need to update.
i use Windows 99% of the time, and I have not been tempted to move to a Linux workstation for general use, but when I need to do something that Linux just does way better then Windows or OS/X, I use it.
The best way to get started is to use the Wubi installer to install one of the many Ubuntu versions into a single large file (a virtual disk file) on your Windows PC, and give you a dual boot option. It is a dead simple install, and when it runs, you have access to your Windows files.
So it is nothing to do with snobbery - it is just that for some things, Linux is light years ahead of anything else. Especially for price and freedom from licensing issues. Windows and OS/X are better at many things, but is that a surprise? We are are comparing free software to the products of two of the biggest and richest companies in the world.
Richard