Issue 115842

Summary: empty cells should inherit column, not default, format
Product: Calc Reporter: tab <tab>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: elish, issues
Version: OOo 3.2.1   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
file with special column formats none

Description tab 2010-11-30 15:30:28 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.
Comment 1 tab 2010-11-30 15:33:02 UTC 
Created attachment 75182 [details]
file with special column formats
Comment 2 Edwin Sharp 2013-07-21 13:15:27 UTC 
As given in description

Rev. 1503704 Win 7