[Libreoffice-bugs] [Bug 71123] Other: inline arrays computing error
https://bugs.freedesktop.org/show_bug.cgi?id=71123 Eike Rathke er...@redhat.com changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #3 from Eike Rathke er...@redhat.com --- Not a bug. Functions taking a scalar argument as parameter have to be used in a matrix/array context to be evaluated for all elements of an array parameter. SUMPRODUCT is special in that it automatically forces all of its inner parameters into array context, SUM does not do that. -- 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
[Libreoffice-bugs] [Bug 71123] Other: inline arrays computing error
https://bugs.freedesktop.org/show_bug.cgi?id=71123 Eike Rathke er...@redhat.com changed: What|Removed |Added Status|RESOLVED|CLOSED -- 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
[Libreoffice-bugs] [Bug 71123] Other: inline arrays computing error
https://bugs.freedesktop.org/show_bug.cgi?id=71123 Joel Madero jmadero@gmail.com changed: What|Removed |Added CC||jmadero@gmail.com, ||markus.mohrhard@googlemail. ||com --- Comment #2 from Joel Madero jmadero@gmail.com --- @Markus - can we get your thoughts on this bug, either NEW or NOTABUG? -- 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
[Libreoffice-bugs] [Bug 71123] Other: inline arrays computing error
https://bugs.freedesktop.org/show_bug.cgi?id=71123 Jean-Baptiste Faure jbf.fa...@sud-ouest.org changed: What|Removed |Added Attachment #88520|application/xml |application/vnd.oasis.opend mime type||ocument.speadsheet -- 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
[Libreoffice-bugs] [Bug 71123] Other: inline arrays computing error
https://bugs.freedesktop.org/show_bug.cgi?id=71123
--- Comment #1 from mariosv mari...@miguelangel.mobi ---
Created attachment 88520
-- https://bugs.freedesktop.org/attachment.cgi?id=88520action=edit
File sample with differents formulas.
Hi Paul, thanks for reporting.
It is reproducible with:
Win7x64 Ultimate
Version: 3.5.7.2
Version: 4.0.6.2
Version: 4.1.4.0.0+Build ID: d6ee64b75581cbeb92534271ee6f4e87f07aa5c
AOO 4.0.1
MID() always return the first value 4, this is why result in 96.
Seems that MID() doesn't accept an inner array without an explicit array
formula.
The follow formula get 89 as result:
{=SUM(VALUE(MID(A1;{1;2;3;4;5;6;7;8;9;10;11;12};1))*{1;3;1;3;1;3;1;3;1;3;1;3})}
entered as array Ctrl+Shift+Enter.
or
=SUMPRODUCT(VALUE(MID(A1;{1;2;3;4;5;6;7;8;9;10;11;12};1));{1;3;1;3;1;3;1;3;1;3;1;3})
but is needed to use VALUE() function transforming the string returned by MID()
in a number.
So I can confirm the behaviour but I don't know if it is really a bug.
--
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
