On 11/07/2007, at 9:56 PM, Lasantha Marian wrote:
This problem has been there since the beginning of OOo 2.2.x (starting
with RCs') and I have brought the attention of the developers also to
the same by this bug report
(http://www.openoffice.org/issues/show_bug.cgi?id=75118). Nothing
positive has happened yet. OOo 2.0.x series is immune to this problem.
Maybe we should look at breaking this down and focusing on the
problem at hand. The bug that is mentioned refers to problems only
under MS Windows, and is not even listed as a confirmed problem at
this point? Secondly, the time difference seems to be a standard 1
day difference whereas the OP said they had a difference of 2 days?
The circumstances under which I found the problem were different to
how
you may how found the problem. But I too have done various test and
can
confirm that this problem occurs under following conditions.
Any sheet having date cells imported from databases (MSSQL or
PostgreSQL) or pasted from result sets given by such programs, can
have
the problem. When the cell pointer is focussed at the cell (having
such
dates) the date rolls back/forward by one date.
Again, this may be the case, but I have not tested it yet, however
the original poster did not mention any issues with Base fields at
all? Simply that on saving and re-opening, the dates changed by 2 days.
Jonathan, your point I too have observed and I found that this problem
and the behavior you mentioned are mutually exclusive.
Why do you think they are different? That may be the case, but I
would be interested in how you came to that conclusion?
I think attention of OOo developers should be immediately paid to this
as date cells are almost unavoidable in Spreadsheets and accurate
representation of dates are essential under any circumstance.
This part I can agree with - as I mentioned, the dates changing in
any situation is going to cause problems and end up giving false
information.
Regards
Jonathon
Jonathon Coombes wrote:
<div class="moz-text-flowed" style="font-family: -moz-fixed">
On 05/07/2007, at 12:35 PM, Gary Dale wrote:
Guan Kiet Yeo wrote:
Dear Sir,
I'm using version 2.2.1 of OpenOffice.org Calc. My
problem is the date after I save and then re-open the
file, the date that I have key in the worksheet will
totally run out. It will change to 2days earlier.
For example, I key in 07/01/07, it will show
06/29/07. Please help me to solve it out.
Thanks & Best Regards,
Jet Yeo
+63 920 583 9051
+6012-260 2606
I think that no one has replied because they don't understand what
the problem is that you are having. When you key in a date, it
displays properly unless there is something else involved. Can you
explain your problem more completely?
- does this happen in any worksheet, even a new, blank one?
- does it happen in any cell formatted as a date?
- does it happen immediately or do you have to close the worksheet
and re-open it?
Have a look under the Tools -> Options -> OpenOffice.org Calc ->
Calculate area and you will see a section labeled 'Date'. My guess is
that you had entered your dates and then this area was changed from
default to one of the other two values either in your application or
by using a different install of OpenOffice.org to your original. Just
note that if you enter a date and change these Date settings, the
dates will change. You have to reenter existing dates to get them
accurate, but once changed there will be no issue if you keep it
consistent. Also note that it is dangerous to use the non-default
values here if you intend to share these or use them with other
versions set for default in the future.
Regards
Jonathon
--------------------------
Jonathon Coombes
OOo Knowledgebase:- http://mindmeld.cybersite.com.au
http://www.cybersite.com.au
http://www.training4linux.com
</div>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
------------------------------------
Jonathon Coombes - Cybersite Consulting
MySQL Consulting + Training Partner
Authorised MySQL Training Centre
http://www.cybersite.com.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
