Frequently asked questions - Calc
How to find all the special characters in a document
The procedure is identical to that described for the Writer module Faq/Writer/152
Apart from the possibilities described in that FAQ, the spreadsheet module allows you to search in the formulas or the values. This can definitely have an effect if you are searching, for example, for the $ sign.