Bug 63995 - MSO XML documents are locked longer than expected
Summary: MSO XML documents are locked longer than expected
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: filters and storage (show other bugs)
Version:
(earliest affected)
4.0.3.1 rc
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 100230 (view as bug list)
Depends on:
Blocks: File-Lock
  Show dependency treegraph
 
Reported: 2013-04-27 12:39 UTC by Urmas
Modified: 2023-03-09 22:32 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
Example (1.69 KB, text/xml)
2013-12-22 07:55 UTC, Urmas
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Urmas 2013-04-27 12:39:58 UTC
1. Open CSV file with Calc
2. Close file in Calc
3. Try to open the file with other application

Expected result: File opened for read/write
Actual result:   File can be opened only for reading, sharing violation otherwise.

You need to close Calc APP ENTIRELY to unlock the file! That's BS.
Comment 1 Thomas van der Meulen [retired] 2013-04-27 17:30:33 UTC
Hello Urmas, I can't confurm this bug running LibreOffice 4.0.3.1 on mac osx 10.8.3 or LibreOffice 4.0.2.2 on Ubuntu 13.04. I will test this bug on Windows later this week.
Comment 2 Joel Madero 2013-04-30 22:19:31 UTC
What other application? Any? Notepad for instance?
Comment 3 Joel Madero 2013-05-01 03:17:29 UTC
Cannot confirm on Windows 7 on either 3.6.0.4 release nor on Tinderbox from three days ago.

Steps:
1. Open a CSV in Spreadsheet
2. Close CSV but keep LibreOffice open
3. Open CSV with notebad


Behavior:

File opens read/write in notepad


I don't see the file locked in read only mode.


Urmas - what operating system?
Comment 4 Urmas 2013-05-04 21:11:04 UTC
This issue presents for both Excel and Word XML format documents.
Comment 5 Anton Derbenev 2013-07-17 11:46:30 UTC
I've met this behavior with several LO 4.0.x versions on multiple machines with Windows XP, Vista, 7 (both 32 and 64-bit), 8 (64-bit). For me, this is sign that LO will crash soon (on next save often), loosing data.
Comment 6 retired 2013-12-21 15:48:36 UTC
Can you please provide a test document so this can be tested against and subsequently be confirmed. If your document contains sensitive data, please clear that or replace it with random information.

Do any of you still experience this problem with LO 4.2.0.1: http://www.libreoffice.org/download/pre-releases/

Setting to NEEDINFO until more detail is provided.

After providing the requested info, please reset this bug to NEW. Thanks :)
Comment 7 Urmas 2013-12-22 07:55:16 UTC
Created attachment 91116 [details]
Example
Comment 8 QA Administrators 2015-04-19 03:23:31 UTC Comment hidden (obsolete)
Comment 9 Buovjaga 2015-06-19 13:59:27 UTC
No problem here. Fresh testing really appreciated.

Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+
Build ID: 437210d58f32177ef1829d704f7f4d2f1bbfbfdd
TinderBox: Win-x86@39, Branch:master, Time: 2015-06-18_07:21:56
Locale: fi-FI (fi_FI)
Comment 10 Buovjaga 2016-06-13 11:57:27 UTC
*** Bug 100230 has been marked as a duplicate of this bug. ***
Comment 11 QA Administrators 2017-09-01 11:20:46 UTC Comment hidden (obsolete)
Comment 12 QA Administrators 2021-02-19 04:22:53 UTC Comment hidden (obsolete)
Comment 13 QA Administrators 2023-02-20 03:19:33 UTC Comment hidden (obsolete)
Comment 14 Stéphane Guillou (stragu) 2023-03-09 22:32:36 UTC
Using the steps in duplicate's https://bugs.documentfoundation.org/show_bug.cgi?id=100230#c0 :

0. Calc is not running.
1. Open any excel 2003 xml file (for example 1.xml).
2. Open any ods file (for example 1.ods). (do not close 1.xml!).
3. Close 1.xml (do not close 1.ods!).
4. Open 1.xml - you get message "Document file '1.xml' is locked for editing by xyz

...I could reproduce in 6.0.0.3.

However, I couldn't reproduce with:

Version: 6.4.0.3 (x64)
Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: default; VCL: win; 
Locale: en-GB (en_GB); UI-Language: en-GB
Calc: threaded

So fixed somewhere in between.