Ask Your Question

LibreAddict's profile - activity

2017-03-21 22:32:09 +0200 received badge  Teacher (source)
2017-03-21 22:32:09 +0200 received badge  Necromancer (source)
2014-10-06 18:40:28 +0200 answered a question I can not open my spreadsheet it comes up with this error: Read-Error. Format error discovered in the file in sub-document content.xml at 2,72157(row,col).

To add to @Regina 's great answer, the error I found in the content.xml file wasn't in the mentioned cell number. It was enough to extract the content.xml file and open it in a browser to see that some styling attribute at the beginning of the document was for some reason duplicated. Removing the duplication and putting back the content.xml file in the ods file using a zip utility fixed the problem. It is worth mentioning that updating the content.xml to the ods file wasn't successful in Mac OS X. The archiving tool did not produce a valid ods file after zipping the directory content. I had to switch to Linux and took a couple of minutes to solve the problem. Maybe a tool on windows works fine as well.

2014-04-22 20:57:48 +0200 answered a question suddenly, all .odt files are locked by 'Unknown User'

If you have left over hidden lock files (.~lock.xxxxx.odt#) where xxxx.odt file is the original file name try deleting them first then opening the odt file again.