|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | Implement regular expressions on arrays. | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Calc | Reporter: | kneeruss | ||||
| Component: | programming | Assignee: | AOO issues mailing list <issues> | ||||
| Status: | CONFIRMED --- | QA Contact: | |||||
| Severity: | Normal | ||||||
| Priority: | P3 | CC: | issues, jes, ooo | ||||
| Version: | OOo 3.3 | ||||||
| Target Milestone: | --- | ||||||
| Hardware: | All | ||||||
| OS: | All | ||||||
| Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- | ||||
| Developer Difficulty: | --- | ||||||
| Attachments: |
|
||||||
RegEx on arrays aren't implemented. getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used. This problem came up in a forum discussion: https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=68167 I put together a test spreadsheet, attaching here. Created attachment 82816 [details]
document showing errors
|
Regular Expression not working with array (or functions returning one), only range references, for built-in functions like MATCH for example. =MATCH("^anytext2.*";{ "anytext1" ; "anytext2" ; "anytext3" }; 0) for example returns #N/A yet works with no regular expression: =MATCH("anytext2";{"anytext1";"anytext2";"anytext3"}; 0) returns 2 yet... works if putting an array in cell A1: {={"anytext1" ; "anytext2" ; "anytext3"}} =MATCH("^anytext2.*";A1:A3;0) returns 2 This is feature or defect?