[sc-issues] [Issue 85361] Calc:edit bar formats date s incorrectly

2008-01-20 Thread kpalagin
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=85361


User kpalagin changed the following:

What|Old value |New value

  CC|''|'kpalagin'





--- Additional comments from [EMAIL PROTECTED] Sun Jan 20 16:10:41 + 
2008 ---
This looks like duplicate to http://www.openoffice.org/issues/show_bug.cgi?
id=84414.

-
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]



[sc-issues] [Issue 85361] Calc:edit bar formats date s incorrectly

2008-01-20 Thread dotancohen
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=85361





--- Additional comments from [EMAIL PROTECTED] Sun Jan 20 18:06:54 + 
2008 ---
Yes, this bug is a dupe of bug #84414. I have posted the relevant info there,
with a correction to an error that was posted here. Sorry for the noise,
apparently I missed 84414 when searching.

-
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]



[sc-issues] [Issue 85361] Calc:edit bar formats date s incorrectly

2008-01-20 Thread kpalagin
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=85361


User kpalagin changed the following:

What|Old value |New value

  Status|UNCONFIRMED   |RESOLVED

  Resolution|  |DUPLICATE





--- Additional comments from [EMAIL PROTECTED] Sun Jan 20 20:30:54 + 
2008 ---
Dup to 84414.

*** This issue has been marked as a duplicate of 84414 ***

-
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]



[sc-issues] [Issue 85361] Calc:edit bar formats date s incorrectly

2008-01-20 Thread kpalagin
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=85361


User kpalagin changed the following:

What|Old value |New value

  Status|RESOLVED  |CLOSED





--- Additional comments from [EMAIL PROTECTED] Sun Jan 20 20:31:52 + 
2008 ---
Closing.

-
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]



[sc-issues] [Issue 85361] Calc:edit bar formats date s incorrectly

2008-01-18 Thread dotancohen
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=85361
 Issue #|85361
 Summary|Calc:edit bar formats dates incorrectly
   Component|Spreadsheet
 Version|OOo 2.3.1
Platform|All
 URL|
  OS/Version|Linux
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|DEFECT
Priority|P3
Subcomponent|formatting
 Assigned to|spreadsheet
 Reported by|dotancohen





--- Additional comments from [EMAIL PROTECTED] Fri Jan 18 12:45:49 + 
2008 ---
Calc does not respect the locale's LC_TIME setting for date formatting in the
edit bar. Dates are always formatted MM/DD/ regardless of locale.

In this example, I use locale en_DK.utf8 which has the date format /MM/DD.

$ locale
LANG=en_DK.utf8
LANGUAGE=en_DK.utf8
LC_CTYPE=en_DK.utf8
LC_NUMERIC=en_DK.utf8
LC_TIME=en_DK.utf8
LC_COLLATE=en_DK.utf8
LC_MONETARY=en_DK.utf8
LC_MESSAGES=en_DK.utf8
LC_PAPER=en_DK.utf8
LC_NAME=en_DK.utf8
LC_ADDRESS=en_DK.utf8
LC_TELEPHONE=en_DK.utf8
LC_MEASUREMENT=en_DK.utf8
LC_IDENTIFICATION=en_DK.utf8
LC_ALL=en_DK.utf8
$ openoffice.org2.3 -calc

Now, I select column A - Format Cells - Numbers - Category - Date - Format
- 1999-12-31. I now enter 2008-1-16 into cell A1 and hit enter. The cursor
moves to cell A2 and I see 2008-01-16 in cell A1. So far so good. Now, I click
on cell A1. The cell still says 2008-01-16 however the input line reads
01/16/2008.

The edit bar should format dates as they are formatted for display in the cell.
Failing that, it should display in the locale's preferred format.

Note: the problem _may_ be that Gnome's date format is not configured properly.
I use KDE on Ubuntu, with Gnome installed as the default desktop. However, due
to a poorly written ATI driver I cannot open Gnome and change the setting.
Googling and locating has not led me to discover which config file I should edit
in VI to change this setting. In any case, Gnome's setting should _not_ be the
deciding factor in which date format to use. Not everyone uses Gnome, and that
is specifically what LC_TIME is for.

-
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]