Bug 78375 - Other: Calling MATCH with com.sun.star.sheet.FunctionAccess returns Variant/Empty
Summary: Other: Calling MATCH with com.sun.star.sheet.FunctionAccess returns Variant/E...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.3.3 release
Hardware: x86-64 (AMD64) Linux (All)
: high normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords: possibleRegression
Depends on:
Blocks:
 
Reported: 2014-05-07 08:17 UTC by Zarko Zivanov
Modified: 2015-12-15 10:55 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Zarko Zivanov 2014-05-07 08:17:51 UTC
Problem description: 

I have the following code many times in my pretty large LO Basic section (with variations in cell range and search criteria):

Functions = createUnoService("com.sun.star.sheet.FunctionAccess")
dim StudentsArgs(2) as variant
StudentsArgs(0) = Index.Formula 'just some string to search for
StudentsArgs(1) = StudentiSheet.getCellRangeByPosition(StudentiIndeksCol,STUDENTIHEADERROW+1,StudentiIndeksCol,StudentiEndRow) 'some cell range for searching
StudentsArgs(2) = 0
StudentRow = Functions.callFunction("MATCH", StudentsArgs())

In Ubuntu 13.10 I am using LO from LO PPA, version 4.1.3.2 and the code above works as expected (it returns the row number).

A few days ago I tried Ubuntu 14.04 that comes with LO 4.2.3.3. In this version, calling a MATCH function always returns me Variant/Empty instead of row number. All the parameters have the same value in both versions of LO before reachng MATCH call (I checked in debugger).

Was there some change in callFunction mechanism, or the way that MATCH function works between the versions?

I cant't at the moment make an example ods for testing, but I can in a few days, if needed.
Operating System: Ubuntu
Version: 4.2.3.3 release
Last worked in: 4.1.3.2 release
Comment 1 Joel Madero 2014-06-21 03:28:31 UTC
An example file would indeed be useful. Marking as NEEDINFO - once you attach a simple example please set the bug to UNCONFIRMED. Thanks!
Comment 2 Zarko Zivanov 2014-08-04 10:03:07 UTC
I have installed LibreOffice 4.2.4.2 (Build ID: 420m0) and this bug isn't present anymore.
Comment 3 Robinson Tryon (qubit) 2015-12-15 10:55:02 UTC
Migrating Whiteboard tags to Keywords: (possibleRegression)
[NinjaEdit]