[sc-issues] [Issue 16786] Need better control of reg exp in vlookup
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=16786 User bh changed the following: What|Old value |New value Assigned to|bh|requirements --- Additional comments from b...@openoffice.org Fri May 21 14:15:46 + 2010 --- To grep the issues easier via requirements I put the issues currently lying on my owner to the owner requirements. --- Additional comments from n...@openoffice.org Tue Sep 28 14:40:40 + 2010 --- *** Issue 44295 has been marked as a duplicate of this issue. *** - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 16786] Need better control of reg exp in vlookup
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=16786 --- Additional comments from n...@openoffice.org Tue Sep 28 14:42:26 + 2010 --- *** Issue 99472 has been marked as a duplicate of this issue. *** - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 16786] Need better control of reg exp in vlookup
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=16786 --- Additional comments from prowlerx...@openoffice.org Fri Jan 8 15:23:09 + 2010 --- I agree, is a defect, a workaround is to use SUBSTITUTE function (in Italian SOSTITUISCI) that substitute the characters used in regular expression (* or + with \* and \+) to be used with the functions like HLOOKUP or COUNT.IF (CONTA.SE($B$3:$B$1000;=SOSTITUISCI(SOSTITUISCI(L3;*;\*);+;\+)) ). A solution could be a new function like HLOOKUP.NOREGEXPR where the text is always considered plain text or add an optional parameter in the function (1 or 0 to have or not to have regular expression considered) but as suggested in Italian list this could give some compatibility problems with microsoft office - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 16786] Need better control of reg exp in vlookup
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=16786 User prowlerxpla changed the following: What|Old value |New value CC|'drking' |'drking,prowlerxpla' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 16786] Need better control of reg exp in vlookup
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=16786
--- Additional comments from [EMAIL PROTECTED] Mon May 5 11:21:30 +
2008 ---
I agree that being unable to enable/disable regex in a cell is a bad thing.
Same thing applies to 'whole cell matching'.
Possibly worse is that the regex setting is rather hidden away, so the user may
be unaware that his results are wrong.
One way around this would be to introduce a new function, say SETTINGS, similar
to STYLE. Whereas STYLE sets the cell colours etc, SETTINGS could control
regex, whole_cell_matching and maybe other things.
Unfortunately STYLE was designed to return 0, which means it has to be wrapped
in another function (eg T() or IF()) when used with text. STYLE appears to be
unique to Calc.
A typical construction with SETTINGS if it also returned 0 might be:
=IF(SETTINGS(1; 0); ; HLOOKUP())
An alternative if inline arrays were changed to be able to accept formulae:
={HLOOKUP(); SETTINGS(1; 0)} entered in scalar mode.
I'm not entirely sure this is all good - there might be implications with ODFF,
which has global regex/wildcard flags I think. I'm merely sharing an idea - a
possible solution.
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 16786] Need better control of reg exp in vlookup
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=16786 User drking changed the following: What|Old value |New value CC|''|'drking' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
