Issue 78199 - Calc - entering certain date in certain cell automatically decrements the date by 1 day
Summary: Calc - entering certain date in certain cell automatically decrements the dat...
Status: CLOSED DUPLICATE of issue 76623
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.2
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-06-07 20:12 UTC by kpalagin
Modified: 2007-07-11 12:52 UTC (History)
5 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Problematic file (65.50 KB, application/vnd.ms-excel)
2007-06-07 20:13 UTC, kpalagin 		no flags Details
Screenshot. Circled in green is what I typed. (12.94 KB, image/png)
2007-06-08 06:59 UTC, kpalagin 		no flags Details
example (9.21 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-06-28 22:12 UTC, chkur 		no flags Details
screenshot - example file opened in local time(+2) #1 (163.01 KB, image/jpeg)
2007-06-28 22:16 UTC, chkur 		no flags Details
same example file opened in another (+2)local time (166.52 KB, image/jpeg)
2007-06-28 22:18 UTC, chkur 		no flags Details
same example file opened in local time (+3) (152.07 KB, image/jpeg)
2007-06-28 22:20 UTC, chkur 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description kpalagin 2007-06-07 20:12:52 UTC 
Open attached file, in cells K6 and K7 (either one) type date 25.10.1926 or 
11.11.1928, press enter - Calc autodecrements the date by one day.
Issues http://qa.openoffice.org/issues/show_bug.cgi?id=75118 and 
http://www.openoffice.org/issues/show_bug.cgi?id=9132 seems to be very related.
Comment 1 kpalagin 2007-06-07 20:13:58 UTC 
Created attachment 45738 [details]
Problematic file
Comment 2 Regina Henschel 2007-06-07 20:55:13 UTC 
For me it is OK with OOo221 and 680m213 on WinXP.
Comment 3 kpalagin 2007-06-08 06:59:08 UTC 
Created attachment 45745 [details]
Screenshot. Circled in green is what I typed.
Comment 4 tml 2007-06-08 09:11:19 UTC 
Does this happen only in a Russian locale? But on the other hand, the Gregorian
calendar was adopted already in 1918 in Russia (says Wikipedia) and anyway, if
this was caused by some Julian/Gregorian thing, the difference would be much
larger than one day.
Comment 5 kpalagin 2007-06-08 10:06:39 UTC 
This happens with English (USA) localle (in Tools - Options - Languages) using 
also 2.3m211 on WinXP.
Comment 6 pmike 2007-06-20 10:51:33 UTC 
This issue might be caused by using UTC and local time for different timezones.
Comment 7 chkur 2007-06-28 22:12:50 UTC 
Created attachment 46342 [details]
example
Comment 8 chkur 2007-06-28 22:16:49 UTC 
Created attachment 46343 [details]
screenshot - example file opened in local time(+2) #1
Comment 9 chkur 2007-06-28 22:18:39 UTC 
Created attachment 46344 [details]
same example file opened in another (+2)local time
Comment 10 chkur 2007-06-28 22:20:38 UTC 
Created attachment 46345 [details]
same example file opened in local time (+3)
Comment 11 chkur 2007-06-28 22:26:11 UTC 
This issue depends on user's local time(see attachments)
Comment 12 frank 2007-07-11 12:51:52 UTC 
Hi,

this was reported earlier by the French team under Issue 76623 .

So this is a double and is closed as such.

Further findings about this should be filed under Issue 76623.

Thanks

Frank

*** This issue has been marked as a duplicate of 76623 ***
Comment 13 frank 2007-07-11 12:52:13 UTC 
closed double