Issue 115842 - empty cells should inherit column, not default, format
Summary: empty cells should inherit column, not default, format
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.2.1
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-11-30 15:30 UTC by tab
Modified: 2013-07-21 13:15 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

file with special column formats (8.57 KB, text/plain)
2010-11-30 15:33 UTC, tab
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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 
It's understandable --blank cells get the default format-- but annoying in most 
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