[sc-issues] [Issue 107380] vlookup exact does not me an exact
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107380 --- Additional comments from oger...@openoffice.org Fri Dec 4 08:17:50 + 2009 --- Thank you for verifying. I tested your advice and it works on windows, but not on ubuntu (both with build 9420), so I have to blaime them and file the bug again against the ubuntu bug tracking system. Bye - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 107380] vlookup exact does not me an exact
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107380 User regina changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from reg...@openoffice.org Wed Dec 2 17:52:47 + 2009 --- closing, feature is already available. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 107380] vlookup exact does not me an exact
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107380 User regina changed the following: What|Old value |New value CC|''|'regina' Status|UNCONFIRMED |RESOLVED Keywords| |oooqa Resolution| |WORKSFORME --- Additional comments from reg...@openoffice.org Wed Dec 2 17:19:24 + 2009 --- Not a bug, but a feature. You can configure OOo what kind of "exact" you want to use. Goto Tools > Options > Calc > Calculate. Check the item "Search criteria = and <> must apply to whole cells" to get the same behavior as Excel. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 107380] vlookup exact does not me an exact
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107380 --- Additional comments from oger...@openoffice.org Wed Dec 2 12:33:32 + 2009 --- Created an attachment (id=66453) File showing the incompatibility (compared with ms-office-2000) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 107380] vlookup exact does not me an exact
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107380 Issue #|107380 Summary|vlookup exact does not mean exact Component|Spreadsheet Version|OOo 3.1.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P4 Subcomponent|editing Assigned to|spreadsheet Reported by|oger000 --- Additional comments from oger...@openoffice.org Wed Dec 2 12:31:18 + 2009 --- The help for vlookup says for the 4th parameter: in unordered lists the searched value must match exact. In OOo trailing spaces are not taken into account. This is not bad on its own, but is an incomptibility to MS-office, so tables safed as .xls look fine in OOo but fail in ms-office. In the attached file the value "ref2 " at cell A7 has a trailing space, the searchvalue in A20 has not. In OOo displayes a non-error-result in cell F20, while ms-office displayesa #NV value. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org