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: libreoffice-bugs@lists.freedesktop.org ReportedBy: gerard.farg...@orange.fr 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs