https://bugs.freedesktop.org/show_bug.cgi?id=61990
Priority: medium
Bug ID: 61990
Assignee: [email protected]
Summary: Enhancement request: Support Excel wildcards in
database/sumif criteria via preference
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
The document standards define two styles of wildcard in criteria. LO supports
regex, but not the Excel "wildcard" version. The Excel version is a simple
subset of REs (but with conflicting syntax).
The consequence is that there can be huge differences in the result of a
formula using an Excel-style wildcard.
For example,
=sumif(A1:A10,"paypal*",B1:B10)
in Excel
will match any cell with the string paypal
This formula imports literally into LibreOffice. If regular expressions are
turned on, the criteria is interpreted as a RE. However, what the Excel
wildcard really means is "paypal.*"
Further, Excel uses ? to stand for one character and it uses ~ as the escape
character.
The criteria are used in the "database" family of functions (and sumif)
My request is that there be an preference "use Excel-style wildcards" and that
this be enabled by default for spreadsheets in Excel format.
I think this would close some potentially subtle but huge incompatibilities.
--
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
