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
An example file would indeed be useful. Marking as NEEDINFO - once you attach a simple example please set the bug to UNCONFIRMED. Thanks!
I have installed LibreOffice 4.2.4.2 (Build ID: 420m0) and this bug isn't present anymore.
Migrating Whiteboard tags to Keywords: (possibleRegression) [NinjaEdit]