[sc-issues] [Issue 103976] Autofilter and Standard F ilter not intuitive
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103976 --- Additional comments from mrmaceur...@openoffice.org Tue Aug 4 08:36:04 + 2009 --- Correct, if I define a Data Range and then select it and try to use the Standard Filter... it works correctly. However, to me, it's a bug - If Autofilter headers can't be detected correct as I describe, users will think that the filter function isn't working when they are trying to use the Standard Filter function. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103976] Autofilter and Standard F ilter... not working correct
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103976 Issue #|103976 Summary|Autofilter and Standard Filter... not working correct Component|Spreadsheet Version|OOO310m11 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|editing Assigned to|spreadsheet Reported by|mrmaceurope --- Additional comments from mrmaceur...@openoffice.org Mon Aug 3 16:35:51 + 2009 --- I have started to use OpenOffice as my primary Office Suite and I'm using Calc a lot... While using the AutoFilter function (Data - Filter - Autofiler) I discovered a few bugs, which I think are related. Scenario: (see attachment) If you create a sheet1 with only column headers - e.g. HEADER1...HEADER3 and active Autofiler - no problems. Issue/Bug: If you then create a sheet2 with a sheet header, e.g. 'My Budget' and then in row 2 adds HEADER1...HEADER3 as above and the turn on AutoFilter. Problems! First of all, the AutoFilter dialogs on sheet1 are turned off and on sheet2 your are able to choose a specific value to filter, but you can't really use the 'Standard Filter' function, as the headers no longer are recognized, the Standard Filter dialog shows only the ColumnA...X as field names not the column header titles. Workaround: I found, that if I add a empty Row between the sheet header, 'My Budget' and the first column header e.g. in row 3, no issues. ??? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103976] Autofilter and Standard F ilter... not working correct
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103976 --- Additional comments from mrmaceur...@openoffice.org Mon Aug 3 16:37:14 + 2009 --- Created an attachment (id=63937) Examples on problems with Standard Filter and Autofilter - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 12666] autofilter works just on o ne sheet (only one auto-range per document)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=12666 --- Additional comments from mrmaceur...@openoffice.org Mon Aug 3 16:41:28 + 2009 --- Any update on this issue? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 101712] Countif can't count text wildcards
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101712 Issue #|101712 Summary|Countif can't count text wildcards Component|Spreadsheet Version|OOo 3.0.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|mrmaceurope --- Additional comments from mrmaceur...@openoffice.org Sat May 9 16:26:09 + 2009 --- I have just imported a large Microsoft Excel file into OOO 3.0.1. The spreadsheet uses the COUNTIF function, but it didn't have be the same result as in Excel. Then I checked the formula and I found that OOO doesn't allow the use of wildcard when using CountIf. If you e.g. want to count Columns with more words (text) in each cell, the function fails. Please see my attached Calc file. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 101712] Countif can't count text wildcards
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101712 --- Additional comments from mrmaceur...@openoffice.org Sat May 9 16:27:24 + 2009 --- Created an attachment (id=62122) Example to show the problem with COUNTIF with use of wildcards - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 101712] Countif can't count text wildcards
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101712 User mrmaceurope changed the following: What|Old value |New value Platform|Unknown |All - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 101712] Countif can't count text wildcards
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101712 --- Additional comments from mrmaceur...@openoffice.org Sat May 9 23:04:25 + 2009 --- Correct as stated by TomWb, to use wildcards with the COUNTIF function I need to use Regular Expressions. But - this should then have been 'catch' by the Excel Importer function, cause otherwise many people will see this as something OOO can't handle which isn't true! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sw-issues] [Issue 100288] table style format are no t inhered when tabing a new row
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=100288 Issue #|100288 Summary|table style format are not inhered when tabing a new | row Component|Word processor Version|OOo 3.0.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|writerneedsconfirm Reported by|mrmaceurope --- Additional comments from mrmaceur...@openoffice.org Tue Mar 17 20:27:19 + 2009 --- In OpenOffice 3.0.1 on Mac and Windows; I create a, let's say a 4 by 4 table, then adding some titles for the headers and some text.. so fare so good. Then I format the table so that the outline borders of the table lines are a bit larger than the lines inside the table (see attachment). Looks fine, but then I need to add more information to my table, so I TAB to the end of the table, one more TAB and OpenOffice adds a new row to my table, fine, but the formatting are not looking good, the thicker outline lines are copied to the new row/cells, but it should only had been the outline lines instead of every cell. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sw.openoffice.org For additional commands, e-mail: issues-h...@sw.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sw-issues] [Issue 100288] table style format are no t inhered when tabing a new row
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=100288 --- Additional comments from mrmaceur...@openoffice.org Tue Mar 17 20:31:04 + 2009 --- Created an attachment (id=60997) Screenshot - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sw.openoffice.org For additional commands, e-mail: issues-h...@sw.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org