|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | date error | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | Calc | Reporter: | cgreco <cgreco> | ||||||
| Component: | code | Assignee: | oc | ||||||
| Status: | CLOSED DUPLICATE | QA Contact: | issues@sc <issues> | ||||||
| Severity: | Trivial | ||||||||
| Priority: | P3 | CC: | email, issues, kyoshida | ||||||
| Version: | 643 | ||||||||
| Target Milestone: | --- | ||||||||
| Hardware: | PC | ||||||||
| OS: | Linux, all | ||||||||
| Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||
| Developer Difficulty: | --- | ||||||||
| Attachments: |
|
||||||||
|
Description
cgreco
2002-10-13 00:27:47 UTC
I've noticed this too. I've seen this happen in both the Linux and Windows versions of 643. Kohei *** Issue 8375 has been marked as a duplicate of this issue. *** Easy reproduction scenario: new spreadsheet, enter the following formula into a cell: =TODAY(). You'll see that the resulting date is yesterday. Actually all it takes to reproduce this is to just type in a date in a cell. For example, when I type 10/23/2002, it becomes 10/22/2002 when entered. *** Issue 9133 has been marked as a duplicate of this issue. *** *** Issue 8954 has been marked as a duplicate of this issue. *** While running OpenOffice.org build 643C on
Linux i686 - kernel 2.4.19 - libc 2.2.4
1. I've originally seen this bug while system locale was set to its
default (America/Sao_Paulo - BRST), with RTC/hwclock stored as UTC.
Currently the DAYLIGHT SAVINGS TIME is active at this time zone. What
I see is:
=TODAY() results in one day less than today
Entering a number (for example, number 0) results in a displayed
date that is one day less than the expected date (expected
30.dec.1899, displayed 29.dec.1899);
Entering any date (e.g. 30.dec.1899) results in displaying the
typed date, but formatting the date as default reveals that the number
is the expected number plus 1 (e.g., 1)
2. After I changed the system locale to "Europe/Berlin" (CET), then:
=TODAY() results in correct date (today);
but typing any date from 01.apr.2002 to 27.oct.2002 results in
subtraction of one day from the date "number", and the displayed date
is one day less than the typed date;
entering any number (for example, number 0) and formatting as date
shows the correct corresponding date (e.g., 30.12.1899);
I hope this information can be useful in some way.
Created attachment 3721 [details]
TEST CASE WITH ACTIONS / RESULTS UNDER DIFFERENT LOCALE SETTINGS
Created attachment 3722 [details]
Self-explanatory sample file with actions / results under different system locale settings
*** Issue 9505 has been marked as a duplicate of this issue. *** This indeed was a timezone glitch and was fixed in the 644 build line. You may try the changes of the following files and revisions: svtools/source/numbers/zforfind.cxx 1.27, 1.29 svtools/source/numbers/zformat.cxx 1.45 unotools/inc/unotools/calendarwrapper.hxx 1.6 unotools/source/i18n/calendarwrapper.cxx 1.8 *** Issue 9900 has been marked as a duplicate of this issue. *** *** Issue 10228 has been marked as a duplicate of this issue. *** Reopened for changing status Will be fixed with 9132 *** This issue has been marked as a duplicate of 9132 *** Closed because duplicate *** Issue 10654 has been marked as a duplicate of this issue. *** *** Issue 10654 has been marked as a duplicate of this issue. *** *** Issue 10707 has been marked as a duplicate of this issue. *** *** Issue 10749 has been marked as a duplicate of this issue. *** *** Issue 11508 has been marked as a duplicate of this issue. *** *** Issue 12484 has been marked as a duplicate of this issue. *** |