https://bugs.freedesktop.org/show_bug.cgi?id=43154
Bug #: 43154
Summary: EDTING : Empty string "" equivalent to any number with
several functions.
Classification: Unclassified
Product: LibreOffice
Version: LibO Master
Platform: x86 (IA32)
OS/Version: Windows (All)
Status: NEW
Severity: blocker
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 53761
--> https://bugs.freedesktop.org/attachment.cgi?id=53761
Spreadsheet reproducing the bug
LibO-dev 3.5.0
Build ID: 4f11d0a-adcf6d5-c4bb9bd
on Windows Vista.
master~2011-11-16_23.49.24_LibO-Dev_OOO350m1_Win_x86_install_en-US.exe
With a range containing empty string like result of IF(A1=1;1;"") and A1<>1,
functions SUMIF and COUNTIF counts empty string when criterion is a number.
Same behavior with search function MATCH or VLOOKUP :
If "search criterion" is a number and if this number is not in the range or if
empty string is above this number, MATCH returns position of empty string.
See attachment, it will be more clear.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
