A user has created a file in MS Excel and set it to protected mode which defaults the user to open the file in Read Only mode. When opening the file in MS Excel, this correctly opens in Read Only mode and only when you try to "Enable Editing" does the file switch to Read-Write mode. When opening (by double clicking on the file) the same file in LibreOffice it correctly opens in Read Only mode (as shown on the task bar) but it still creates a -lock file. When a second user opens the file in MS Excel or LibreOffice the file says it is locked and can only be opened in Read Only mode. Now with the document closed in both Excel and LibreOffice .... Open LibreOffice and from the File Menu, open the document but tick the "Read Only" checkbox and proceed to open the document. Now the document pens but NO .~lock file is created. Now when opening a second instance of the document from either LibreOffice or Excel the application correctly assumes the document is not locked by a user and thus opens the document. The bug here seems to be when you open the document by double clicking on the file and opening in LibreOffice instead of Opening the document in RO mode from the File/Open menu. I have tested this in LibreOffice 6.4.5 and 7.0.0+ Thank you
> > The bug here seems to be when you open the document by double clicking on > the file and opening in LibreOffice instead of Opening the document in RO > mode from the File/Open menu. > From my perspective the issue is that LibreOffice doesn't honor the "Open Read-Only" setting from the document at all when it comes to create a lock file or not. A lock file is always created, regardless of the documents settings. Only selecting "Read-Only" in the file picker dialogs prevents from lock file creation.
> From my perspective the issue is that LibreOffice doesn't honor the "Open > Read-Only" setting from the document at all when it comes to create a lock > file or not. A lock file is always created, regardless of the documents > settings. Only selecting "Read-Only" in the file picker dialogs prevents > from lock file creation. ... and I'd state the bug the following: LibreOffice doesn't remove the lock file after having opened a file and recognized that it has a read-only setting.
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone else confirms it.
Attaching an example file in protected mode would be nice... I tried to create a protected spreadsheet in Excel 2003, and failed.
Created attachment 171410 [details] Empty Spreadsheet, created as "new empty file", but then saved as xlsx and marked as "open in write protect mode"
This is an (otherwise empty) spreadsheet. When opened in Calc by double clicking, there are created: .~lock.OpenDocument Tabellendokument (neu).xlsx# ~$OpenDocument Tabellendokument (neu).xlsx Calc is nevertheless in write protected mode. Calc 7.0.4.2 (x64), Win 10
Sorry, don't know which files are created (and immediatley deleted, maybe?). I meant "there are existing"
example file added
(In reply to Peter from comment #5) > Created attachment 171410 [details] > Empty Spreadsheet, created as "new empty file", but then saved as xlsx and > marked as "open in write protect mode" Of course the other way around. 1st created (by means of explorer's "new file" menu, opened with Calc 7.0.4.2, there marked as ..., then saved as xlsx