Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | ISO standard date formats (YYYY-MM-DD and YYYY-MM-DD HH:MM and YYYY-MM-DD HH:MM:SS) in the date format picklist for all applications. | ||
---|---|---|---|
Product: | Internationalization | Reporter: | ooo |
Component: | code | Assignee: | AOO issues mailing list <issues> |
Status: | ACCEPTED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | gerry, issues, robin.laing, stp |
Version: | 641 | ||
Target Milestone: | --- | ||
Hardware: | Other | ||
OS: | All | ||
URL: | http://www.cl.cam.ac.uk/~mgk25/iso-time.html | ||
Issue Type: | FEATURE | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
ooo
2002-02-14 10:43:11 UTC
DL->ER: I think it might be your task. er->cs: do you mean to list the ISO formats on top of the list instead of further down? Claus, could I get an answer regarding my question, please? I would put the ISO formats at the top. But the best way would be that the date and time standard listed first is the language dependable. Then the ISO formats. And at the bottom all the formats. Consider using the msgid number format code field of locale data XML files for UI sorting purposes: <FormatElement msgid="..."> Using spreadsheet format to facilitate genealogical studies can only handle a 100 year period. Not too troublesome except cells insist on converting to two digit year and prints them that way. Need ability to share information with my European friends in a format that both of us can understand. Today's date is 25 May 2002. My dates like 25 Jul 1885 get converted to 07/25/85. I would like control over that. I can adjust via the tool set which span of years are covered. But printing the dates with two digit years is confusing. er->JoeRooney: I don't see your problem. Just use a number format that displays dates with centuries, for example, YYYY-MM-DD retarget to OOo Later Should this be retargeted again? It was retargeted over a year ago - and I would really like to see this feature in OOo 2.0. And as far as I can see it should be too complicated to add these date and time formats to the ones which is already implemented - even if it is only at the bottom of the formats in the list. Then we can change the order afterwards. The best way open source software can beat closed source software is by using open standards. So please reconsider this issue. Thanks in advance Claus, This issue is not about adding ISO date/time formats, but a predefined order of listing of formats, and to move the ISO formats more to the top of the list. To have that handled in a more general way it's not just about reordering some entries, but to provide a mechanism to be able to specify an ordering within the locale data. So no, no retargeting. Eike Ok - but Impress still lacks the ISO date format. I'll create a new issue concerning this. I'm looking forward to the fixing of this issue. Thanks in advance. May I ask that you make one for writer while you are at it. We should be consistent. You're right - Writer only have YYYY-MM-DD and lacks YYYY-MM-DD hh:mm and YYYY-MM-DD hh:mm:ss. It is the same with Calc. I create issues for Writer and Calc also. Both, Calc and Writer, use the same set of predefined format codes in the number formats dialog. There is no need for separate issues. Eike The difference is if they are listed or not. The diffent applications have their specific way to select formats for date and time. In Writer date and time is set by fields and you can select the format YYYY-MM-DD but not the other two. But you can write your own format under "Additional formats...". In Calc you specify the format of the cell and you can select the format YYYY-MM-DD but not the other two. But you can write your own format under "Format code" in the "Format Cells" dialog box. In Impress and Draw date and time is set by fields and you can only use formats which is in the drop-down-list when you right click the field. Maybe Impress and Draw should implement fields the same way as Write which gives the user more opportunities. And not only when it comes to date and time fields. To add to this. This issue was opened in 2002 and it is still not fixed or resolved. Yes there are ISO dates in some dropdown menues but there are areas that it has not occured. In Calc, you cannot set the date format of headers and footers. It uses the format as set in the Options selection. There is no selection for ISO dates in the options settings for default selection. Why cannot OOo support "One default setting" for the whole suit and then still allow customization as required. I tested this in 1.9.95 today. Added to cc To add my comment to this issue. Our locale settings don't reflect the date code that we need to use. We are moving to ISO format and when the locale settings are taking over for what we need as a default setting is a pain. Especially when headers and footers become involved. Of course we run into this situation with Microsoft Office as well. What is needed it a way to set OOo's default formats in the options selections. To provide an example. My locale is English Canada but our company date format is YYYY-MM-DD, not MM/DD/YY. It makes it hard when I want to insert a date field. In Linux, there is no way to set the system wide date format (at least easily) as there is in Windows so the option isn't to change the system default which I would love to do. Reset assigne to the default "issues@openoffice.apache.org". |