ods files locked

Issues with installing under all Linux Distributions

ods files locked

Postby Blind Legs Parker » Thu Dec 22, 2016 7:16 pm

All the ods files on my computer are locked. I can't access them even if I change their name or move them into another folder. Every time I try to open them a hidden file named .~lock.file_name.ods# is created and it comes back every time I delete it. I tried opening them on another computer and it worked, so the files are fine both for opening and editing. It's just that I can't open them.
I started happening after my computer was brutally shut down (it froze after running out of battery and I had to brute force it into shutting down by pulling the battery out).
I'm the only one using this computer. It's not on a network. I am storing most of my files on a partition that is shared in common between Ubuntu and Windows 7 though.

Also, if I try to open the files using both Ubuntu and Windows and the reaction is different with both: Windows simply starts an infinite loading loop and never actually opens the file, while Ubuntu opens an older version of them (like several months old).

I tried uninstalling OpenOffice and then reinstalling it but it didn't change anything.
The two weirdest things are that 1) as far as I recall OpenOffice wasn't running when the freezing happened and 2) only ods files are concerned and odt files still open normally.
OpenOffice 4.1.3 on Windows 7 and LibreOffice 5 on Ubuntu 16.04
Blind Legs Parker
 
Posts: 3
Joined: Thu Dec 22, 2016 6:49 pm

Re: ods files locked

Postby RoryOF » Thu Dec 22, 2016 7:30 pm

Start by deleting or renaming your OO User profile. Details are given in
https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=12426

You may need to do this for both your Windows and your Ubuntu installations.
Apache OpenOffice 4.1.4 on Xubuntu 16.04.03 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25518
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: ods files locked

Postby Blind Legs Parker » Fri Dec 23, 2016 6:56 am

Thanks for your help. I just did, though, but things remain unchanged and I still can't open the files.
OpenOffice 4.1.3 on Windows 7 and LibreOffice 5 on Ubuntu 16.04
Blind Legs Parker
 
Posts: 3
Joined: Thu Dec 22, 2016 6:49 pm

Re: ods files locked

Postby Zizi64 » Fri Dec 23, 2016 9:02 am

Try to install a version of the LibreOffice. If it work, that means the AOO software is damaged.
If the .ods diles work with the LO, then try to uninstall the AOO, and DELETE the remains parts manually after uninstall. (The User profile, and the remained files from the program directory, too.) Install it again with a newly downloaded install package.


If the .ods files do not work with the LibreOffice, then you can try to delete manually the ~lock files.
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.3 and AOO4.1.4
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6082
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: ods files locked

Postby Bill » Fri Dec 23, 2016 12:37 pm

Blind Legs Parker wrote:All the ods files on my computer are locked. I can't access them even if I change their name or move them into another folder. Every time I try to open them a hidden file named .~lock.file_name.ods# is created...

That hidden file is supposed to be created when you open a file. It is an indication that the file has been opened, not that it is locked. Is there an error message or some other indication that the files are actually locked?
AOO 4.1.4 on 64-bit Windows 10 and Manjaro Linux
Bill
Volunteer
 
Posts: 6397
Joined: Sat Nov 24, 2007 6:48 am

Re: ods files locked

Postby RoryOF » Fri Dec 23, 2016 1:32 pm

With OpenOffice closed, it is safe to delete the lock files. If you have a program or computer crash with OO files open, such lock files can be left and will prevent correct editing of those files subsequently. When a file is opened, be it a new file or an older file, a fresh lock file is generated. When the file is correctly closed the associated lock fle is deleted.
Apache OpenOffice 4.1.4 on Xubuntu 16.04.03 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25518
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: ods files locked

Postby Blind Legs Parker » Sat Dec 24, 2016 9:49 am

@Zizi64: I've already tried it all.

@Bill: Sometimes it would show a message that a specific ods file was shut improperly and that it would attempt to recover it. I've already tried both options to recover it and to ignore it. I haven't seen this message in a few days though. Now it justs starts the infinite loading loop without saying anything more.
For a reason that I don't comprehend I can now open ods files and edit them normally with Linux (also I've upgraded to Ubuntu 16.04 but even before I did so, the problem had already solved itself). Only good old Windows is keeping on with its bullshit.

Tonight this problem should be history anyway. This is seriously starting to get on my nerves and I've decided to wipe it all and restore factory settings.

Besides, I suspect my hard drive to be reaching the end of its life (other symptoms include video games saves mysteriously disappearing and being replaced with older saves) and it might be the reason for all this weirdness. I really don't want to spend money on a computer right now but I've already backed up all my files in the hypothesis that it might just not want to boot one morning in the coming days/weeks. The old chap is really getting old anyway (I bought it in December 2011, thus I think I can consider it had a rather good and long life). It's a pity because if it wasn't for that it's actually still running like a top.

Thanks for your help everyone.
OpenOffice 4.1.3 on Windows 7 and LibreOffice 5 on Ubuntu 16.04
Blind Legs Parker
 
Posts: 3
Joined: Thu Dec 22, 2016 6:49 pm

Re: ods files locked

Postby RoryOF » Sat Dec 24, 2016 12:34 pm

Look in the root of the Windows Profile of OO for a lock file. This should be level with the user folder and will be a hidden file. If you find one, delete this lock file and try again
Apache OpenOffice 4.1.4 on Xubuntu 16.04.03 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25518
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland


Return to Linux

Who is online

Users browsing this forum: No registered users and 4 guests