Bug 105562

Summary:	LOCALHELP: AND, OR with range as argument: function uses not only current column or row
Product:	LibreOffice	Reporter:	Gilward Kukel <gilward.kukel>
Component:	Documentation	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED FIXED
Severity:	normal
Priority:	medium
Version:	5.2.4.2 release
Hardware:	All
OS:	All
Whiteboard:	target:6.1.0
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	80430

Description Gilward Kukel 2017-01-26 22:06:52 UTC

Description:
In the local help for Calc the descriptions of AND and OR on the page Logical Functions say:
"If a range is entered as a parameter, the function uses the value from the range that is in the current column or row."
This is wrong. All values in the range are used.

https://help.libreoffice.org/Calc/Logical_Functions#OR

Actual Results:  
 

Expected Results:
 


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:50.0) Gecko/20100101 Firefox/50.0

Comment 1 Olivier Hallot 2017-04-06 14:43:34 UTC

Confirmed. All values of the range are AND'ed and OR'ed.

Comment 2 Commit Notification 2018-03-22 19:10:04 UTC

Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/help/commit/?id=d0a2cca6885c900fd362bdd7a72e382fe3b34ef4

tdf#105562 Correct page for AND/OR logic function