There is strange behaviour with file locking when xls file are accessed by LibreOffice and Excel. This behaviour (maybe) is common to all other program like Writer, Impress,... Situation: * user A with Excel 2000 * user B with LibreOffice 3.3 / OpenOffice 3.2 Example 1, step to reproduce: * user A open, modify,save and close "example.xml" file with Excel 2000 * user B open "example.xml" with LibreOffice 3.3 * user A open "example.xml" and Excel tell the user that file is opened by user A (expected: user B) * user A open "example.xml" with LibreOffice and the program tell the user that file is opened by user B (as expected) Example 2, step to reproduce: * user B open, modify,save and close "example.xml" file with LibreOffice 3.3 * user A open "example.xml" with Excel 2000 * user B open "example.xml" and LibreOffice tell the user that file is opened by "unknown user" (expected: user A) * user B open "example.xml" with Excel and the program tell the user that file is opened by user A (as expected) In mixed environment, Excel and Calc, seems that is not possible to know who is locking the file. If I know who is locking the file, for example, I could ask him to close the file.
In mixed environment, Excel and Calc, seems that is not possible to know who is locking the file. If I know who is locking the file, for example, I could ask him to close the file. This behaviour (maybe) is common to all other program like Writer, Impress,... Situation: * user A with Excel 2000 * user B with LibreOffice 3.3 / OpenOffice 3.2 Example 1, step to reproduce: * user A open, modify,save and close "example.xml" file with Excel 2000 * user B open "example.xml" with LibreOffice 3.3 * user A open "example.xml" and Excel tell the user that file is opened by user A (expected: user B) * user A open "example.xml" with LibreOffice and the program tell the user that file is opened by user B (as expected) Example 2, step to reproduce: * user B open, modify,save and close "example.xml" file with LibreOffice 3.3 * user A open "example.xml" with Excel 2000 * user B open "example.xml" and LibreOffice tell the user that file is opened by "unknown user" (expected: user A) * user B open "example.xml" with Excel and the program tell the user that file is opened by user A (as expected)
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Same behaviour in LODev 3.5.0beta2 . If you try to open a file that is already opened by Microsoft Excel, Lib0 tell me that the file is locked by "unknown user". This info is useful only if there is a name and if the name is correct. Obviously, all software (Excel and LibO) have a registered user.
I tried reproducing this with LO 4.0.1.1 (nightly). * I created an excel file and saved that to example.xml * then Opened that file in LO while keeping excel open * modify then tried to save file in LO * choose XML (instead of odf) -> crash (log: http://pastebin.com/iyiSbTZa) This is still valid for LO 4.0.1.1. Also the crash is reproducible. Setting platform from "Windows" to "All" since I'm on OS X. Since this results in a reproducible crash of LO setting importance from "medium" to "high" and severity from "normal" to "major". Maybe a dev can look into this?
*** Bug 64391 has been marked as a duplicate of this bug. ***
(In reply to comment #4) > I tried reproducing this with LO 4.0.1.1 (nightly). > * I created an excel file and saved that to example.xml > * then Opened that file in LO while keeping excel open > * modify then tried to save file in LO > * choose XML (instead of odf) > -> crash (log: http://pastebin.com/iyiSbTZa) Seems this should be filed in new bug report.
bfoman: done: https://www.libreoffice.org/bugzilla/show_bug.cgi?id=68139 Not sure what's up with this bug here. Could you try reproducing with latest LO?
No feedback for 2 months. Setting to NEEDINFO.
Could some MS-Office / MS-Windows user explain how MS-Office's locking file system works? In the case of LibreOffice the name of the current user is filed in the lock file (.~lock.<filename>#). Best regards. JBF
(In reply to comment #9) > Could some MS-Office / MS-Windows user explain how MS-Office's locking file > system works? > In the case of LibreOffice the name of the current user is filed in the lock > file (.~lock.<filename>#). The same is for MS Office - you can find user data in the lock file ~$filename.
Thank you for the answer and sorry for taking it into account so late. Can't test with MSO, so set status back to unconfirmed. Best regards. JBF
set back importance and priority to default values because comment #4 is another bug. Best regards. JBF
Sorry, my bad, the status of this bug report shouldn't be unconfirmed but new or needinfo. As the question in comment #7 has not been answered I set the status back to needinfo. Best regards. JBF
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.