https://bugs.documentfoundation.org/show_bug.cgi?id=94079
--- Comment #8 from Mike Kaganski <mikekagan...@hotmail.com> --- (In reply to Winfried Donkers from comment #7) > See > http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2. > html#__RefHeading__1017866_715980110 I followed every clause of 3.3 Non-Scalar Evaluation (aka 'Array expressions'), and still cannot find a place that would cover this case. Both Parts 1 and 2 are about functions taking scalar where a matrix is passed, and discuss which cell of passed matrix should be used as actual argument to the function in specific position. Part 2.2 describes how to process when (different-sized) matrices are passed as arguments that are expected to combine with each other. Example in Note 13 gives a good example for that. The NETWORKDAYS problem lies in a different area: it expects a matrix in its third argument, and the size of array isn't required to correspond to something in any way; its function is only to extract those dates that are in the range of bounding dates and not weekends, and to subtract their number from scalar result. If the rmatrix contain empty cells, but at least one cell is non-empty (but even if it is outside of dates range), current implementation works OK: A1: 2001-01-01. B1: empty A2: =NETWORKDAYS(NOW();NOW()+6;A1:B1) A2 -> 5 Here A1 is outside the range, and B1 is empty, still function works. I beleive that all-empty-cells array should be equally legal. -- 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