https://bugs.documentfoundation.org/show_bug.cgi?id=170996
Bug ID: 170996
Summary: =LOOKUP fails to return the correct value from a table
of about 1000 rows
Product: LibreOffice
Version: 25.2.1.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have an example of a speadsheet with a table of 5 columns and 1001 rows
(A3:E1004). Column A contains dates (mm/dd/yy) and column D contains numeric
values formatted a currency. The last 3 rows of the table contain dates in
column A but column D is blank. The object is to look up the date in column A
corresponding to the largest value in column D. =MAX($D$3:$D1004) correctly
locates the maximum value (located in row 998 of the spreadsheet) but
=LOOKUP(G1004,$D$3:$D1004,$A$3:$A1004) returns the date from row 1001. If, as
shown in the attached spreadsheet, if the lookup is changed cover the smaller
range from row 882 to 1004, the correct date is returned. I believe that any
larger starting row number also works, but reducing the starting row number to
881 or smaller causes the error to occur.
Steps to Reproduce:
1.See the attached spreadsheet
2.The cells marked in red show the problem, those marked in green show the
correct result being calculated when the look up range is reduced
3.
Actual Results:
see the attached spreadsheet (Red background cells). The date displayed is
02/22/26
Expected Results:
See the attached spreadsheet (green cells), the correct date of 02/01/26 should
be displayed.
Reproducible: Always
User Profile Reset: No
Additional Info:
I initially saw this on LibreOffice 25.2.1, updated to 26.2.0.3 and still see
the error
--
You are receiving this mail because:
You are the assignee for the bug.
