Issue 90495 - User selected default cell formats
Summary: User selected default cell formats
Status: CLOSED DUPLICATE of issue 97234
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.4.0
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-06-08 20:25 UTC by mara1618
Modified: 2017-05-20 09:53 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description mara1618 2008-06-08 20:25:26 UTC
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.
Comment 1 oc 2008-07-15 10:44:29 UTC
reassigning features and enhancements to user which
will be the default owner for those tasks (was introduced some time ago)
Comment 2 Edwin Sharp 2013-12-22 17:44:54 UTC
Duplicate bug.

*** This issue has been marked as a duplicate of issue 97234 ***