[sc-issues] [Issue 84414] Formula bar: ability to se t default date format on formula bar

2010-10-28 Thread matteosistisette
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=84414





--- Additional comments from matteosistise...@openoffice.org Thu Oct 28 
11:11:01 + 2010 ---
** SORRY I DIDN'T MEAN TO POST IT HERE **

Please delete my previous comment. I thought I was editing another issue, not
this one. I posted it here by mistake.

(Shame that one cannot edit or delete his/her own comments btw)

-
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[sc-issues] [Issue 84414] Formula bar: ability to se t default date format on formula bar

2010-10-28 Thread matteosistisette
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=84414





--- Additional comments from matteosistise...@openoffice.org Thu Oct 28 
11:08:45 + 2010 ---
EVEN WORSE:

I opened one of those XLS files with dates. I MANUALLY selected all cells
contained dates and did "format cells" and selected "date" and "31/12/2010".

Then I entered some more data into the document and the disastrous spontaneous
change didn't happen, even after scrolling, so the workaround seemed to have 
worked.

Then as soon as I SAVED the document, all dates were changed to numbers.
There's NO WAY to keep updating an old XLS file generated with a previous 
version.

This makes OpenOffice Calc unusable. I'll look for another spreadsheet program.

-
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[sc-issues] [Issue 84414] Formula bar: ability to se t default date format on formula bar

2009-06-23 Thread dotancohen
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=84414





--- Additional comments from dotanco...@openoffice.org Tue Jun 23 19:52:59 
+ 2009 ---
Actually, as this issue is requesting a separately configurable date format for
the formula bar, I think it is a dupe of bug 72229. Bug 5556 requests that the
formula bar use the same date format as the cell is configured for. At least,
that is the difference that I perceive between the two bugs.

-
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[sc-issues] [Issue 84414] Formula bar: ability to se t default date format on formula bar

2009-06-23 Thread regina
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=84414


User regina changed the following:

What|Old value |New value

  CC|'kpalagin'|'kpalagin,regina'





--- Additional comments from reg...@openoffice.org Tue Jun 23 17:47:59 
+ 2009 ---
Please have a look at issue 5556 and issue 72229. You should move with your
votes to one of them.

I think this issue is duplicate to issue 5556 and it should be closed therefore.

-
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[sc-issues] [Issue 84414] Formula bar: ability to se t default date format on formula bar

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=84414





--- Additional comments from [EMAIL PROTECTED] Sun Jan 20 20:30:51 + 
2008 ---
*** Issue 85361 has been marked as a duplicate of this issue. ***

-
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 84414] Formula bar: ability to se t default date format on formula bar

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=84414





--- Additional comments from [EMAIL PROTECTED] Sun Jan 20 18:04:55 + 
2008 ---
I agree that this issue needs to be tested after 51662 gets fixed.

I am having similar problems on an Ubuntu machine running KDE. 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-01-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]



[sc-issues] [Issue 84414] Formula bar: ability to se t default date format on formula bar

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


User bijugc changed the following:

What|Old value |New value

 IssuesThisDependsOn|  |51662

  Status|CLOSED|UNCONFIRMED

  Resolution|DUPLICATE |





--- Additional comments from [EMAIL PROTECTED] Thu Jan 10 02:35:40 + 
2008 ---
Fix for issue 51662 may fix this.
But 51662 is only talking about the decimals

As issue 50670, issue 39898, issue 38494, issue 31663, issue 45312, issue 1820
are similar and some of them are fixed, but it did not automatically fix issue
51662. Hence I am little skeptical about this getting fixed automatically when
51662 get fixed.

So I am reopening this and adding this as depended to 51662, we should only
close this after testing and find it got 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]



[sc-issues] [Issue 84414] Formula bar: ability to se t default date format on formula bar

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


User kpalagin changed the following:

What|Old value |New value

  Status|RESOLVED  |CLOSED





--- Additional comments from [EMAIL PROTECTED] Wed Jan  9 13:45:51 + 
2008 ---
Closing.

Please vote for 51662.

-
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 84414] Formula bar: ability to se t default date format on formula bar

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


User kpalagin changed the following:

What|Old value |New value

  CC|''|'kpalagin'

  Status|UNCONFIRMED   |RESOLVED

  Resolution|  |DUPLICATE





--- Additional comments from [EMAIL PROTECTED] Wed Jan  9 13:45:11 + 
2008 ---
I think this issue in essence is duplicate to 
http://qa.openoffice.org/issues/show_bug.cgi?id=51662.


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

-
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 84414] Formula bar: ability to se t default date format on formula bar

2007-12-10 Thread bijugc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=84414





--- Additional comments from [EMAIL PROTECTED] Mon Dec 10 08:38:58 + 
2007 ---
Created an attachment (id=50200)
excel.png


-
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 84414] Formula bar: ability to se t default date format on formula bar

2007-12-10 Thread bijugc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=84414





--- Additional comments from [EMAIL PROTECTED] Mon Dec 10 08:38:21 + 
2007 ---
Created an attachment (id=50199)
OOoCalcDate.png


-
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 84414] Formula bar: ability to se t default date format on formula bar

2007-12-10 Thread bijugc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=84414





--- Additional comments from [EMAIL PROTECTED] Mon Dec 10 08:37:30 + 
2007 ---
Created an attachment (id=50198)
RegionalOptions.png


-
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 84414] Formula bar: ability to se t default date format on formula bar

2007-12-10 Thread bijugc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=84414
 Issue #|84414
 Summary|Formula bar: ability to set default date format on for
|mula bar
   Component|Spreadsheet
 Version|OOo 2.3.1 RC1
Platform|All
 URL|
  OS/Version|Windows XP
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|DEFECT
Priority|P3
Subcomponent|editing
 Assigned to|spreadsheet
 Reported by|bijugc





--- Additional comments from [EMAIL PROTECTED] Mon Dec 10 08:36:13 + 
2007 ---
Sub: Formula bar: ability to set default date format on formula bar.

On my OS date format is -MM-dd
And the worksheet cell format is -MM-DD

Still OOo Calc show content on formula bar in an alien date format.
I also dont see any option in Tools > Options to set default date display format
for the whole sheet.
* I believe Lotus 123 use to have workbook date format setting.
* MS-Excel follow system date format.

Steps:-
1. Goto MS-Windows start menu
2. Goto Control Panel > Regional and Language Options
3. Select "Regional Options" tab
4. Select "Customize..." button (see attachment RegionalOptions.png)
5. Goto "Customize Regional Options" screen, then "Date" tab
5. Set Date format to -MM-dd
6. Click "OK" on "Customize Regional Options" 
7. click "Apply" on "Regional and Language Options" screen
8. Start OOo Calc
9. Select a Cell
10. from menu select Format > Cells..
11. on "Numbers" tab 
12. enter format code as -MM-DD
13. click "OK" to come back to the data entry mode
14. enter "2007-11-30" 
15. Press Enter Key
16. up arrow to select date again 
17. on formula bar you see 11/30/2007  (see attachement OOoCalcDate.png)


Expected date format "2007-11-30" 
as in MS-Excel (see excel.png)


BTW: 
Issue 30216 for Writer says there is a way to set default date format (may not
for formula bar) but I dont see it in OOo Calc 2.3.1
I would have expected it in menu under "General" settings
... > Tools 
... ... > Options ... 
... ... ... > Openoffice.org
... ... ... ... > General< here
... ... ... > Openoffice.org Calc
... ... ... ... > General< or here

I can select entire sheet and select Format > cells to choose format as
-MM-DD, but it change all numeric cell including percent and dollor cells to
date format. Which is not as I expected.

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