Cannot open in MS Office when title is missing an extension

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.1.1 CE GA2, 6.1.20 EE GA2
• Fix Version/s: 6.1.2 CE GA3, 6.1.30 EE GA3, 6.2.0 CE M3
• Component/s: Documents & Media, WebDAV access
• Labels:
  • QA-R
  • QA-TP
  • document-library
  • ee-ts
  • javascript
• Environment: Tested with OS VIsta, MS Office 2007, ie7
• Branch Version/s:
  6.1.x
• Backported to Branch:
  Committed
• Fix Priority: 4
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/8229

Steps to reproduce:

1. Create new document with some MS Office file (doc, docx, xls, xlsx, ppt or pptx) on your computer. Do not specify any custom title.
2. Try "Open in MS Office" (see LPS-28718 for supported configurations, I've used ie7 in Vista with MS Office in WIN XP SP2 compatibility mode). No problem here, file opens and is editable. Important part is, that the correct MS Office program is launched.
3. From the portal, edit the file and change the Title to not contain any file extension (e.g., "Title").
4. Publish new file version and version 1.1 is created
5. Try "Open in MS Office" on the new version (1.1).

Result:
Nothing happens. No Javascript error, no error in Liferay UI. No MS Office program is opened in OS.

Expected Result:
File is opened in MS Office program in OS, with the file being writable.

Details:
In 6.1, we allow user to specify title for every FileEntry, when uploading new document or editing / updating an existing one. If none is provided, we use the name of the file, that is being uploaded to the Document Library as part of the request.

For "Edit Document Online", ActiveX object is used, with WebDAV URL to the document. This WebDAV URL has the current version's Title at the end. This seems to prevent the ActiveX API to detect the document type and open accordingly selected MS Office program in OS. The Javascript call to ActiveX API is silently ignored.

Possible fixes:

1. Add input validator, which will make sure, that Title includes the correct extension for MS Office files (if user wants to use custom Title, different from uplaoded-file name).
2. Do not form WebDAV URLs for Online Editing with Title at the end of URL. E.g. use /api/secure/webdav/by-uuid/.../<file_UUID>.doc in the URL and then change the WebDAV servlet to lookup files based on UUID and not the folder name & Title like now.