https://issues.apache.org/ooo/show_bug.cgi?id=125813
Regina Henschel <[email protected]> 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 <[email protected]> --- 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.
