Issue 56761 - VLOOKUP fails on empty cells
Summary: VLOOKUP fails on empty cells
Status: CLOSED DUPLICATE of issue 32340
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1.4
Hardware: Mac Mac OS X, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2005-10-27 08:16 UTC by squibs
Modified: 2008-05-17 23:51 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Testdoc (5.70 KB, application/vnd.sun.xml.calc)
2005-10-27 11:11 UTC, frank 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description squibs 2005-10-27 08:16:36 UTC 
I tried to migrate Excel spreadsheets to NeoOffice.  I discovered that my earlier, successful, use of 
VLOOKUP generates a scattering of cells containing Err:502.
Further investigation using ISTEXT and ISBLANK shows that when your version of VLOOKUP references an 
empty cell it returns "text".
A single instance of the function does not generate an error message, but the sum of several VLOOKUPs 
will fail if more than one referenced cells is empty.
Comment 1 michael.ruess 2005-10-27 08:30:46 UTC 
Spreadsheet issue.
Comment 2 frank 2005-10-27 09:32:05 UTC 
Hi,

please attach a document showing this behaviour and please use the latest
available version of OOo2.0 to check it again.

Thanks

Frank
Comment 3 frank 2005-10-27 11:11:31 UTC 
Created attachment 30909 [details]
Testdoc
Comment 4 frank 2005-10-27 11:13:43 UTC 
Hi,

this is a double to Issue 32340 and therefore not fixed in the latest OOo version.

Frank

*** This issue has been marked as a duplicate of 32340 ***
Comment 5 ace_dent 2008-05-17 21:46:58 UTC 
The Issue you raised has been marked as 'Resolved' and not updated within the
last 1 year+. I am therefore setting this issue to 'Verified' as the first step
towards Closing it. If you feel this is incorrect, please re-open the issue and
add any comments.

Many thanks,
Andrew
 
Cleaning-up and Closing old Issues
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html
Comment 6 ace_dent 2008-05-17 23:51:19 UTC 
As per previous posting: Verified -> Closed.
A Closed Issue is a Happy Issue (TM).

Regards,
Andrew