Bug 82633

Summary:	a new document has regular expression enabled in formulas by default
Product:	LibreOffice	Reporter:	Jérôme <jerome.bouat>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	enhancement
Priority:	medium	CC:	jmadero.dev
Version:	4.1.6.2 release
Hardware:	All
OS:	All
Whiteboard:
i915 platform:		i915 features:

Description Jérôme 2014-08-14 21:29:05 UTC

When I create new document, the "enable regular expression in formula" option is checked by default.

Many user are former M. Excel users. They will have the feeling that Calc formulas have strange behaviours before they understand the search term is a regular expression. If we're not lucky, they will not understand this behaviour and they will reject the use of LibreOffice.

Moreover, many formulas like "vlookup" are mostly used for searching a term which isn't a regular expression. This fixed term is often the reference of a cell. The value pointed by this cell reference is seldom a regular expression. This allow a copy the formula to the bottom of the sheet in order to change the search term with the line.

If a user actually want to use a regular expression, I think he has enough skills to enable this feature into the options of the document.

Comment 1 Joel Madero 2014-11-20 05:01:40 UTC

Default behavior is always a mixed bag - you're going to have arguments on both side. That being said, it's a fine enhancement reques and if someone wants to try to implement it, they are free to do so.


Thanks for the suggestion. Setting as NEW

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.