[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
https://bugs.documentfoundation.org/show_bug.cgi?id=117879 Eike Rathke changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |er...@redhat.com |desktop.org | Ever confirmed|0 |1 Status|UNCONFIRMED |ASSIGNED -- 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
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=117879 Eike Rathke changed: What|Removed |Added OS|Windows (All) |All Version|6.0.4.2 release |Inherited From OOo -- 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
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=117879 Xisco Faulí changed: What|Removed |Added CC||er...@redhat.com, ||xiscofa...@libreoffice.org Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED --- Comment #5 from Xisco Faulí --- > 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. @Eike, any opinion here? Putting to UNCONFIRMED for the time being... -- 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
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=117879
--- Comment #4 from Andrey ---
(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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=117879
--- Comment #3 from m.a.riosv ---
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
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=117879 --- Comment #2 from Andrey --- (In reply to m.a.riosv from comment #1) > Have you tested with semicolon instead commas as separator. > It is on Menu/Tools/Options/LibreOffice calc/Formula - Separators - function. Still reproduce with semicolon separator instead of comma. Thanks for the quick response -- 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
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=117879 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||miguelangelrv@libreoffice.o ||rg Ever confirmed|0 |1 --- Comment #1 from m.a.riosv --- Have you tested with semicolon instead commas as separator. It is on Menu/Tools/Options/LibreOffice calc/Formula - Separators - function. -- 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
