Bug 77015 - Spreadsheet MATCH function fails when accessed through com.sun.star.sheet.FunctionAccess service
Summary: Spreadsheet MATCH function fails when accessed through com.sun.star.sheet.Fun...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version: 4.2.2.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-04-03 16:13 UTC by DonJaime
Modified: 2014-04-14 07:47 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:

Attachments
Sample spreadsheet accessing MATCH directly and through a macro (14.27 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-04-03 16:13 UTC, DonJaime 		Details
View All

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.