[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 User er changed the following: What|Old value |New value Assigned to|spreadsheet |er Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from e...@openoffice.org Thu Sep 2 17:10:51 + 2010 --- As seen on Olivier's machine this is timezone related, we'll just have to figure out which, probably Sao Paulo. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 User gbpacheco changed the following: What|Old value |New value CC|'cornouws,elianedomingos,r|'cornouws,elianedomingos,g |ainerbielefeld' |bpacheco,rainerbielefeld' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 User cornouws changed the following: What|Old value |New value CC|'elianedomingos,rainerbiel|'cornouws,elianedomingos,r |efeld'|ainerbielefeld' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 --- Additional comments from j...@openoffice.org Mon Aug 23 14:50:56 + 2010 --- 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. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 --- Additional comments from ohal...@openoffice.org Tue Aug 24 02:48:41 + 2010 --- @jes: yes. My mistake. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 --- Additional comments from rainerbielef...@openoffice.org Sat Aug 21 08:18:34 + 2010 --- @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! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 --- Additional comments from rainerbielef...@openoffice.org Sat Aug 21 08:19:47 + 2010 --- Created an attachment (id=71236) Please see comments from rainerbielefeld Sat Aug 21 08:18:34 + 2010 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 --- Additional comments from ohal...@openoffice.org Sat Aug 21 15:34:01 + 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). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 --- Additional comments from ohal...@openoffice.org Sat Aug 21 15:35:22 + 2010 --- Created an attachment (id=71241) dates-ohallot - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 --- Additional comments from rainerbielef...@openoffice.org Sat Aug 21 18:07:23 + 2010 --- @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. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 --- Additional comments from ohal...@openoffice.org Sun Aug 22 01:37:29 + 2010 --- 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(;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(;MM;DD). Looks like the serial number for the date is OK. Column D has this incredible result... =A2 with special formatting... - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 --- Additional comments from ohal...@openoffice.org Sun Aug 22 01:38:56 + 2010 --- Created an attachment (id=71244) spreadsheet with date formatting issue from scratch - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 --- Additional comments from ohal...@openoffice.org Sun Aug 22 01:42:23 + 2010 --- I beg your pardon, column D is nothing, I was refering column H which is correct (my mistake) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 --- Additional comments from ohal...@openoffice.org Fri Aug 20 16:32:45 + 2010 --- Created an attachment (id=71223) sample with wrong date display - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 Issue #|114020 Summary|wrong date calculation/display Component|Spreadsheet Version|OOO330m1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|code Assigned to|spreadsheet Reported by|ohallot --- Additional comments from ohal...@openoffice.org Fri Aug 20 16:31:56 + 2010 --- The following sample shows a bug in the date display Cell A1 has formula =DATE(1907;02;24) and displays 23/2/1907 in mm-dd-aa notation, or any other one. If you type 24/2/1907 the display is 23/2/1907. Again, this is wrong. Other dates less far from now are ok... see 2007 and 1958... - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 User rainerbielefeld changed the following: What|Old value |New value CC|''|'rainerbielefeld' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 User rainerbielefeld changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Keywords| |oooqa Priority|P1|P3 Resolution| |DUPLICATE --- Additional comments from rainerbielef...@openoffice.org Fri Aug 20 18:15:37 + 2010 --- 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 *** - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 User ohallot changed the following: What|Old value |New value CC|'rainerbielefeld' |'elianedomingos,rainerbiel | |efeld' --- Additional comments from ohal...@openoffice.org Fri Aug 20 20:19:05 + 2010 --- 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 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 --- Additional comments from ohal...@openoffice.org Fri Aug 20 20:19:53 + 2010 --- Created an attachment (id=71225) image of the display we get here - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 --- Additional comments from ohal...@openoffice.org Fri Aug 20 20:22:04 + 2010 --- Created an attachment (id=71226) calc file with issue hilighted - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 114020] wrong date calculation/di splay
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020 User ohallot changed the following: What|Old value |New value Status|RESOLVED |UNCONFIRMED Resolution|DUPLICATE | --- Additional comments from ohal...@openoffice.org Fri Aug 20 20:26:17 + 2010 --- Reopening wit simpler samples of the bug. Not sure the issue of the timezone are to be considered. We are not measuring time... - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
