https://bugs.freedesktop.org/show_bug.cgi?id=80259
Priority: medium
Bug ID: 80259
Assignee: [email protected]
Summary: VLOOKUP returns wrong value when the source data is
blank
Severity: major
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.3.0.1 rc
Component: Spreadsheet
Product: LibreOffice
Steps to reproduce:
1. Open the attached ods test file;
2. Observe that cell B5 and C4 in sheet2 have VLOOKUP formula, and are showing
the value as blank.
>> This is expected, as their source values (B5 and C4 in sheet1) are blank.
3. Click the auto filter icon in B1 or C1 of sheet2.
>> The first value in the filer is a "blank box". This is wrong, the filter
>> should never give this result.
4. Copy cell B5 or C4 of sheet2, and paste only value to another empty cell.
>> the cell you pasted to is showing "0". This is wrong, as you see blank value
>> in B5 and C4.
Current Behaviour: (See the descriptions in the above steps)
Expected:
a. Filter result in step 3 should treat the blank value as blank.
b. Pasted result in step 4 should be blank, rather than "0".
OS: Windows XP SP3
Version: 4.3.0.1
Build ID: 67f5430184326974072b65403ef1d9d934fc4481
Note: In Microsoft Office 2010, VLOOKUP always return "0" if the source cell is
blank. I believe this is their bug.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
