[Libreoffice-bugs] [Bug 53293] New: : array function and function N()

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=53293

             Bug #: 53293
           Summary: : array function and function N()
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.5.5.3 release
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: david_lynch at blueyonder.co.uk


Problem description: 

Steps to reproduce:
1. open a new spreadsheet, 
2. in cells A1:A2, enter the array function
=N(VLOOKUP(B1:B2,C1:D2,2,0))


Current behavior:
the values #N/A,#N/A are returned in A1:A2

Expected behavior:
the values 0,0 should be returned. According to the documentation, N() should
never return the value #N/A.

Platform (if different from the browser): 

Browser: Mozilla/5.0 (Windows NT 6.0; rv:13.0) Gecko/20100101 Firefox/13.0.1

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.