[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 --- Comment #29 from fanyuz...@gmail.com --- I have opened a new issue(Bug 123240) for c#18 problem, to clarify, this is not a brand new problem as it exists in 3.4.0, it's just new found when I do more testing around advanced filter function area. -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 --- Comment #30 from fanyuz...@gmail.com --- I show Clarence Guo for c#23 problem, it's strange why it is only reproduced on my Win7, still investigating .. -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 --- Comment #32 from fanyuz...@gmail.com --- Waiting for the build - revision 1521881(branches/AOO401) or higher , to be available for download, to verify this defect( bug 122862) -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 fanyuz...@gmail.com changed: What|Removed |Added CC||fanyuz...@gmail.com --- Comment #17 from fanyuz...@gmail.com --- This defect is verified fixed in Windows Nightly build(trunk) AOO410m1(Build:9750) - Rev. 1521070 based on the attached sample document -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 --- Comment #18 from fanyuz...@gmail.com --- There is a new problem found when verify this defect, here is the steps: 1. Open attached sample document from AOO Start Center 2. Click cell A2 (Product) Cell cursor appears around A2 3. Menu 'Data - Filter - Advanced Filter' A2:F15 becomes selected 4. Continue in Advanced Filter Dialog 'Read Filter Criteria from- AnyWhere1' ok Filter works, some rows in data area hidden 5. Open Advanced Filter Dialog by click menu 'Data - Filter - Advanced Filter' Expected: AnyWhere1 displays as value showed in dropdown (please see AdvancedFilter dialog_r1521070.png attached) Actual: - undefined - displays as value showed in dropdown -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 --- Comment #19 from fanyuz...@gmail.com --- Created attachment 81518 -- https://issues.apache.org/ooo/attachment.cgi?id=81518action=edit disappeared setting in AdvancedFilter dialog -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 --- Comment #20 from Oliver-Rainer Wittmann o...@apache.org --- (In reply to fanyuzhen from comment #17) This defect is verified fixed in Windows Nightly build(trunk) AOO410m1(Build:9750) - Rev. 1521070 based on the attached sample document Thanks for testing. Thus, I will integrate the fix into branch AOO401 today. -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 --- Comment #21 from Oliver-Rainer Wittmann o...@apache.org --- (In reply to fanyuzhen from comment #18) There is a new problem found when verify this defect, here is the steps: 1. Open attached sample document from AOO Start Center 2. Click cell A2 (Product) Cell cursor appears around A2 3. Menu 'Data - Filter - Advanced Filter' A2:F15 becomes selected 4. Continue in Advanced Filter Dialog 'Read Filter Criteria from- AnyWhere1' ok Filter works, some rows in data area hidden 5. Open Advanced Filter Dialog by click menu 'Data - Filter - Advanced Filter' Expected: AnyWhere1 displays as value showed in dropdown (please see AdvancedFilter dialog_r1521070.png attached) Actual: - undefined - displays as value showed in dropdown PLEASE, do not mix existing problems with new ones. Please see http://www.openoffice.org/qa/issue_handling/pre_submission.html - One problem - one issue Please submit a new issue. I will mark the attached screen shot as obsolete. -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 Oliver-Rainer Wittmann o...@apache.org changed: What|Removed |Added Attachment #81518|0 |1 is obsolete|| --- Comment #22 from Oliver-Rainer Wittmann o...@apache.org --- Comment on attachment 81518 -- https://issues.apache.org/ooo/attachment.cgi?id=81518 disappeared setting in AdvancedFilter dialog obsolete, because it belong to another problem -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 --- Comment #23 from fanyuz...@gmail.com --- There is another problem(regression from revision 1520285) found when verify this defect, here is the steps: 1. Open attached sample document from AOO Start Center 2. Click cell A2 (Product) Cell cursor appears around A2 3. Menu 'Data - Filter - Advanced Filter' A2:F15 becomes selected 4. Continue in Advanced Filter Dialog 'Read Filter Criteria from- AnyWhere1' ok Filter works, some rows in data area hidden 5. Click Ctrl+Z Expected: all rows display, undo the filter action Actual: nothing happens, cannot undo -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 Rainer Bielefeld rainerbielefeld_ooo...@bielefeldundbuss.de changed: What|Removed |Added CC||rainerbielefeld_ooo_qa@biel ||efeldundbuss.de --- Comment #25 from Rainer Bielefeld rainerbielefeld_ooo...@bielefeldundbuss.de --- Again: Please one problem - one issue I will open a new issue for c#18 problem after some tests and invite interested users -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 Oliver-Rainer Wittmann o...@apache.org changed: What|Removed |Added Status|ACCEPTED|RESOLVED Resolution|--- |FIXED --- Comment #27 from Oliver-Rainer Wittmann o...@apache.org --- fixed on trunk and branch AOO401 -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 --- Comment #26 from SVN Robot svn...@dev.null.org --- orw committed SVN revision 1521881 into branches/AOO401: 122862: adjust code for issue 12666 in order to solve regressions 122862, 122... -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 --- Comment #28 from Clarence GUO clarence.guo...@gmail.com --- About YuZhen's test result: The first issue, I think it is a minor defect but I agree with Oliver, it is a separated issue, should not be covered in 122862. I can reproduce it in AOO3.4.0 build, so it is not related to the regression 122862 nor 12666. It is more like a user experience issue, in the last step, what will show in the dialog, leave both select box and cell range picker empty as that in MS Excel, or remember settings in the both controllers. Anyway, leaving select box empty but cell range picker is not, it looks strange. We need behavior discussion to decide the correct behavior. But it should be in post 4.0.1. The second issue, I cannot reproduce against 1521070 build. -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 Oliver-Rainer Wittmann o...@apache.org changed: What|Removed |Added Blocks||122870, 122955, 123161, ||123163 --- Comment #13 from Oliver-Rainer Wittmann o...@apache.org --- The fix for this issue also solves bug 122870, bug 122955, bug 123161 and bug 123163 -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 --- Comment #15 from Oliver-Rainer Wittmann o...@apache.org --- (In reply to Oliver-Rainer Wittmann from comment #14) defect cause: The changes of bug 12666 introduced new internal used database ranges for Auto Filter function. I recognized the following problems in these changes: (1) The newly introduced database ranges are also used for Standard Filter function and Advanced Filter function. (2) The newly introduced code to determine the right database range for the Auto Filter function, Standard Filter function and Advanced Filter function more or less neglects the existence of user-defined database ranges. User-defined database ranges are not used in scenarios in which the user made no cell selection. User-defined database ranges are changed and adjusted. (3) The method which checks the existence of an Auto Filter on a certain cell on a certain sheet neglects the cell and just checks, if a newly introduced internal database range exists at the given sheet. (4) Undo functionality for the creation of the new introduced internal database ranges is missing. -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 --- Comment #16 from Oliver-Rainer Wittmann o...@apache.org --- my solution approach: (A) Restrict the new introduced internal database ranges to the Auto Filter function. To solve bug 12666 it is not needed to used these for Standard Filter function and Advanced Filter function. (B) Remove newly introduced code to determine the right database range for Auto Filter function. But adapt the existing one to the use of the newly introduced internal database ranges. (C) Revert the changes to the code which checks the existence of a Auto Filter at a certain cell in a certain sheet (D) Provide undo functionality for the creation of the newly introduced database ranges for Auto Filter function. (E) Corrections to code snippets which checks, if a certain database range is an internal one (F) Minor refactoring resp. code clean-ups: -- new method to check, if certain database range is an unnamed one -- removal of TAB characters in the source code -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 Kay ksch...@apache.org changed: What|Removed |Added CC||ksch...@apache.org --- Comment #12 from Kay ksch...@apache.org --- Using Linux-32 nightly build (trunk) -- AOO410m1(Build:9750) - Rev. 1520602 2013-09-09_04:36:09-Rev.1520958 Fix, based on the attached sample document, seems good for me. Advanced filter applied to A2:F11 with no errors. -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 Oliver-Rainer Wittmann o...@apache.org changed: What|Removed |Added Hardware|PC |All OS|Windows 7 |All -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 j...@apache.org changed: What|Removed |Added Target Milestone|--- |4.0.1 --- Comment #8 from j...@apache.org --- set target -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 j...@apache.org changed: What|Removed |Added CC||j...@apache.org Flags|4.0.1_release_blocker? |4.0.1_release_blocker+ --- Comment #7 from j...@apache.org --- approve showstopper request -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
4.0.1_release_blocker granted: [Bug 122862] Advanced filter uses wrong Data Area
j...@apache.org has granted Oliver-Rainer Wittmann o...@apache.org's request for 4.0.1_release_blocker: Bug 122862: Advanced filter uses wrong Data Area https://issues.apache.org/ooo/show_bug.cgi?id=122862 --- Additional Comments from j...@apache.org approve showstopper request
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 Oliver-Rainer Wittmann o...@apache.org changed: What|Removed |Added CC||clarence.guo...@gmail.com -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 --- Comment #9 from Oliver-Rainer Wittmann o...@apache.org --- Created attachment 81472 -- https://issues.apache.org/ooo/attachment.cgi?id=81472action=edit patch to known defects caused by 12666 -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 Oliver-Rainer Wittmann o...@apache.org changed: What|Removed |Added Attachment #81472|0 |1 is obsolete|| --- Comment #10 from Oliver-Rainer Wittmann o...@apache.org --- Created attachment 81474 -- https://issues.apache.org/ooo/attachment.cgi?id=81474action=edit patch to known defects caused by 12666 -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 Oliver-Rainer Wittmann o...@apache.org changed: What|Removed |Added Flags||4.0.1_release_blocker? --- Comment #6 from Oliver-Rainer Wittmann o...@apache.org --- working on a fix. If the fix does not work, I will revert the changes from bug 12666 to get this regression fixed for AOO 4.0.1 -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 Rainer Bielefeld rainerbielefeld_ooo...@bielefeldundbuss.de changed: What|Removed |Added See Also||https://issues.apache.org/o ||oo/show_bug.cgi?id=122870 -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug.
[Bug 122862] Advanced filter uses wrong Data Area
https://issues.apache.org/ooo/show_bug.cgi?id=122862 Ariel Constenla-Haile arie...@apache.org changed: What|Removed |Added Keywords||regression --- Comment #2 from Ariel Constenla-Haile arie...@apache.org --- Setting regression keyword. (There are several regressions with spreadsheets in 4.0.0) -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug.
