https://bugs.documentfoundation.org/show_bug.cgi?id=117879
Bug ID: 117879
Summary: 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
Product: LibreOffice
Version: 6.0.4.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: dp060593...@gmail.com
Description:
Issue is reproduced for all function with 2 or more arguments
Steps to Reproduce:
1.Open LibreOffice Calc
2.Enter following formulas to any cell:
=SUM({A1},2,3,4,5}
=CONCATENATE({PI()},"this", "is", "PI")
=EXACT({#ERR501!},#ERR501!)
Actual Results:
Actual result: entered formula is truncated, all arguments which are follow
after invalid array is disappeared:
=SUM({A1},2,3,4,5) -->> =SUM({A1})
=CONCATENATE({PI()},"this", "is", "PI") -->> =CONCATENATE({PI()})
=EXACT({#ERR501!},#ERR501!) -->> =EXACT({#ERR501!})
Expected Results:
Expected result: formula entered by user should be saved
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Version: 6.0.4.1 (x64)
Build ID: a63363f6506b8bdc5222481ce79ef33b2d13c741
CPU threads: 4; OS: Windows 10.0; UI render: GL;
Locale: en-US (en_US); Calc: CL
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36
--
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
