| Summary: | MATCH function returns wrong result | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | lysu98 |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | miguelangelrv |
| Priority: | medium | ||
| Version: | 4.0.4.2 release | ||
| Hardware: | x86 (IA32) | ||
| OS: | macOS (All) | ||
| See Also: | https://bugs.freedesktop.org/show_bug.cgi?id=88581 | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Example data, formula used, and wrong results marked | ||
|
Description
lysu98
2013-12-16 02:50:16 UTC
Created attachment 90815 [details]
Example data, formula used, and wrong results marked
Hi lysu98, thanks for reporting. MATCH() function accepts regular expressions for search and + is one of them, so there are two options: - Disable regular expressions in Menu/Tools/Options/LibreOffice calc/Calculate - Enable regular expressions in formulas. - Replace/substitute + with \+ in the search criterion. e.g. SUBSTITUTE(D12;"+";"\+") instead D12 Changed status to NOTABUG, please if you are not agree reopen it. Thanks!
-- Lingyun
> On Dec 16, 2013, at 9:32 PM, bugzilla-daemon@freedesktop.org wrote:
>
> mariosv changed bug 72739
> What Removed Added
> Status UNCONFIRMED RESOLVED
> Resolution --- NOTABUG
> CC mariosv@miguelangel.mobi
> Comment # 2 on bug 72739 from mariosv
> Hi lysu98, thanks for reporting.
>
> MATCH() function accepts regular expressions for search and + is one of them,
> so there are two options:
> - Disable regular expressions in Menu/Tools/Options/LibreOffice calc/Calculate
> - Enable regular expressions in formulas.
> - Replace/substitute + with \+ in the search criterion.
> e.g. SUBSTITUTE(D12;"+";"\+") instead D12
>
> Changed status to NOTABUG, please if you are not agree reopen it.
> You are receiving this mail because:
> You reported the bug.
|