Bug 43154

Summary: EDTING : Empty string "" equivalent to any number with several functions.
Product: LibreOffice Reporter: GerardF <gerard.fargeot>
Component: SpreadsheetAssignee: Kohei Yoshida (inactive) <libreoffice>
Status: RESOLVED FIXED QA Contact:
Severity: blocker    
Priority: high CC: jbfaure, rb.henschel
Version: Master old -3.6Keywords: regression
Hardware: x86 (IA32)   
OS: Windows (All)   
Whiteboard: target:3.5
i915 platform: i915 features:
Bug Depends on:    
Bug Blocks: 37361    
Attachments: Spreadsheet reproducing the bug

Description GerardF 2011-11-22 00:01:31 UTC 
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.
Comment 1 Jean-Baptiste Faure 2011-11-22 03:02:57 UTC 
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
Comment 2 Petr Mladek 2011-11-22 04:42:17 UTC 
Kohei, Marcus, could you please have a look?
Comment 3 Kohei Yoshida (inactive) 2011-11-22 09:52:13 UTC 
I'll take a look.
Comment 4 Kohei Yoshida (inactive) 2011-11-22 10:14:03 UTC 
Set it assigned again.
Comment 5 Kohei Yoshida (inactive) 2011-11-22 11:57:13 UTC 
Aha!  It was a simple typo causing this trouble.

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.