Is there any way to create document-depended option “Enable regular expressions in formulas”? As I understand, enabling this option globally can broke (change results) some formulas, when opening other XLS or ODS documents.
For example, formula =COUNTIF(A1:A100,'1.')
is regexp-depended.
So I afraid to enable this option globally, because I can see wrong results in some documents. Can I write macros or other feature that will enable regular expressions in formulas only for current document, and stay this option disabled for all other documents?