[Libreoffice-bugs] [Bug 117879] Formula truncated falsely if the first/ middle argument of the function(with two or more significant args) contains a non-constants parameter within array of constants

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=117879

--- Comment #3 from m.a.riosv <miguelangelrv at libreoffice.org> ---
Please take a look to the help about inline arrays.
https://help.libreoffice.org/Calc/Array_Functions#Using_Inline_Array_Constants_in_Formulas

So only values are allowed, and I think there is not allowed mix inline arrays
and other data with the same argument type. But it works with a formula like:
=VLOOKUP(A3;{0|0;4000|0,07;6000|0,1;9000|0,15};2)

Maybe to do what you want, the way is enter the formula as array not with an
inline array.
{=SUM(A1:A6,2,3,4,5)}
Introduced with [shift+Ctrl+Enter] without the brackets.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180530/308bbe6e/attachment.html>