[Libreoffice-bugs] [Bug 43154] New: EDTING : Empty string "" equivalent to any number with several functions.

[bugzilla-daemon at freedesktop.org]

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 at lists.freedesktop.org
        ReportedBy: gerard.fargeot at 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.