This is a copy of bugs.kde.org bug number 118488 available here: http://bugs.kde.org/show_bug.cgi?id=118488 I am using openoffice-bin-2.0.3 under KDE 3.5.2. Opening up a USB disk in konqueror with the media or system kioslaves (e.g. going to "media:/usbdisk/" and clicking on "mydoc.odt") causes the splash screen to appear, load openoffice and then disappear again without opening the document. The bug above details a workaround which solves this issue - it only requires the replacement of %U with %F as the open office execution command. KDE have closed the bug as they believe it is not their problem, but I am not sure they waited to see that the issue was not fixed in OO 2.0.2. Such a simple fix should be very simple to achieve. I imagine this issue affects any document that you try and open in openoffice.
This unfortunately IS a kde bug. (there is actually an equal gnome bug) It is a bug in the design of kde. With the advent of fuse there is even a possible solution. The problem is that kioslaves implement their own support for custom url's without being standard. As such openoffice does not know what to do with a custom url implemented by a kioslave. Openoffice works perfectly well on standard urls such as http(s), etc. Therefore %F is also inappropriate as openoffice handles URL's and should when it is able to. Perhaps kde should add an extra option that allows desktop files to indicate that they don't support kioslaves (or gnome-vfs in the case of gnome). When that is known kde could use fuse to offer the files as if available on the local filesystem.