Ask Your Question
0

Calc Tools Options not saved

asked 2016-03-11 20:56:02 +0200

paparucino gravatar image

Hi all, a member of the forum suggested me to enable Tools-Options-Calc-Calculate.Enable.regular.expressions.in.formulas to solve a problem. I did then pressed OK to save it and everything worked fine but when I re-opened the file the above option wasnt setted. Further investigation in LibreOffice-Advanced-Expert Configuration showed that .../Calculate/Other_RegularExpressions is set to true and is always set to true while the check box returns blank after every launch of Calc.

Is it possible to have the flag permanently setted?

Thank you in advance paparucino

P.S. I use LO Version: 5.0.5.2

edit retag flag offensive close merge delete

Comments

Sorry. I clicked the wrong tag. This is not a duplicate queastion

paparucino gravatar imagepaparucino ( 2016-03-14 14:47:39 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2016-03-13 17:32:22 +0200

brucehohl gravatar image

If using regular expressions in a spreadsheet saved in xls or xlsx format then each time spreadsheet is opened regular expressions must be enabled. Regular expression are not supported by Excel by excel so it seems sensible that by default regular expressions are disabled when opening an xls or xlsx file.

If regular expressions are wanted by default save in ods format.

edit flag offensive delete link more

Comments

Thank you. I will evaluate your suggestion since .xls file are on Dropbox and Im not sure the other members can read .ods files.

paparucino gravatar imagepaparucino ( 2016-03-14 14:42:06 +0200 )edit

If an ODS file with regular expressions is opened in Excel, formulas using regular expressions will be evaluated and the values will be put into the cells (instead of the formulas). So effectively Excel can read regular expressions but not write regular expressions.

brucehohl gravatar imagebrucehohl ( 2016-03-17 02:48:55 +0200 )edit

@brocehohl: It should not be a question of reading and writing, but of reliably evaluating to the unchanged result. As there are many variants of RegEx syntax and of engines evaluating them, using RegEx always is a challenge to interoperability, and should be avoided where possible in "volatile" documents. There are differences, and it might not be the best idea to wait for nasty errors and to investigate the reasons subsequently.

Lupp gravatar imageLupp ( 2016-04-11 21:54:33 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-03-11 20:56:02 +0200

Seen: 107 times

Last updated: Mar 13 '16