https://bugs.documentfoundation.org/show_bug.cgi?id=100409
Bug ID: 100409
Summary: Functions in Calc - matrix is passed as argument ->
any text returns 0 instead
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
If a matrix is passed as argument to a function that expects a scalar
parameter and it is not in array/matrix mode, then the top left element
of the matrix is passed. However, if a numeric value is expected then
a text string should be converted according to the conversion settings,
which here are ignored and any text returns 0 instead. This affects not
only WEEKS. Seems I need to figure out a general handling.
=WEEKS(DATE(2014;11;1);DATE(2014;11;30);{"Hello";"Eike";"!"}) works. Should
trigger error.
So actually whether the result should be error or not should depend on
the settings, furthermore other values than 0 or 1 should return error
where currently all values not 1 are treated as 0.
Affect WEEKS, WEEKSINYEAR and other functions.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
