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 2013/12/23 09:44:32 UTC
[Bug 123908] New: Database formulas do not work well with wildcard characters when there are multiple conditions
https://issues.apache.org/ooo/show_bug.cgi?id=123908
Bug ID: 123908
Issue Type: DEFECT
Summary: Database formulas do not work well with wildcard
characters when there are multiple conditions
Product: Calc
Version: 4.1.0-dev
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: major
Priority: P3
Component: editing
Assignee: clarence.guo.bj@gmail.com
Reporter: fanyuzhen@gmail.com
QA Contact: doneyourself@gmail.com
CC: issues@openoffice.apache.org
This defect is migrated from Symphony defect as below:
Sym2_10737 Database formulas do not work well with wildcard characters when
there are multiple conditions
--
You are receiving this mail because:
You are on the CC list for the bug.
You are watching all bug changes.
[Bug 123908] Database formulas do not work well with wildcard characters when there are multiple conditions
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123908
--- Comment #3 from liuping <do...@gmail.com> ---
Created attachment 82167
--> https://issues.apache.org/ooo/attachment.cgi?id=82167&action=edit
sample file1
--
You are receiving this mail because:
You are on the CC list for the bug.
You are watching all bug changes.
[Bug 123908] Database formulas do not work well with wildcard characters when there are multiple conditions
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123908
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rainerbielefeld_ooo_qa@biel
| |efeldundbuss.de
--- Comment #1 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
@fanyuzhen@gmail.com
Can you please contribute a bug description telling normal users like me what
the problem is?
--
You are receiving this mail because:
You are on the CC list for the bug.
You are watching all bug changes.
[Bug 123908] Database formulas show wrong results with wildcard characters if there are multiple conditions
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123908
liuping <do...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
Ever confirmed|0 |1
--- Comment #6 from liuping <do...@gmail.com> ---
sample file1 is *.xlsx ; sample file2 is *.xls
I check menu 'Tools -> Options -> Calc -> Calculate - Enabled Regular
Expressions in formulas' in column J ,results in column J are still "#VALUE!"
column J in symphony3.0.1 FP2 same with MS2010
compared result please refer symphony&MS2010.jpg and AOO&MS2010.jpg
--
You are receiving this mail because:
You are on the CC list for the bug.
You are watching all bug changes.
[Issue 123908] Database formulas show wrong results with wildcard characters if there are multiple conditions
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123908
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
See Also| |https://issues.apache.org/o
| |oo/show_bug.cgi?id=123995
--- Comment #10 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Or also related to "Issue 123995 - Wrong results with wildcard characters if
there are multiple conditions when importing *.xls "?
This Wildcard area needs some cleanup.
--
You are receiving this mail because:
You are on the CC list for the issue.
You are watching all issue changes.
[Bug 123908] Database formulas show wrong results with wildcard characters if there are multiple conditions
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123908
--- Comment #7 from liuping <do...@gmail.com> ---
Created attachment 82176
--> https://issues.apache.org/ooo/attachment.cgi?id=82176&action=edit
symphony&ms2010.jpg
--
You are receiving this mail because:
You are on the CC list for the bug.
You are watching all bug changes.
[Bug 123908] Database formulas do not work well with wildcard characters when there are multiple conditions
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123908
liuping <do...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
Ever confirmed|0 |1
--- Comment #2 from liuping <do...@gmail.com> ---
Confirmed also in
AOO410m1(Build:9750) - Rev. 1548193
Step:
1. Open the sample file with AOO, and then check results of each formula with
conditions 2 or 3.
2. Compare the result with the file that open with Excel.
Database formulas do not work well with wildcard characters when there are
multiple conditions, and the Boolean logic of them are "OR".
--
You are receiving this mail because:
You are on the CC list for the bug.
You are watching all bug changes.
[Bug 123908] Database formulas do not work well with wildcard characters when there are multiple conditions
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123908
--- Comment #4 from liuping <do...@gmail.com> ---
Created attachment 82168
--> https://issues.apache.org/ooo/attachment.cgi?id=82168&action=edit
sample file2
--
You are receiving this mail because:
You are on the CC list for the bug.
You are watching all bug changes.
[Bug 123908] Database formulas show wrong results with wildcard characters if there are multiple conditions
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123908
--- Comment #8 from liuping <do...@gmail.com> ---
Created attachment 82177
--> https://issues.apache.org/ooo/attachment.cgi?id=82177&action=edit
AOO&Ms2010.jpg
--
You are receiving this mail because:
You are on the CC list for the bug.
You are watching all bug changes.
[Issue 123908] Database formulas show wrong results with wildcard characters if there are multiple conditions
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123908
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CONFIRMED |UNCONFIRMED
See Also| |https://issues.apache.org/o
| |oo/show_bug.cgi?id=17993,
| |https://issues.apache.org/o
| |oo/show_bug.cgi?id=32344
Ever confirmed|1 |0
--- Comment #9 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Hm, is this really related to "multiple conditions" or simply naive import of
MS Wildcards what can not work with AOO, see "Issue 17993 - Add wildcards to
the standard autofilter "?
Or "Issue 32344 - Simple wildcards * and ? as opposed to regular expressions"?
Currently I can't tell.
See also for now.
--
You are receiving this mail because:
You are on the CC list for the issue.
You are watching all issue changes.
[Issue 123908] Database formulas show wrong results with wildcard characters if there are multiple conditions
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123908
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOT_AN_ISSUE
--- Comment #11 from Edwin Sharp <el...@apache.org> ---
Wildcards not supported.
--
You are receiving this mail because:
You are on the CC list for the issue.
You are watching all issue changes.
[Bug 123908] Database formulas show wrong results with wildcard characters if there are multiple conditions
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123908
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CONFIRMED |UNCONFIRMED
Component|editing |code
Version|4.1.0-dev |3.4.0
Summary|Database formulas do not |Database formulas show
|work well with wildcard |wrong results with wildcard
|characters when there are |characters if there are
|multiple conditions |multiple conditions
Ever confirmed|1 |0
--- Comment #5 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Seems more or less reproducible with "AOO 4.0.1 – German UI / German locale
[Rev. 1524958 2013-09-20 11:40:29]" on German WIN7 Home Premium (64bit)",
“historic” 4.0 User Profile used for all predecessor versions, but until now
it's unknown for me what exactly the problem is
(a) I compared view of both attachments 2013-12-26 07:50 CET, liuping with
MS Excel viewer and AOO. Both show the same results so I only will
consider "sample file2" for further tests.
(b) Excel Viewer shows identical values in columns J,K
(c) With menu 'Tools -> Options -> Calc -> Calculate - Regular Expressions in
Formulas disabled' results in column J are completely nonsense, only "0"
or "#VALUE!"
(d) with "Regular Expressions Enabled" in most relevant cells of column J
values
appears, but except J12, J13 all values are different
(e) Gnumeric Tabellenkalkulation 1.10.16 shows the same values in columns
J, K.
(f) With OOo 3.3.0 Checking "'Tools -> Options -> Calc -> Calculate - Search
criteria must apply to whole cells" increases number of correct results.
But gambling with that setting has unpredictable result with different
OOo / AOO versions.
(g) we definitively have not a new issue here, that never worked correctly
with OOo / AOO
(h) Seems to work with Lotus Symphony Release 3.0.1
@liuping:
(z) there are 2 attachments with more or less the same contents.
What one is "THE" sample file? Why do you attach 2 ones?
(y) It would really ease to reproduce your results if you would read and heed
the bug writing guidelines, for example:
* "Be precise, avoid general rare statements ... "does not work""
* "Be clear, don't simply describe what your problem is, explain it so that
other users can reproduce the bug "
(x) Please contribute information how to find out that "multiple conditions"
is one reason for the different values
(w) Is it sure that not additionally other bugs are reason for
different results between Excel and AOO? It would help to have
1 single result in the sample document with step by step instruction
proving that wildcards and multiple conditions cause a bug.
(v) We have to separate "open-import" bugs from calculation bugs.
Can you reproduce at least a single wrong result with an original.ods
created with AOO?
(u) Is it known that AOO supports that multi condition wildcard use?
(t) any Idea why J12, J13 show the same results as Excel?
--
You are receiving this mail because:
You are on the CC list for the bug.
You are watching all bug changes.
[Bug 123908] Database formulas do not work well with wildcard characters when there are multiple conditions
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123908
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needmoreinfo
CC| |elish@apache.org
--
You are receiving this mail because:
You are on the CC list for the bug.
You are watching all bug changes.