Ask Your Question

Per file option "Enable regular expressions in formulas" in LibreOffice Calc

asked 2015-04-20 09:17:23 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-04-20 09:59:57 +0200

karolus gravatar image

This Option ( and many others ) is already a per file-option, because the setting is stored into the file.

unfortunatly - if you change it, the changed Option will reflect to all currently open files

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-04-20 09:17:23 +0200

Seen: 259 times

Last updated: Apr 20 '15