Bug 152708

Summary: PROCV function returning wrong resuls
Product: LibreOffice Reporter: Solerman Kaplon <solerman.kaplon>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal    
Priority: medium    
Version: 7.4.2.3 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: spreadsheet showing the problem

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 ***