Hugo's blog

Sjouke and I just ran into a minor hitch with a spreadsheet: some cells were protected, and in the new Ubuntu / Open/LibreOffice version they just looked plain wrong.
How to fix this?
Turns out that protection isn’t that hard to break. In a nutshell, an .ODS file is very much like an EPUB file — it’s also a ZIPped file which also contains a structure with a mimetypes file and a content.xml file.

To remove protection, edit contents.xml and change the attribute *protected="true" to say false. Rezip the file in the correct way, that is: store mimetype uncompressed as the first file, the rest doesn't really matter. Et voila, you have removed protection!

In a nutshell:

mkdir tmp
cd tmp
unzip ../FILE.ods
sed 's/protection="true/protection="false/g' content.xml c2.xml
mv c2.xml content.xml
zip -0X ../FILE-unprotected.ods mimetype
zip -r9 ../FILE-unprotected.ods * -x mimetype


For a while now I’ve been wondering how to do the equivalent of jot (which generates a list of numbers) in ZSH. It’s pretty obvious that ZSH could do such a thing, but how? Jot isn’t installed by default, and I am lazy. Lazy enough to never look into it.

For a change, I did. Success! Here is one way to do it, which is sort of elegant:
while (( i++ < 10 )) { echo i is $i; }
Do note the remarks on the above link: playing around with the syntax might kill it quickly.
Using repeat might be neater, but that's only when you just need to iterate (and not keep track of the iteration).