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]

Reply via email to