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/01/08 09:16:49 UTC
[Bug 123995] New: Wrong results with wildcard characters if there
are multiple conditions when importing *.xls
https://issues.apache.org/ooo/show_bug.cgi?id=123995
Bug ID: 123995
Issue Type: DEFECT
Summary: Wrong results with wildcard characters if there are
multiple conditions when importing *.xls
Product: Calc
Version: 4.1.0-dev
Hardware: All
OS: All
Status: CONFIRMED
Severity: normal
Priority: P3
Component: open-import
Assignee: issues@openoffice.apache.org
Reporter: doneyourself@gmail.com
CC: issues@openoffice.apache.org
AOO410m1(Build:9750) - Rev. 1548193
Step:
1.Launch application.
2.Open excel sample file 'wildcard_countif.xls' with AOO.
notes : Make sure that option 'Enable regular expressions in formulas' in
Options unchecked.
3.Check actual results.
Expected Issue:
Formulas with wildcard '*'; '?'; '~' can work correctly as expected result.
Actual Issue:
Formulas with wildcard '*'; '?'; '~'(Cell5/6/7) can display wrongly compared
with D5/6/7
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123995] Wrong results with wildcard characters if there are
multiple conditions when importing *.xls
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123995
--- Comment #2 from liuping <do...@gmail.com> ---
Created attachment 82240
--> https://issues.apache.org/ooo/attachment.cgi?id=82240&action=edit
wildcard_daverage.xls
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Issue 123995] Wrong results with wildcard characters if there are
multiple conditions when importing *.xls
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123995
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOT_AN_ISSUE
--- Comment #7 from Edwin Sharp <el...@apache.org> ---
Wildcards not supported by AOO.
--
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.
[Bug 123995] Wrong results with wildcard characters if there are
multiple conditions when importing *.xls
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123995
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needmoreinfo
CC| |elish@apache.org
--- Comment #4 from Edwin Sharp <el...@apache.org> ---
Read-Error.
Internal import error.
when opening attachment 82239
AOO410m1(Build:9750) - Rev. 1555399
2014-01-06_04:13:46 - Rev. 1555657
Debian
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123995] Wrong results with wildcard characters if there are
multiple conditions when importing *.xls
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123995
--- Comment #3 from liuping <do...@gmail.com> ---
The same issue happen on wildcard_daverage.xls
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Issue 123995] Wrong results with wildcard characters if there are
multiple conditions when importing *.xls
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123995
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CONFIRMED |UNCONFIRMED
CC| |rainerbielefeld_ooo_qa@biel
| |efeldundbuss.de
Version|4.1.0-dev |OOo 3.3 or older
Ever confirmed|1 |0
--- Comment #5 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Additional Info:
(a) Not a new issue, already reproducible with AOO 4.0.1 ... back to OOo 1.1.5
(b) I did a quick test for "formula COUNTIF with wildcard "?"". It seems I
get correct result with RE search string ".*WH.*6.8.*" in Find, Filter and
also
formula works correct. So there might
(c) Might be related to
"Issue 123908 - Database formulas show wrong results with wildcard
characters
if there are multiple conditions"
"Issue 17993 - Add wildcards to the standard autofilter"
"Issue 32344 - Simple wildcards * and ? as opposed to regular expressions"
(d) Currently too much uncertainty for an independent CONFIRMED issue
@liuping
Did you already check these relations?
--
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.
[Issue 123995] Wrong results with wildcard characters if there are
multiple conditions when importing *.xls
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123995
--- Comment #6 from Edwin Sharp <el...@apache.org> ---
*** Issue 124523 has been marked as a duplicate of this issue. ***
--
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.
[Issue 123995] Wrong results with wildcard characters if there are
multiple conditions when importing *.xls
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123995
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
See Also| |https://issues.apache.org/o
| |oo/show_bug.cgi?id=123908
--
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.
[Bug 123995] Wrong results with wildcard characters if there are
multiple conditions when importing *.xls
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123995
--- Comment #1 from liuping <do...@gmail.com> ---
Created attachment 82239
--> https://issues.apache.org/ooo/attachment.cgi?id=82239&action=edit
wildcard_countif.xls
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.