To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84228 Issue #|84228 Summary|error in formulas on weekday Component|Spreadsheet Version|OOo 2.3 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|blueskin
------- Additional comments from [EMAIL PROTECTED] Tue Dec 4 13:54:57 +0000 2007 ------- This problem can be reproduced as follows: 1. Format 7 cells in the format NNN i.e. day of the week. 2. Type Monday into the first cell, (lets say A1). 3. I the second cell, (lets say A2) type type =A1+1. 4. Sunday is dispaled in Cell A2. 5. Fill down A2 to A7 6. Cell A3 to A7 display, Sunday, Monday, Tuesday, Wednesday. Thursday, Friday. 7. Cells A3 to A7 have the same formula as A2 but they add days correctly. 8. Strange indeed! --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
