To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723
------- Additional comments from [email protected] Thu Jun 10 07:06:04 +0000 2010 ------- It seems to me that it would be better to store dates in the format yyyymmdd, much as is done in many accounting programs. Rarely are calculations done on dates. It is basically formated text. With this approach, formating something else as a date would be less of a problem. As well, dates being entrered or output would be handled more efficiently. (It takes much more processing to convert a text date to/from a number than to simply transform the text. Whenever one wishes to compare dates, if it is just a matter of deciding which is greater (or equal), it is just a text comparison, which is fast. If one wishes to calculate the days difference, the dates can be converted to some form of number. Even in accounting, the so-called 30-60-90 aging is actually often done as 1-2-3 calendar months, which could easily be done as a text comparison. (Probably why accounting programs have often stored dates as text.) So by storing dates as text instead of numbers, one gains in efficiency as well as reducing the impact of mis-recognition of text as dates. In any case, it is much better to either query conversion to dates (like is done for formulas) or to add an option to turn of automatic special formating -- of dates or whatever. THIS BUG NEEDS TO BE FIXED. --------------------------------------------------------------------- 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]
