To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90862 Issue #|90862 Summary|When information is filtered using the auto filter, au |to filling the visible cells fills all hidden cells. Component|Spreadsheet Version|OOo 2.4.1 RC2 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|formatting Assigned to|spreadsheet Reported by|akjacques
------- Additional comments from [EMAIL PROTECTED] Thu Jun 19 06:05:26 +0000 2008 ------- Occurs when attempting to modify a spreadsheet in Calc with the auto filter activated and viewing a filtered selection of data, where only the data required is visable on the screen. There is no way to specifically auto-fill the visible cells without filling all the hidden cells in between those filtered. This means that to change or enter a repetitive value in a filtered selection of cells requires the cell to be modified individually and performed multiple times. Microsoft Excel is different to this and when a selection is filtered and the autofill feature is used, only those cells visible on the screen are filled with the new value. This is one of the most frustrating issues and the only real deficiency i see in Calc. --------------------------------------------------------------------- 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]
