[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 #4 from Andrey <dp060593daa at gmail.com> ---
(In reply to m.a.riosv from comment #3)
> 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.

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.

-- 
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/20180531/821283e4/attachment-0001.html>