*------- Original Message --------* *Subject: * [users] Date issue on open office.org calc *Date: * Thu, 12/Jul/2007 5:01:13 AM +0550 *From: * Jonathon Coombes <[EMAIL PROTECTED]> *To: * [email protected]
> > 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? Jonathan, What ever the base date that I changed to, the date rolling still occurred when I gave the cell pointer focus to such cells with dates. I noticed during yesterdays testing, this only occurs to files with .xls extension originally generated using Excel and NOT with .ods extension. All my former test have been performed on Windows XP with OOo 2.2.x but I did some tests today on a Fedora 7 with OOo 2.2.0 and it works without this problem either on .xls originally generated by Excel or .ods files. > >> 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] > >
