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.
Created attachment 116007 [details] Demonstration mentioned in the bug description
(In reply to Wolfgang Jäger from comment #1) > Created attachment 116007 [details] > Demonstration mentioned in the bug description Confirmed. Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+ Build ID: be8512f99bc9ab18e55aabe01cc0ab1e6baea9e6 TinderBox: Win-x86@39, Branch:master, Time: 2015-06-08_05:58:40 Locale: fi-FI (fi_FI)
Bug in the attached example no longer showing under V5.1.0.0Beta1. It was still showing up under V5.0.3.2. Can someone confirm my statement and update the Status, please?
Yep, confirmed it is ok now. Win 7 Pro 64-bit Version: 5.2.0.0.alpha0+ Build ID: a7c3a2a9be83686657c06f37d521f9f6d2004ddd Threads 4; Ver: Windows 6.1; Render: default; TinderBox: Win-x86@39, Branch:master, Time: 2015-11-28_04:39:18 Locale: fi-FI (fi_FI)