[Libreoffice-bugs] [Bug 112404] SEARCH function of Calc called via the FunctionAccess service does not apply HOST-USE-REGULAR-EXPRESSIONS if true.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112404

Wolfgang Jäger <jag at psilosoph.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jag at psilosoph.de

--- Comment #2 from Wolfgang Jäger <jag at psilosoph.de> ---
(In reply to Eike Rathke from comment #1)
> This seems to be related to the new default being Wildcards instead of
> Regexp, for Excel compatibility ...
> ... The
> scratch environment in which the function call is executed is initialized
> with default options, not configuration options, to have the same default
> behaviour through API calls.

Thanks. I didn't know that. It's the better way, of course, as it allows to
call a SEARCH (or similar) based function via the FunctionAccess service from
any type of document.

> ... 
> We maybe could merge this setting from the current document where the macro
> is executed, but that would need detection first whether the property was
> already set via the service to not override that one..

I now did that by the user code based on the properties of the respective
document (in my case ThisComponent), checking in advance if the properties
'RegularExpressions' and 'Wildcards' exist, which only should be the case if
the service com.sun.star.sheet.SpreadsheetDocument is supported, and the
running version is >= 5.2.  

> Explicitly setting the property nevertheless is the cleaner approach if you
> know the function should handle regexp as in this case.

Yes, that's clearly the better way. Thanks again. 

One question remaining nonetheless: Where are the ways SEARCH or other
functions supporting 'Wildcards' should work specified? I couldn't find
anything of value.

Regarding the above I would suggest to set the bug RESOLVED NOTABUG.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170916/1ebbac52/attachment.html>