https://bugs.freedesktop.org/show_bug.cgi?id=72041
Priority: high
Bug ID: 72041
Assignee: [email protected]
Summary: Vlookup external file sort order
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
Version: 4.3.0.0.alpha0+
Build ID: ee1b1b865b0ccc7418bbfad2a60cd14f851135a8
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time:
2013-11-22_23:47:31
Create a file with columns index and text.
In the index column enter A1, A3 and A2. Fill text column with text.
Save the file with a file name.
Now open a new file without closing the file you saved above.
Make header index and text.
Enter the value A2 twice in the index column.
Now you go to text column. Open the 'Function Wizard' and find the vlookup
function.
In search criterion you mark the value in index column.
Go to array and then mark the data area (index and text) you would like to use
in the file saved.
In the index you give the value 2.
In sort order you now give the value 0 for FALSE and the returned value will be
#N/A. If you change this value to 1 for TRUE, the text value is returned.
What happened for sort order 0:
Returning #N/A
Expected: Returning text value
What happened for sort order 1:
Returning text value
Expected: Returning text value
I noticed that on the 'Search Criterion' the value the wizard is returning is
in format 'sheet1.A2:A2) while in the past only returned value was 'A2'.
--
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
