https://bugs.documentfoundation.org/show_bug.cgi?id=91605
Bug ID: 91605
Summary: Automatic conversion of text to number failing applyed
to array under "iterative" evaluation
Product: LibreOffice
Version: unspecified
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
http://ask.libreoffice.org/en/question/51087/array-formula-calc-4432/
The above URL will open a forum thread dicussing the issue rather detailed. It
is, however, independent of the fact that the original question referred to an
example gotten from an XLSX file.
In short:
A range containing texts (strings) syntactically acceptable as numbers should
automatically convert to numerical values if used as an operand of an
arithmetic expression. (Delimitation may be problematic.)
This does not reliably work under the condition of iterative array evaluation
as specified in the relevant OASIS document
(http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1017866_715980110
), num "2)".
#A The output range will show the #VALUE! error.
#B The same error will be returned by a function trying to evaluate a parameter
containing the array expression.
Versions
I tried this with V4.4.3, prerelease 5.0.0.0 beta1 and got the results as
described and demonstrated by the attached example.
I also tried with some older versions ('Portable') I have access to. V4.1 and
the older ("legacy") versions also showed the error, but with the exception of
case #B.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
