Bug 77015

Summary: Spreadsheet MATCH function fails when accessed through com.sun.star.sheet.FunctionAccess service
Product: LibreOffice Reporter: DonJaime
Component: BASICAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium CC: contact
Version: 4.2.2.1 release   
Hardware: All   
OS: All   
Whiteboard:
i915 platform: i915 features:
Attachments: Sample spreadsheet accessing MATCH directly and through a macro

Description DonJaime 2014-04-03 16:13:49 UTC
Created attachment 96857 [details]
Sample spreadsheet accessing MATCH directly and through a macro

When I use the com.sun.star.sheet.FunctionAccess aservice to access the MATCH function, it returns 0. At least some other functions work properly. This bug seems to be new in 4.2: it wasn't there in 4.1.5.3
Comment 1 contact 2014-04-09 19:27:17 UTC
(In reply to comment #0)
> Created attachment 96857 [details]
> Sample spreadsheet accessing MATCH directly and through a macro
> 
> When I use the com.sun.star.sheet.FunctionAccess aservice to access the
> MATCH function, it returns 0. At least some other functions work properly.
> This bug seems to be new in 4.2: it wasn't there in 4.1.5.3

I confirm the bug with the MATCH function and also with the VLOOKUP function in 4.2. It works without problem in 4.1.5.3
Comment 2 pierre-yves samyn 2014-04-14 07:47:27 UTC
Hello

I reproduce on windows 7/64 with 
Version: 4.2.3.3
Build ID: 882f8a0a489bc99a9e60c7905a60226254cb6ff0

Also reproduced (fr-sers) on Linux Mint 14 and Windows XP SP3.

I set status to New.

Regards
Pierre-Yves

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.