Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | word HIGH appearing in text string causes logic error | ||
---|---|---|---|
Product: | Calc | Reporter: | tony.fields |
Component: | programming | Assignee: | AOO issues mailing list <issues> |
Status: | CONFIRMED --- | QA Contact: | LadyMariu <ladymariu> |
Severity: | Normal | ||
Priority: | P3 | CC: | issues |
Version: | OOo 3.3 | ||
Target Milestone: | --- | ||
Hardware: | Mac | ||
OS: | Mac OS X 10 | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
tony.fields
2011-07-26 16:13:53 UTC
getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used. I tried the =lookup function and failed for different text strings (not just the word "High" but "April" in an H2 cell where "April" was present at AF2 cell too). =LOOKUP($H2;$A1:$AL1) where H2 = "April" and AF2 = "April" output = 2013 (Z1!) Worth checking the functionality for text strings. It worked ok with numbers. Tested on: Win7 SP1 64bits (AOO 341m1 - B9593 - R 1372282) M.- |