Created attachment 53761 [details] 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.
Confirmed under Ubuntu 10.04 x86_64 with my build : LibreOffice 3.5.0 Build ID: 997ac87-7085c55-8b4f344-a2e750f-ce71330 should be in LibreOffice 3.5 most annoying bugs. Best regards. JBF
Kohei, Marcus, could you please have a look?
I'll take a look.
Set it assigned again.
Aha! It was a simple typo causing this trouble.
Fixed on master. http://cgit.freedesktop.org/libreoffice/core/commit/?id=264e5034688a9c3105b3d29c7083ef2565afaec6
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.