ODSpassword be gone

May this post help Google to help those poor souls who try to remove OpenOffice sheet and document passwords in vain.
Because until now, their only remorse has been a bunch of expensive shareware crap.

Pray to the Perl lord and You shall be enlightened ….

#!/bin/sh

unzip "$1" content.xml
perl -pi \
-e '
s/table:protected="true" *//g;
s/table:structure-protected="true" *//g;
s/table:protection-key="(.*?)" *//g' \
content.xml
zip "$1" content.xml
rm -f content.xml