<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - 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" href="https://bugs.documentfoundation.org/show_bug.cgi?id=117879#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - 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" href="https://bugs.documentfoundation.org/show_bug.cgi?id=117879">bug 117879</a> from <a class="email" href="mailto:miguelangelrv@libreoffice.org" title="m.a.riosv <miguelangelrv@libreoffice.org>"> m.a.riosv</a> <pre>Please take a look to the help about inline arrays. <a href="https://help.libreoffice.org/Calc/Array_Functions#Using_Inline_Array_Constants_in_Formulas">https://help.libreoffice.org/Calc/Array_Functions#Using_Inline_Array_Constants_in_Formulas</a> 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>