Summary: | Calc 4.2 Vlookup order parameter TRUE/FALSE doesn't work as before and as Excel | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Nemesis19 <masini.fabrizio> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED WORKSFORME | ||
Severity: | normal | CC: | cno, john32767, vlb1, winfrieddonkers |
Priority: | high | Keywords: | regression |
Version: | 4.2.0.4 release | ||
Hardware: | All | ||
OS: | Windows (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: | File with vlookup formula result error |
Description
Nemesis19
2014-02-03 15:59:49 UTC
Hi Nemesis, thanks fot the issue. Working in 4.2.0.4 on Ubuntu, I cannot reproduce that problem. Maybe it is Windows only ?? Best, Cor I have the same problem in the Hungarian version of LibreOffice Calc (version 4.2.0.4), on windows xp (32bit). When the ordering function gets 0/FALSE value, VLOOKUP can not find anything, it gives the #NA result. It only works with the 1/TRUE value. (In reply to comment #0) > Goodmorning, > > I'm using the Italian version of Libreoffice 4.2 but when I use the vlookup > function and I put 0 to set ordering to fals as last parameter I always get > #N/D. > > Only if I set 1 it works. But this makes data inconsistent because I don't > want to be forced to set 1 (=true). > > In Calc 4.1 and before setting 0 (=false) worked normally. > > I reverted back to 4.1 because I use Vlookup in my daily job. > > Thanks for your attention > > Fabrizio (In reply to comment #1) > Hi Nemesis, > > thanks fot the issue. > Working in 4.2.0.4 on Ubuntu, I cannot reproduce that problem. > Maybe it is Windows only ?? > > Best, > Cor I too have the same problem, but only when the array (or range) for referencing, of the vlookup function, belongs to another file e.g. =VLOOKUP(A112;'file:///C:/Users/Costas/EN12831_Libs.ods'#$'min_air'.$A$3:$B$6;2;0) Best, Costas I have the same problem (whit italian version and engish version) Guglielmo I can conform this issue! I have the same in LO 4.1.5.3 works correct en in 4.2.0 and 4.2.1 isn't work correct. I must use now 4.1.5.3, i hope it is solve this problem! The LO 4.2.0 isn't use yet. I have windows 7 64 bits NL (In reply to comment #5) > I can conform this issue! > I have the same in LO 4.1.5.3 works correct en in 4.2.0 and 4.2.1 isn't work > correct. > I must use now 4.1.5.3, i hope it is solve this problem! The LO 4.2.0 isn't > use yet. > > I have windows 7 64 bits NL =VERT.ZOEKEN(F84;'file:///C:/Users/Frank/AppData/Roaming/LibreOffice/4/user/template/Staal profielen.ods'#$Profielen.$A$15:$BZ$1999;19;ONWAAR()) This give #N/B in LO 4.2.0 and 4.2.1 and in 4.1.5.3 is correct. (In reply to comment #6) > (In reply to comment #5) > > I can conform this issue! > > I have the same in LO 4.1.5.3 works correct en in 4.2.0 and 4.2.1 isn't work > > correct. > > I must use now 4.1.5.3, i hope it is solve this problem! The LO 4.2.0 isn't > > use yet. > > > > I have windows 7 64 bits NL > > =VERT.ZOEKEN(F84;'file:///C:/Users/Frank/AppData/Roaming/LibreOffice/4/user/ > template/Staal profielen.ods'#$Profielen.$A$15:$BZ$1999;19;ONWAAR()) > > This give #N/B in LO 4.2.0 and 4.2.1 and in 4.1.5.3 is correct. addition: When i refer to a the same file it give a good result, but when i refer to a other file it give #N/B Created attachment 97053 [details]
File with vlookup formula result error
I have vlookup problem in LO 4.2 and in older version just works perfectly.
In my attachment file, try change value in cell BI9 and suddenly column E297 will #N/A
Problem no longer occurs with version 4.2.5.RC2 (Windows 7) nor on master (Linux). @Nemesis19: Feel free to set status to reopened if the problem presists with you using version 4.2.5.RC2 or later. BTW, version 4.2.5 will be released later this week. |