You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/10/31 13:50:25 UTC
[Issue 125813] New: VLOOKUP() doesn't work like expected
https://issues.apache.org/ooo/show_bug.cgi?id=125813
Issue ID: 125813
Issue Type: DEFECT
Summary: VLOOKUP() doesn't work like expected
Product: Calc
Version: 4.1.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: ui
Assignee: issues@openoffice.apache.org
Reporter: efa@iol.it
Created attachment 84131
--> https://issues.apache.org/ooo/attachment.cgi?id=84131&action=edit
.ods that use VLOOKUP() on same radix strings
the VLOOKUP() function with 3th parameter at 0 or FALSE, work with not sorted
elements, and should return exact match only.
But sometimes get confused by similar element that match too, when should match
with 3th parameter to 1 or TRUE or missing
It happen when the radix part of a string is found in another entry, followed
by other text.
Attach an example where the bug is shown.
I exported the .ods file as .xls and tested in both AOO and Excel, and so work
as expected, return exact match only.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125813] VLOOKUP() doesn't work like expected
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125813
--- Comment #4 from efa <ef...@iol.it> ---
Created attachment 84132
--> https://issues.apache.org/ooo/attachment.cgi?id=84132&action=edit
the same file saved as .xls
Attached the same .ods file saved as .xls
Then, opening the .xls file with AOO, the option "Search criteria = and <> must
apply to whole cells" is disabled, so the results in D28 is different to that
in Excel. This can be very dangerous.
Opening an XLS file, AOO should automatically set this option.
We need to change the bug description adding "opening .xls files"
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125813] VLOOKUP() doesn't work like expected
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125813
Regina Henschel <rb...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125813] Set option "search criteria must apply to whole cell"
to true, when opening .xls or .xlsx file
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125813
Regina Henschel <rb...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |ms_interoperability
Status|CLOSED |REOPENED
Issue Type|DEFECT |ENHANCEMENT
Resolution|NOT_AN_ISSUE |---
Summary|VLOOKUP() doesn't work like |Set option "search criteria
|expected |must apply to whole cell"
| |to true, when opening .xls
| |or .xlsx file
Ever confirmed|0 |1
--- Comment #5 from Regina Henschel <rb...@t-online.de> ---
This is a document setting. It is in element <table:calculation-settings> the
attribute "table:search-criteria-must-apply-to-whole-cell" in the content.xml
in the .ods container.
I agree, that this option should be set to "true", when opening an Excel
spreadsheet.
I have changed the Summary and set Issue-Type to enhancement and added keyword
"ms-interoperability".
I guess, this can be an "easy-hack".
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125813] Set option "search criteria must apply to whole cell"
to true, when opening .xls or .xlsx file
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125813
Andrea Pescetti <pe...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |pescetti@apache.org
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125813] VLOOKUP() doesn't work like expected
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125813
Regina Henschel <rb...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |rb.henschel@t-online.de
Resolution|--- |NOT_AN_ISSUE
--- Comment #1 from Regina Henschel <rb...@t-online.de> ---
It is a feature :).
Goto Tools > Options > OpenOffice Calc > Calculate. Find the option "Search
criteria = and <> must apply to whole cells". If that is checked, the complete
cell content is used for comparisons, otherwise substrings will match too.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125813] VLOOKUP() doesn't work like expected
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125813
--- Comment #2 from efa <ef...@iol.it> ---
Excel match always the whole cell, so to have compatibility we must keep the
option checked. Should be the install default.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125813] VLOOKUP() doesn't work like expected
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125813
--- Comment #3 from efa <ef...@iol.it> ---
this option seems related to the specific file, not a global settings.
Is this confirmed?
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.