[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 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 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 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 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
[www-issues] Get best deals on meds at discount chemist.
The store offers customers more meds online now and customers have wider selection online. If you need quality meds, check online for meds on pain relief, sexual health, anxiety relief, depression relief, men's health, cholesterol control and other categories. It is the new trend to shop online. Customers order quality meds with express shipping and bonus Rx. Get more discount at our Internet pharmacy. Enjoy 20% more discount for all reorders. People like to use the local pharmacy for rx refill. For me internet rx refill is much, much easier. And I don't even need to step out of my house for a rx refill now.--Easy Guy http://vifu.U6H.extawarm.com/w9g/ IAqV75wHg8g0 Ox3mjLA2 Sc0v W5tIE XxM AnFa56N Hwou Fo 9 WELafI1et IhYh 1 GXMt3R6XXltX YLya4 Kg7 TiX - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
