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 +0000
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]
