[sc-issues] [Issue 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 User cornouws changed the following: What|Old value |New value CC|'elianedomingos,ohallot,ra|'cornouws,elianedomingos,o |inerbielefeld'|hallot,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 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 --- Additional comments from rainerbielef...@openoffice.org Fri Aug 20 18:15:37 + 2010 --- *** Issue 114020 has been marked as a duplicate of this issue. *** - 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 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 User ohallot changed the following: What|Old value |New value CC|'rainerbielefeld' |'elianedomingos,ohallot,ra | |inerbielefeld' --- Additional comments from ohal...@openoffice.org Fri Aug 20 20:08:56 + 2010 --- add cc - 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 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 --- Additional comments from li...@openoffice.org Sun Aug 1 16:38:43 + 2010 --- @er: We both have time zone set to (UTC+02:00) Helsinki, Kiev, Riika, Tallinna, Sofia, Vilna and both have automatic daylight saving time change set to on. @all: If it still helps you on debugging this, she can record a macro showing the whole case; how the data is input into spreadsheet cells and how the date goes wrong while changing the formatting of the cells etc. Would this kind of macro be helpful? - 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 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 --- Additional comments from rainerbielef...@openoffice.org Sun Aug 1 21:39:09 + 2010 --- @lisko: We can try the macro, but I believe the best way would be that you try to make the problem reproducible on your own PC. If you can't find the reason, I doubt that we will find it. - 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 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 --- Additional comments from e...@openoffice.org Mon Jul 19 12:17:38 + 2010 --- @lisko: It may be that her computer has the timezone set to somewhere in Finland, and your computer has it set to somewhere else. Can you confirm this assumption? - 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 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 --- Additional comments from li...@openoffice.org Sat Jul 17 08:57:36 + 2010 --- Ok, let's forget this problem. That document was created on the problematic PC by manually writing the dates to the spreadsheet. By I cannot reproduce the problem I mean that when I open the document on my PC, all dates are fine and as they should be. I read those previous problems you linked now and seems that they are related. Sorry about taking your time, I just thought that I could help to solve the possible issue but obviously it seems that I am not capable of that. Or capable of understanding your guidelines. I'll try to learn before I bother you or other free SW developers again. - 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 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 --- Additional comments from li...@openoffice.org Fri Jul 16 17:20:48 + 2010 --- Created an attachment (id=70661) 18st century date problem - 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 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 --- Additional comments from li...@openoffice.org Fri Jul 16 17:26:51 + 2010 --- Hi, sorry about my misunderstanding here. I had no intention to waste anyone's time and document does not contain any confidential information as the problem can be reproduced in her PC simply by adding the dates manually... Now I have the example as .ods file. Unfortunately I cannot reproduce this problem on my own PC, so this seems to be somehow related to that particular Acer laptop of my mother-in-law. So, the attached document id: 70661 contains the sample data formatted as text (column A), as date in format dd.mm.yy (column), as date in format dd.mm. (column E) and both dates as number (B and F). I see everything fine, but she has both date column values --'d, so dates go one day backwards. - 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 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 --- Additional comments from rainerbielef...@openoffice.org Fri Jul 16 18:21:23 + 2010 --- I believe we should close this issue, I do not have any hope that we will get some useful bug information anytimes, and it seems that it's a problem with that particular PC. @lisko Any idea what information should be gathered with a sample document without any problem (or do I misunderstand your I can not reproduce?). You even did not mention whether that document has been created on the PC with the OOo where the problem is visible. We are still waiting for your results from reading issue 86094 and issue 102294, or issue 105864. My final attempt: Please read our guidelines on http://qa.openoffice.org/issue_handling/pre_submission.html and http://www.openoffice.org/bugs/bug_writing_guidelines.html before you file further issues or post again here.Then please contribute a clear and simple step by step instruction containing all observations (error messages ...), EVERY key press and EVERY mouse click how to reproduce the problem, and explain why you believe that your results are unexpected. That means (for example): do not write something like I am not able to ... or change the format to be dates, but 6. left mouse click on … expected: …, color of … changes, … actual: no …., color remains white, no … Screenshots might help to explain the problem. Please - always specify your OOo download source, version, localization, OS and Platform you used for your tests! - attach a sample document SHOWING A PROBLEM with screensots (might be that shown values will be different on a different PC). I believe it would be useful to attach a sample document showing the problem in one row with the possibility to reproduce the problem with your step by step instrucition in a secone row (all formatting prepared for the test). - contribute complete information to your language settings in OOo and WIN! - explain she has both date column values --'d - 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 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 --- Additional comments from li...@openoffice.org Wed Jul 14 16:07:24 + 2010 --- Hi, the same problem is visible in 3.2.1 Finnish version and with Finland/Helsinki date settting. @rainerbielefeld: Here is the result of your latest testing request: When the dates you sent below are written to cells, everything goes fine since Calc assumes 90 to mean year 1990 (Column A is text, column B is function =int(a2) – int(a12) and column C is date in format dd.mm.yy): AB C 23.07.90 33077 23.07.90 24.07.90 33078 24.07.90 25.07.90 33079 25.07.90 26.07.90 33080 26.07.90 27.07.90 33081 27.07.90 28.07.90 33082 28.07.90 29.07.90 33083 29.07.90 30.07.90 33084 30.07.90 31.07.90 33085 31.07.90 01.08.90 33086 01.08.90 02.08.90 33087 02.08.90 But when changed the year to 1790, the familiar issue is back (column A is text, column B is date in format dd.mm.yy and column C is =int(B)): A BC 23.07.1790 22.07.90 -39971 24.07.1790 23.07.90 -39970 25.07.1790 24.07.90 -39969 26.07.1790 25.07.90 -39968 27.07.1790 26.07.90 -39967 28.07.1790 28.07.90 -39966 29.07.1790 29.07.90 -39965 30.07.1790 30.07.90 -39964 31.07.1790 31.07.90 -39963 01.08.1790 01.08.90 -39962 02.07.1790 01.07.90 -39992 So something is definetely wrong in July 1790. But is it OO or the PC, that's the problem. Now every date seems to be --'d when 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 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 --- Additional comments from rainerbielef...@openoffice.org Wed Jul 14 16:38:24 + 2010 --- It seems to be difficult to apart between posted results and a sample document? We need a sample document attached here! If you contribute instructions how to reproduce the bug, please contribute a step by step instruction containing every mouse click and every key press! Every thing else only wasts my and your 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
[sc-issues] [Issue 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 --- Additional comments from rainerbielef...@openoffice.org Wed Jul 14 16:57:27 + 2010 --- This one might have same roots like Issue 102810 (only a vague suspect) - 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 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 --- Additional comments from li...@openoffice.org Tue Jul 13 17:42:42 + 2010 --- Hi all! If you really need, I can attach the source, but it does not really matter - the same problem occurs also if the dates are written to cells manually or for example copy-pasted from notepad. She actually located the problematic date to be 26-Jul-1790 by writing the dates manually to calc cells. I'll ask her to check the date settings as well as to update to the latest finnish version. - 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 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 --- Additional comments from rainerbielef...@openoffice.org Tue Jul 13 18:26:57 + 2010 --- @lisko Please attach a (new document) sample with 3 columns like following example: Date Date in integer Number FormatDate as written text in text formatting 23.07.90-3997123.07.90 24.07.90-3997024.07.90 25.07.90-3996925.07.90 26.07.90-3996826.07.90 27.07.90-3996727.07.90 28.07.90-3996628.07.90 29.07.90-3996529.07.90 30.07.90-3996430.07.90 31.07.90-3996331.07.90 01.08.90-3996201.08.90 02.08.90-3996102.08.90 - 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 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 User rainerbielefeld changed the following: What|Old value |New value CC|''|'rainerbielefeld' Keywords| |needmoreinfo, oooqa --- Additional comments from rainerbielef...@openoffice.org Sun Jul 11 08:57:53 + 2010 --- @lisko: Please attach that some other source! If it contains confidential you can send it tom be by E-Mail. Or may be you can create a small sample document demonstration your problem? You know about date settings in 'Tools - Options - OOo CALC - Calculate?' Do modifications here solve your problem? - 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 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 --- Additional comments from e...@openoffice.org Fri Jul 9 15:58:14 + 2010 --- @lisko: May be related to issue 86094 and issue 102294, or issue 105864. Please check with the latest release available. If the error still occurs please state your time zone setting, that probably is Finland/Helsinki. - 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 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 Issue #|113028 Summary|Date bug Component|Spreadsheet Version|OOo 3.1 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|formatting Assigned to|spreadsheet Reported by|lisko --- Additional comments from li...@openoffice.org Thu Jul 8 06:55:01 + 2010 --- Hi! My mother-in-law does a research in her family roots. She found this bug from OpenOffice Spreadsheet / Calc application while feeding in 18st century dates from some other source. This is the data she put in, the first two sections are dates in Finnish format and others are birthplaces and person names: 03.12.1755 15.12.1755 Saresmäki Isaac Pussinen Anna KerätärCarin 07.09.1758 18.09.1758 Saresmäki Isaac Pussinen Anna KerätärIsaac 12.04.1760 19.04.1760 Saaresmäk Isaac Pussinen Anna KerätärAndreas 24.05.1763 20.06.1763 Saaresm.J. 53 No 6 Sivola Isaac Pussinen Ann. KerätärAnna 27.03.1764 18.06.1764 Saaresm.J. 53 No 6 Sivola Isaac Pussinen Ann Kerätär Christina (nd.) 21.03.1766 11.04.1766 Saresm. J. 53 No 6 Sivola Isaac Pussinen Anna KerätärAnna 19.04.1773 01.07.1773 Saresmäki Isaac Pustinen Anna KerätärSara (conf.) So everything is fine as long as the cells are not formatted. But when she changed the format of the first columns to be dates, all those dates were changed - 1 day, for example teh dates in first row changed to be 02.12.1755 and 14.12.1755. No matter if this same data is copy-pasted or hand-written, the same thing happens. She studied this a bit and discovered that the prolem is in dates 25.07.1790 and 26.07.1790. These both have same values: datevalue() 23.07.1790 -39970 24.07.1790 -39969 25.07.1790 -39968 25.07.1790 -39968 (input 26.7.1790 into the cell manually) 26.07.1790 -39967 (input 27.7.1790 into the cell manually) 28.07.1790 -39966 29.07.1790 -39965 Seems that it is impossible to write 26.07.1790 as it is being changed to 25.07.1790 and all dates since that are wrong. She did not find out if this problem vanishes after some other year. I'm not really sure about the exact version she has, it is 3.1 something with Finnish language pack. It was the latest version that was available in May 2010 when we installed it to her new laptop. BR, Hannu - 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 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 User mla changed the following: What|Old value |New value Priority|P1|P2 --- Additional comments from m...@openoffice.org Thu Jul 8 07:45:53 + 2010 --- In the meantime there should be the new version 3.2.1 available also for Finnish, download from here. http://download.openoffice.org/other.html;, so please install this and test again BTW: This is not a P1 issue. - 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 113028] Date bug
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 --- Additional comments from j...@openoffice.org Thu Jul 8 15:58:02 + 2010 --- I've tried the example with 1790 but I was not able to reproduce this in current DEV300_m84 developer build (on Solaris x86). Maybe it's worth to check the basis date entries in /tools/options/calc/calculate if they use the default of 12/30/1899. Perhaps this document is an import of an old Excel document containing one of the old known Excel date bugs... - 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