To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90495 Issue #|90495 Summary|Wish to have control over default cell formats Component|Spreadsheet Version|OOo 2.4.0 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|mara1618
------- Additional comments from [EMAIL PROTECTED] Sun Jun 8 19:25:26 +0000 2008 ------- I start with a blank spreadsheet. If I enter something that looks like a date, it gets reformatted: eg entering 1 jan 2000, results in the cell showing 01/01/00. I would like to have control over which edit mask is used as the default, eg set up D-MMM-YYYY as my preferred format. I know I can change the format afterwards, but would prefer that all the dates I enter start off in my preferred format. I want to be able to set my preferred default for any one of the Format Cells / Numbers / Categories, e.g. set up the default so that "currency" showing negative numbers in black, and times don't display the seconds part of the time i.e. HH:MM rather than HH:MM:SS as at present. I'm guessing this might be best done in association with the Template file I'm guessing this could be of advantage also to dealing with any regional differences in displaying cells. --------------------------------------------------------------------- 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]