https://bugs.documentfoundation.org/show_bug.cgi?id=168267

            Bug ID: 168267
           Summary: functionaccess.callFunction() should be empowered to
                    pass the information about missing arguments to the
                    called function.
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: sdk
          Assignee: [email protected]
          Reporter: [email protected]

A few Calc functions treat the missing of an argument as a positive
information:

INDEX(sheeCellRangeReference; ; 2) returns the complete second column of the
range data. (Respectively for full row.)

REGEX("abcdeed§ba"; "d."; ; 2) doesn't replace anything, but returns the second
occurrence of "d" followed by any singleCharacter. That's "d§" for the example.

(Are there additional cases?)

e.g.

fa  = CreateUNOService("com.sun.star.sheet.FunctionAccess")
got = fa.callFunction("REGEX", Array("abcdeed§ba"; "d."; ; 2))

should result in got = "d§". Actually it causes an error "Wrong number of
arguments".

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to