To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=54580 Issue #:|54580 Summary:|Fill Down in Autofilter Mode in Calc not like MS |Excel Component:|Spreadsheet Version:|OOO 2.0 Beta2 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|kheekien
------- Additional comments from [EMAIL PROTECTED] Tue Sep 13 20:13:51 -0700 2005 ------- When a spreadsheet is filtered (Data->Filter->Autofilter), lets say that there are 3 columns, with headers named as "Bug Description(BU)", "Severity (S)" and "Assigned To (A)", and you have the following rows: BU S A ============== ====== ======= Bug Desc 1 Moderate Bug Desc 2 Moderate Bug Desc 3 Moderate Bug Desc 4 Moderate Bug Desc 5 Minor Bug Desc 6 Minor Bug Desc 7 Minor Bug Desc 8 Moderate Bug Desc 9 Moderate When I filter the list by Severity, by moderate, naturally I will get BU S A ============== ====== ======= Bug Desc 1 Moderate Bug Desc 2 Moderate Bug Desc 3 Moderate Bug Desc 4 Moderate Bug Desc 8 Moderate Bug Desc 9 Moderate Say, when I try to assigned the issue to Peter for example, go to the cell marked "X" and try to fill down "Peter" to the rest of the rows for moderate as in the following example: BU S A ============== ====== ======= Bug Desc 1 Moderate Peter Bug Desc 2 Moderate Bug Desc 3 Moderate Bug Desc 4 Moderate Bug Desc 8 Moderate Bug Desc 9 Moderate X I get this: BU S A ============== ====== ======= Bug Desc 1 Moderate Peter Bug Desc 2 Moderate Peter Bug Desc 3 Moderate Peter Bug Desc 4 Moderate Peter Bug Desc 8 Moderate Peter Bug Desc 9 Moderate Peter which seems to be correct. But on removing the filter I get the following: (Behaviour A) BU S A ============== ====== ======= Bug Desc 1 Moderate Peter Bug Desc 2 Moderate Peter Bug Desc 3 Moderate Peter Bug Desc 4 Moderate Peter Bug Desc 5 Minor Peter Bug Desc 6 Minor Peter Bug Desc 7 Minor Peter Bug Desc 8 Moderate Peter Bug Desc 9 Moderate Peter instead of this: (Behaviour B) BU S A ============== ====== ======= Bug Desc 1 Moderate Peter Bug Desc 2 Moderate Peter Bug Desc 3 Moderate Peter Bug Desc 4 Moderate Peter Bug Desc 5 Minor Bug Desc 6 Minor Bug Desc 7 Minor Bug Desc 8 Moderate Peter Bug Desc 9 Moderate Peter which should be the correct behaviour. --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
