Apache OpenOffice (AOO) Bugzilla – Issue 115842
empty cells should inherit column, not default, format
Last modified: 2013-07-21 13:15:27 UTC
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.
Created attachment 75182 [details] file with special column formats
As given in description Rev. 1503704 Win 7