Bug 53293 - : array function and function N()
Summary: : array function and function N()
Status: RESOLVED DUPLICATE of bug 53274
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.5.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-08-09 12:16 UTC by David Lynch
Modified: 2012-08-11 18:19 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description David Lynch 2012-08-09 12:16:09 UTC
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
Comment 1 Markus Mohrhard 2012-08-11 18:19:09 UTC

*** This bug has been marked as a duplicate of bug 53274 ***