Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | wrong date calculation/display | ||
---|---|---|---|
Product: | Calc | Reporter: | ohallot <olivier.hallot.ooo> |
Component: | code | Assignee: | AOO issues mailing list <issues> |
Status: | CONFIRMED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | cno, elianedomingos, gbpacheco, issues, rainerbielefeld_ooo_qa |
Version: | OOO330m1 | Keywords: | oooqa |
Target Milestone: | --- | ||
Hardware: | Unknown | ||
OS: | All | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- | ||
Attachments: |
Description
ohallot
2010-08-20 17:31:56 UTC
Created attachment 71223 [details]
sample with wrong date display
NOT reproducible with "Ooo-Dev 3.3.0 multilingual version German UI WIN XP: [OOo330m1 (Build 9514)]"! Looks like a DUP of Issue 113028 @ohallot: Please feel free to reopen this issue if you find evidence that this one is an independent issue. I will finally close the issue after 10 days if we will not have got additional information *** This issue has been marked as a duplicate of 113028 *** I am attaching another file where this issue raises: In orange, the date range where the date displayed are wrong. Note that the internal date serial number is not wrong. Look at formula in column C. So it appears that it is a display calculation issue for dates. This issue appears also in OO 3.2.1, Both in Linux and in Windows. Our locale is pt-BR. Sorry to insist, but this is a severe misleading bug and affects confidence in the tool. Regards, Olivier Created attachment 71225 [details]
image of the display we get here
Created attachment 71226 [details]
calc file with issue hilighted
Reopening wit simpler samples of the bug. Not sure the issue of the timezone are to be considered. We are not measuring time... @ohallot: Where is the EVIDENCE showing that this issue is different from Issue 113028? I can't see any! Your overhasty reopening only splits efforts to find the problem unnecessarily, Issue 113028 would have been a much better place to collect information. Please read Issue 113028, try to reproduce the consequences, do the tests recommended there and try to see relations to your problem. Please be detailed in your descriptions! How can I see that the date is shown wrong if you do not tell what your manual input was? from column 'C' I expect "16/01/year")? Please contribute your dates.ods with new name, column headings and additional rows and other (screenshot) information for different settings in 'Tools -> Options -> Calc -> Date' as you see in my "dates_rainerbielefeld.ods". Before you take screenshot, please copy / paste column 'C'. My columns 'E', 'H' only are for my own information. Please contribute information what date calculation settings you use! Created attachment 71236 [details]
Please see comments from rainerbielefeld Sat Aug 21 08:18:34 +0000 2010
PLease find attached the spreadsheet with the results and images of my screen. Linux Mandriva, BrOffice.org 3.2.1, but also seen in OpenOffice.org-pt-BR 3.3.0, M1 for windows (XP). Created attachment 71241 [details]
dates-ohallot
@ohallot: you generally use 01-01-94 setting? Can you reproduce the problem when you start a new document with default date calculation? I see some strange differences in col 'B' between our documents in the screenshots, and I don't have any Idea what the reason might be. Somthing strange, else: generally I saw "-1445.00" in 'F2', but under some curcumstances I saw "-2907,00", it seems when I save and close document with default date calculation, modify to 1904-01-01 calculation with an other document and reopen again. That all seems worrying to mee, I will terminate for today and think about that tomorrow. Opening YOUR "dates-ohallot.ods" with my "Reproducible with "Ooo-Dev 3.3.0 multilingual version English UI WIN XP: [OOo330m1 (Build 9514)]", with default calculation, I see in rows 6 -7 "14/01/00", "15/01/01". Due your screenshots the rechaneg from "14/..." to "15/..." is from rwo 19 to row 20. Hi Rainer No I don't use (never used), anything other than the default for dates. The file dates-ohallot.ods just above was created by selecting dates-rainerbielefeld.ods first spreadsheet and copying & pasting into dates-ohallot.ods first spreadsheet. So, I did not paid enough attention to this: When pasting data into the new spreadsheet, it looks like that the value inserted into the cell is actually the value displayed. Since "VERDADEIRO" means "TRUE", the results inclumn C means that column B does not match function DATE(YYYY;MM;DD), because DD=16. But now please find attached the spreadsheet with manual input data and dates, and with the default setting, and images I have here. Data in column A was input manually. Data in column B was typed manually as 16/01/<YEAR>, (1900,1901,1902,...) Column C shows that dates in column B are equal with the results of the function DATE(YYYY;MM;DD). Looks like the serial number for the date is OK. Column D has this incredible result... =A2 with special formatting... Created attachment 71244 [details]
spreadsheet with date formatting issue from scratch
I beg your pardon, column D is nothing, I was refering column H which is correct (my mistake) > Column D [H] has this incredible result... =A2 with special formatting...
@ohallot: Can you explain what is unexpected about the results in column H?
Here's what I see when I open your last attachment (ohallot-new-from-scratch.ods):
[A] [H]
Simple No. Date informaiton of column A
1900 14. Mar. 1905
1901 15. Mar. 1905
1902 16. Mar. 1905
1903 17. Mar. 1905
1904 18. Mar. 1905
which looks correct to me: 1905-03-14 is serial number 1900 when 1899-12-30 is
the base date.
@jes: yes. My mistake. As seen on Olivier's machine this is timezone related, we'll just have to figure out which, probably Sao Paulo. Reset assigne to the default "issues@openoffice.apache.org". |