https://bugs.freedesktop.org/show_bug.cgi?id=78375
Priority: medium
Bug ID: 78375
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Other: Calling MATCH with
com.sun.star.sheet.FunctionAccess returns
Variant/Empty
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: zza...@gmail.com
Hardware: Other
Whiteboard: BSA PossibleRegression
Status: UNCONFIRMED
Version: 4.2.3.3 release
Component: Spreadsheet
Product: LibreOffice
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
