To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72229
------- Additional comments from [EMAIL PROTECTED] Thu Oct 23 10:24:47 +0000 2008 ------- Comments for tab: 1. I agree (with corigo) that either three fields for a single cell, or a pop-up is [highly] undesirable; I want to continue to be able to enter/edit values quickly and efficiently. I can do so now using only the numeric keypad; I cannot with your proposals. 2. If you carefully reread the original description (which I wrote), you may notice that it says nothing about editing; it describes the display of dates on the "Input line" vs. the current cell. Your comment "see which day of the week it is" should have immediately alerted you to yet another relevant problem with your proposal; viz. calendar display is yet another (non-language) user preference (some prefer weeks beginning on Monday, some on Sunday; and that's just for conventional Gregorian calendars -- other calendar types raise other issues (see http://en.wikipedia.org/wiki/Calendar and follow links for other types)). 3. Editing is not the topic of this issue; If I open a spreadsheet with "Language Settings" -> "Languages" -> "Language of" "Locale setting" set to "English (USA)" and date cell format set to ISO 8601 format (format code YYYY-MM-DD), a cell date for today is displayed in-cell as "2008-10-23", whereas in the UI "Input line" is is DISPLAYED as "10/23/2008". That is the issue described here. 4. With settings as described immediately above, I can edit (separate topic) in the input line as "2009-11-24" or "November 24, 2009" or "11.24.2009" or many other formats, all describing a date one year, one month, and one day in the future. In each case the input is correctly parsed and correctly displayed in the cell (but the "Input line" still displays in some other format as determined by "Language Settings" (date format isn't a Language setting) -> "Languages" (date format isn't a Language) -> "Language of" (date format isn't a language) "Locale setting" (<- there is the problem originally described, viz. bundling unrelated UI preferences in a catch-all category). I have no complaint about entering data on the "Input line"; it works (please don't screw it up with pop-ups, etc.!). The complaint -- to reiterate -- is that the display in the "Input line" box differs markedly from that selected for the cell and moreover, that the format used for that "Input line" display is not readily changed. 5. I'd be happy with the "Input line" display formatted per the cell's defined format, which would resolve the issue as far as I'm concerned. Alternatively, providing a means of separate UI settings for separate preferences would be an improvement, with the caveat that the whole notion of a "locale" is fundamentally misguided (e.g. some accounting types like negative currency values displayed in parentheses; that is not a language-specific issue nor is it a geo-political issue -- it is merely a user preference). I personally use a KDE desktop, which does provide separate preference settings for date, time, currency, etc., and I'd be happy if OOo would use those settings, but alas, OOo isn't a KDE application. In any case, the problem is that the current scheme where it is a) difficult to find where the UI gets its date format settings (because it is listed under the irrelevant category of language,language,language,locale) and b) having found where it is configured, it is impossible to independently change the UI date format display. --------------------------------------------------------------------- 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]