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