https://bugs.freedesktop.org/show_bug.cgi?id=82633

          Priority: medium
            Bug ID: 82633
          Assignee: [email protected]
           Summary: a new document has regular expression enabled in
                    formulas by default
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: [email protected]
          Hardware: Other
            Status: UNCONFIRMED
           Version: 4.1.6.2 release
         Component: Spreadsheet
           Product: LibreOffice

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to