https://bugs.documentfoundation.org/show_bug.cgi?id=133910
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- OS|Windows (All) |All Summary|UNO: `callFunction`does not |UNO: `callFunction`does not |accept optional Array |accept one-dimensional |parameter |Array parameter Hardware|x86-64 (AMD64) |All Severity|normal |enhancement Version|7.0.0.0.beta1+ |Inherited From OOo --- Comment #12 from Eike Rathke <[email protected]> --- Note that this oFA.callFunction( "WORKDAY", Array( "2020-06-08", 1, "2020-06-09", "2020-06-10")) can not work as it passes 4 arguments to WORKDAY that expects only 3. This oFA.callFunction( "WORKDAY", Array( "2020-06-08", 1, holidays)) could work if holidays was declared as a two-dimensional array (array of arrays) as the definition of XFunctionAccess::callFunction() states, see https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1sheet_1_1XFunctionAccess.html#aaed56cc122754b1cfaf2edf7fcca91a8 So either for a column vector of rows dim holidays(1,0) holidays(0,0) = "2020-06-09" holidays(1,0) = "2020-06-10" or for a row vector of columns holidays = Array(Array("2020-06-09", "2020-06-10")) However, WORKDAY() for Excel legacy compatibility is an Add-In function (hence the code pointers of comment 7 are unrelated) that does not parse dates, all date values MUST be passed as date serial numbers, so this specific call wouldn't work anyway. Summarized, this is actually a request for enhancement (RFE) to accept one-dimensional arrays as well, which I'm reluctant to implement because it would be an incompatibility and such newer macro code would not run with an older LibreOffice release. -- You are receiving this mail because: You are the assignee for the bug.
