This bug is based on Bug 84224. That bug was closed as WORKSFORME and now this new bug is filed for an enhancment request.

Problem Description:

When you save a file in ms excel 2010, on the file save dialog there is "Tools -> General Option -> Read-only recommended" option. When this option is enabled when you save a file, next time when you open this file with ms excel there will be a dialog pops up asking you whether you want to open the file read-only or edit the file.

But when you open such a "Read-only recommended" file in LibreOffice, it's open directly read-only. Althrough you can edit the file by clicking the "Edit File" icon in the toolbar, very few people know the exists of this icon thus they may think they are not able to edit this kind of file with LibreOffice.

This kind of file has the following tag:
docProps\app.xml:
...
<DocSecurity>2</DocSecurity>
...

See here:
http://www.sno.phy.queensu.ca/~phil/exiftool/TagNames/OOXML.html
OOXML Tags
 DocSecurity
 1 = Password protected
 2 = Read-only recommended
 4 = Read-only enforced
 8 = Locked for annotations

Suggested Improvements:
When this kind of "Read-only recommended" file is opened in LibreOffice, a pop-up dialog shows up, either:
* Tell the user the file is to be open read-only, if he/she want to edit the file, please click the "Edit File" icon on the toolbar.
* Ask whether he/she want to open the file read-only or want to edit the file. If the answer is "Edit", then LibreOffice should open the file in edit mode, otherwise in read-only mode.