Issue 117393

Summary: Implement regular expressions on arrays.
Product: Calc Reporter: kneeruss
Component: programmingAssignee: 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: ---
Description Flags
document showing errors none

Description kneeruss 2011-03-15 19:11:03 UTC
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"}}

   returns 2

This is feature or defect?
Comment 1 ooo 2011-03-16 14:21:19 UTC
RegEx on arrays aren't implemented.
Comment 2 Oliver-Rainer Wittmann 2012-06-13 12:17:51 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 3 Joe Smith 2014-03-07 16:16:45 UTC
This problem came up in a forum discussion:

I put together a test spreadsheet, attaching here.
Comment 4 Joe Smith 2014-03-07 16:17:55 UTC
Created attachment 82816 [details]
document showing errors