Q:

Where is openoffice.org add-on located after installed (Ubuntu)?

I installed a tool which now appears in Openoffice Calc under Tools->Add-ons. 
I thought that this tool would appear in ~/.openoffice.org/3/user directory, but I cannot find it. 
I am especially searching for config files of this addon e.g. where it saves its data (the tool ads custom styles for certain cells). 
Can anyone help me?

A:

JoeM, all names starting with dot (as /.openoffice/) are hidden in Linux by default - perhaps that's the reason you cannot find the location.
Try this solution:

Go to your home folder. Open .openoffice.org2 [.openoffice.org/3/ in your case]. This can be done in nautilus just fine. To view hidden folders and files (those starting with ‘.’), just hit Control-h.
Go into the user folder.
Delete or rename the ‘uno_packages’ folder. I renamed it, personally, so I could put it back if needed.
Start OpenOffice. It will be just like new.

[source]

