https://bugs.documentfoundation.org/show_bug.cgi?id=117879
--- Comment #3 from m.a.riosv <miguelange...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
