Bug 97323 - Sverweis (VLOOKUP) - bug?
Summary: Sverweis (VLOOKUP) - bug?
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-01-22 18:37 UTC by khrehfeld
Modified: 2016-01-23 17:39 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
LibreOffice Calc: trying a summary of several spreadsheets in one spreadsheet using SVERWEIS (VLOOKUP) (22.69 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-01-23 17:01 UTC, khrehfeld 		Details
Bug? using SVERWEIS/VLOOKUP (22.69 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-01-23 17:06 UTC, khrehfeld 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description khrehfeld 2016-01-22 18:37:49 UTC 
User-Agent:       Mozilla/5.0 (X11; Linux x86_64; rv:42.0) Gecko/20100101 Firefox/42.0
Build Identifier: LibreOffice 4.1.6.2

file:///home/charlie/Dokumente/Fehler_LibreOffice_calc.ods

Reproducible: Always




[Information automatically included from LibreOffice]
Locale: de
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes


Reset User Profile?No
Comment 1 Adolfo Jayme Barrientos 2016-01-23 05:30:56 UTC 
Please describe the problem you’re having, provide a couple of steps for us to try to reproduce that problem, and if applicable, attach the affected file (ensure it contains no sensitive information, as attachments are public).
Comment 2 khrehfeld 2016-01-23 17:01:22 UTC 
Created attachment 122173 [details]
LibreOffice Calc: trying a summary of several spreadsheets in one spreadsheet using SVERWEIS (VLOOKUP)

LibreOfficeCalc programm
Comments/description are on the first spreadsheet
Comment 3 khrehfeld 2016-01-23 17:06:59 UTC 
Created attachment 122174 [details]
Bug? using SVERWEIS/VLOOKUP

LibreOfficeCalc program, using SVERWEIS/VLOOKUP
Comment 4 GerardF 2016-01-23 17:39:14 UTC 
LO Help : https://help.libreoffice.org/index.php?title=Calc/Spreadsheet_Functions&Language=en-US&System=WIN&Version=5.2#bm_id3152809

"If the SortOrder parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact SearchCriterion is not found, the last value that is smaller than the criterion will be returned"

Not a bug.