To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=30216
------- Additional comments from [email protected] Mon Jul 5 12:48:45 +0000 2010 ------- To OpenOffice.org . My problem with your spreadsheet is your default date format of DD/MM/YYYY. I prefer to adhere to International Standard (ISO 8601) date format of YYYY-MM-DD. I have configured my Windows XP to adhere to International Standard (ISO 8601) YYYY-MM-DD for date and 24-hour HH:MM:SS for time. . True, although you allow me to change the date format, you make it very difficult for me to do so. You give me no way to override your default. I live in Canada. The old date format here WAS (in the PAST) DD/MM/YYYY. But the Standards Council of Canada has changed that by adopting the International (ISO 8601) of YYYY-MM-DD. . Your =NOW() function does not even include the following in its list of formats: YYYY-MM-DD HH:MM:SS . There would be less confusion for you and me and everybody else if everybody were to agree to a single date-format standard -- which is the reason for the existence of International Standards. However, instead of encouraging users to adhere to International ISO8601, by imposing your defaults on users, you are discouraging users from adhering to International Standards. . This comment submitted on Monday, 2010-07-05 08:49 --------------------------------------------------------------------- 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]
