[Libreoffice-bugs] [Bug 74451] Calc 4.2 Vlookup order parameter TRUE/FALSE doesn't work as before and as Excel
https://bugs.freedesktop.org/show_bug.cgi?id=74451 Winfried Donkers winfrieddonk...@libreoffice.org changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|--- |WORKSFORME CC||winfrieddonkers@libreoffice ||.org --- Comment #9 from Winfried Donkers winfrieddonk...@libreoffice.org --- 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. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 74451] Calc 4.2 Vlookup order parameter TRUE/FALSE doesn't work as before and as Excel
https://bugs.freedesktop.org/show_bug.cgi?id=74451 --- Comment #8 from Elcom el...@adetex.co.id --- Created attachment 97053 -- https://bugs.freedesktop.org/attachment.cgi?id=97053action=edit 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 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 74451] Calc 4.2 Vlookup order parameter TRUE/FALSE doesn't work as before and as Excel
https://bugs.freedesktop.org/show_bug.cgi?id=74451 Elcom el...@adetex.co.id changed: What|Removed |Added Priority|medium |high -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 74451] Calc 4.2 Vlookup order parameter TRUE/FALSE doesn't work as before and as Excel
https://bugs.freedesktop.org/show_bug.cgi?id=74451 vlb v...@xs4all.nl changed: What|Removed |Added CC||v...@xs4all.nl --- Comment #5 from vlb v...@xs4all.nl --- 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 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 74451] Calc 4.2 Vlookup order parameter TRUE/FALSE doesn't work as before and as Excel
https://bugs.freedesktop.org/show_bug.cgi?id=74451 vlb v...@xs4all.nl changed: What|Removed |Added Keywords||regression -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 74451] Calc 4.2 Vlookup order parameter TRUE/FALSE doesn't work as before and as Excel
https://bugs.freedesktop.org/show_bug.cgi?id=74451 --- Comment #6 from vlb v...@xs4all.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. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 74451] Calc 4.2 Vlookup order parameter TRUE/FALSE doesn't work as before and as Excel
https://bugs.freedesktop.org/show_bug.cgi?id=74451 --- Comment #7 from vlb v...@xs4all.nl --- (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 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 74451] Calc 4.2 Vlookup order parameter TRUE/FALSE doesn't work as before and as Excel
https://bugs.freedesktop.org/show_bug.cgi?id=74451 --- Comment #4 from gl guglielmolo...@yahoo.it --- I have the same problem (whit italian version and engish version) Guglielmo -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 74451] Calc 4.2 Vlookup order parameter TRUE/FALSE doesn't work as before and as Excel
https://bugs.freedesktop.org/show_bug.cgi?id=74451 --- Comment #3 from sarkon sarro...@gmail.com --- (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 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 74451] Calc 4.2 Vlookup order parameter TRUE/FALSE doesn't work as before and as Excel
https://bugs.freedesktop.org/show_bug.cgi?id=74451 --- Comment #2 from eurovillprofi and...@eurovill.com --- 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 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 74451] Calc 4.2 Vlookup order parameter TRUE/FALSE doesn't work as before and as Excel
https://bugs.freedesktop.org/show_bug.cgi?id=74451 Nemesis19 masini.fabri...@gmail.com changed: What|Removed |Added Version|unspecified |4.2.0.4 release -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 74451] Calc 4.2 Vlookup order parameter TRUE/FALSE doesn't work as before and as Excel
https://bugs.freedesktop.org/show_bug.cgi?id=74451 Cor Nouws c...@nouenoff.nl changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||c...@nouenoff.nl Ever confirmed|0 |1 --- Comment #1 from Cor Nouws c...@nouenoff.nl --- 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 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
