<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#c4">Comment # 4</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:dp060593daa@gmail.com" title="Andrey <dp060593daa@gmail.com>"> Andrey</a> <pre>(In reply to m.a.riosv from <a href="show_bug.cgi?id=117879#c3">comment #3</a>) > Please take a look to the help about inline arrays. > <a href="https://help.libreoffice.org/Calc/">https://help.libreoffice.org/Calc/</a> > 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. This issue describes falsely truncation of formula (not result of formula) with not allowed data in inline arrays. I see only 2 solutions: 1) Fix this problem 2) Add information about truncation in documentation Thanks a lot.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>