Issue 117393 - Implement regular expressions on arrays.
Summary: Implement regular expressions on arrays.
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 3.3
Hardware: All All
: P3 Normal with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-15 19:11 UTC by kneeruss
Modified: 2014-03-07 16:17 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
document showing errors (11.15 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-03-07 16:17 UTC, Joe Smith
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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"}}

=MATCH("^anytext2.*";A1:A3;0)
   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:
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=68167

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