Bug 152708 - PROCV function returning wrong resuls
Summary: PROCV function returning wrong resuls
Status: RESOLVED DUPLICATE of bug 141989
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.2.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-12-28 19:48 UTC by Solerman Kaplon
Modified: 2022-12-28 20:56 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
spreadsheet showing the problem (27.41 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-12-28 19:48 UTC, Solerman Kaplon 		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 Solerman Kaplon 2022-12-28 19:48:37 UTC 
Created attachment 184377 [details]
spreadsheet showing the problem

For some values of the attached spreadsheet, see the "Jogadores" sheet where there is wrong values reported for lines 9, 11, 13, 14, 15 and 16. The spreadhseed was exported from Google docs, but re-inserting the values didn't work (and if there is anything wrong with the exported file, it should be reported in the UI)
Comment 1 Solerman Kaplon 2022-12-28 19:49:10 UTC 
The file contains data from a free game and can be freely shared
Comment 2 Mike Kaganski 2022-12-28 20:56:01 UTC 

*** This bug has been marked as a duplicate of bug 141989 ***