To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115842 Issue #|115842 Summary|empty cells should inherit column, not default, format Component|Spreadsheet Version|OOo 3.2.1 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|tab
------- Additional comments from t...@openoffice.org Tue Nov 30 15:30:28 +0000 2010 ------- in Format.ods, col A has been formated for dates YYYY-MM-DD, col B in font CourierNew, number 0.00. Select A3-B3, drag it to A4-B4, leaving A3-B3 blank; enter '9-14' in A3, get '09/14/10' (old format); enter '7' in B3, get '7' in Arial instead of '7.00' in CourierNew. It's understandable --blank cells get the default format-- but annoying in most cases. Suggested enhancement: when a whole column has been formatted (by clicking its header A, B, ..), the format should be inherited by any empty row. The user can always reformat individual cells. The current behaviour could be retained if the special format was applied to a block of cells instead of a whole column. --------------------------------------------------------------------- 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