Calc allows you to use regular expressions (wildcards) in filters and functions. However, if you want to use wildcards in functions, this must be enabled via Tools -> Options-> OpenOffice.org Calc-> Calculate page
In List of regular expressions you can find the wildcards you can use in Calc.
I use shortcut keys as much as possible, so it’s very easy that OOoAuthors.org has published an appendix with the default Calc shortcut keys. I prefer to have them all together in one Calc sheet, which I added to this post.
Download Calc Default Shortcuts Keys
When you use Calc in several languages — I use the Dutch and English language version — you’re sometimes looking for a function name in an other language. You could open the file in the other language version of Calc to find the name to use, but it’s far easier to have a reference sheet.
With information from the excellent le Tableur Calc par l’exemple (French) I put the functions in seven languages (English, German, French, Dutch, Spanish, Italian, Polish) side by side in a Calc reference sheet.
Download Calc Multilingual Functions.ods
