[Issue] Date decrements by one day in Calc.

Discuss the spreadsheet application

[Issue] Date decrements by one day in Calc.

Postby dickc » Sat Dec 22, 2007 12:48 am

When I input a date such as 12/19/07 into a properly formatted cell, it immediately changes to 12/18/07. What gives?

I am using OpenOffice version 2.3.1.

Under TOOLS, OPTIONS, OPENOFFICE.ORG, CALCULATE, I have the date button selected for 12/30/1899 (default) selected.

Forgive me if I am not posting this correctly...I'm a newbie at this.

Thanks for any help,
Richard Chabot
Last edited by Hagar Delest on Tue Jun 10, 2008 1:24 pm, edited 2 times in total.
Reason: Tagged thread as Issue (link to a bug report).
dickc
 
Posts: 9
Joined: Thu Nov 29, 2007 2:54 am

Re: Date decrements by one day in Calc.

Postby acknak » Sat Dec 22, 2007 3:25 am

I believe[*] this is your issue: Issue 76623: Wrong formatting and displaying for some dates. The problem is triggered by certain time zone settings (and even time-of-day).

It is fixed in the latest snapshots, and due for public release with OOo 2.4 in March.

[*] E.g., this: Issue 78199: Calc - entering certain date in certain cell automatically decrements the date by 1 day definitely sounds like yours, but was ultimately marked as a duplicate of Issue 76623.
Last edited by acknak on Sat Dec 22, 2007 4:03 am, edited 1 time in total.
Reason: Added link to issue 78199
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Date decrements by one day in Calc.

Postby dickc » Sat Dec 29, 2007 3:00 am

Thank you acknak,
I will wait and see what happens in the March update.
I also found that rebooting will sometimes correct the problem and in one instance running the ad-aware program corrected it as well.
Regards
dickc
dickc
 
Posts: 9
Joined: Thu Nov 29, 2007 2:54 am

Re: Date decrements by one day in Calc.

Postby dickc » Sat Apr 05, 2008 1:33 pm

I am using OpenOffice version 2.4.0 and occasionally the date will still decrement by one day immediately after typing in the date and hitting enter or clicking on another cell. I was hoping this would go away with the new version of OpenOffice.
Thanks for any help,
dickc
dickc
 
Posts: 9
Joined: Thu Nov 29, 2007 2:54 am

Re: [Issue] Date decrements by one day in Calc.

Postby Hagar Delest » Sat Apr 05, 2008 3:31 pm

See end of the bug report comments, there is a new report, you should subscribe and vote for it (up to 2 votes per issue) : Issue 86094 - Date is automatically decremented on input.

I've tagged the thread as Issue.
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 29002
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: [Issue] Date decrements by one day in Calc.

Postby dickc » Mon Apr 14, 2008 2:28 pm

Thank You Hagar de I'Est.

I guess I should just wait and hope the problem will be addressed and ultimately fixed.

I tried to vote, but it was rejected.....I'm new at this.

Thanks again,

dickc
dickc
 
Posts: 9
Joined: Thu Nov 29, 2007 2:54 am

Re: [Issue] Date decrements by one day in Calc.

Postby Hagar Delest » Mon Apr 14, 2008 2:45 pm

To vote, you need to register again, the forum registration is independent from the main OOo web site (but you can use the same information of course).
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 29002
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: No registered users and 7 guests