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