To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108014 Issue #|108014 Summary|Format cells as per numerical data entered into them Component|Spreadsheet Version|OOo 3.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|dotancohen
------- Additional comments from [email protected] Wed Dec 30 20:11:51 +0000 2009 ------- Calc can currently auto-format cells based on the numerical data entered into them. For instance, when entering the data "29/12/2009" into a cell with the default (Number-General) formatting, Calc currently correctly formats it as a date. This issue asks that this auto-formatting be extended to auto-format the cell so that the format auto-configured matches that of the data entered. Examples: 1) Data entered as "00351" should be auto-formatted as a number (Calc already does this) with two leading zeros (Calc does not yet do this). 2) Data entered as "29/12" should be auto-formatted as a date (Calc already does this) with the mm/dd format (Calc does not yet do this). --------------------------------------------------------------------- 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]
