Bug 98641 - function error about "lookup"
Summary: function error about "lookup"
Status: CLOSED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.5.2 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-03-14 03:05 UTC by limux
Modified: 2016-09-03 08:55 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
the questions attachment (19.80 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-03-14 03:05 UTC, limux 		Details
No error with 5.1.1.3 (x64); win7 (51.43 KB, image/png)
2016-03-14 16:13 UTC, raal 		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 limux 2016-03-14 03:05:15 UTC 
Created attachment 123549 [details]
the questions attachment

in the attachment (the name is "error1.ods")-sheet1-"BB15:BB24",I want to used the function "lookup" and "countif" rearrangement the "BB3:BC12" according to rank "BC" ,but as you can see ,the return value is error a part . i don't know what happen,may be it is BUG or not ,please help.

in the "sheet2" the problems still exist(at the "A17:A19")
Comment 1 raal 2016-03-14 16:13:17 UTC 
Created attachment 123566 [details]
No error with 5.1.1.3 (x64); win7

No error with 5.1.1.3 (x64), win7. Please test with newer version: http://www.libreoffice.org/download/libreoffice-fresh/

Thanks
Comment 2 Buovjaga 2016-03-22 18:31:23 UTC 
Set to NEEDINFO.
Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away.