To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84414 Issue #|84414 Summary|Formula bar: ability to set default date format on for |mula bar Component|Spreadsheet Version|OOo 2.3.1 RC1 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|bijugc
------- Additional comments from [EMAIL PROTECTED] Mon Dec 10 08:36:13 +0000 2007 ------- Sub: Formula bar: ability to set default date format on formula bar. On my OS date format is yyyy-MM-dd And the worksheet cell format is YYYY-MM-DD Still OOo Calc show content on formula bar in an alien date format. I also dont see any option in Tools > Options to set default date display format for the whole sheet. * I believe Lotus 123 use to have workbook date format setting. * MS-Excel follow system date format. Steps:- 1. Goto MS-Windows start menu 2. Goto Control Panel > Regional and Language Options 3. Select "Regional Options" tab 4. Select "Customize..." button (see attachment RegionalOptions.png) 5. Goto "Customize Regional Options" screen, then "Date" tab 5. Set Date format to yyyy-MM-dd 6. Click "OK" on "Customize Regional Options" 7. click "Apply" on "Regional and Language Options" screen 8. Start OOo Calc 9. Select a Cell 10. from menu select Format > Cells.. 11. on "Numbers" tab 12. enter format code as YYYY-MM-DD 13. click "OK" to come back to the data entry mode 14. enter "2007-11-30" 15. Press Enter Key 16. up arrow to select date again 17. on formula bar you see 11/30/2007 (see attachement OOoCalcDate.png) Expected date format "2007-11-30" as in MS-Excel (see excel.png) BTW: Issue 30216 for Writer says there is a way to set default date format (may not for formula bar) but I dont see it in OOo Calc 2.3.1 I would have expected it in menu under "General" settings ... > Tools ... ... > Options ... ... ... ... > Openoffice.org ... ... ... ... > General <---- here ... ... ... > Openoffice.org Calc ... ... ... ... > General <---- or here I can select entire sheet and select Format > cells to choose format as YYYY-MM-DD, but it change all numeric cell including percent and dollor cells to date format. Which is not as I expected. --------------------------------------------------------------------- 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]