To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107626 Issue #|107626 Summary|The DAY() function fails under conditional formatting Component|Spreadsheet Version|OOO310m19 Platform|Macintosh URL| OS/Version|Mac OS X, 10.5 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|daninilnw
------- Additional comments from [email protected] Fri Dec 11 21:49:16 +0000 2009 ------- Making a calendar. Columns A-G have incremental dates formatted in custom format DD/MM/YY. using the formula e.g. B4 = A4+1, where A=28/12/09. columns I to O use the DAY() formula to display the day of the month. I want the days of the previous month to be grayed, so I use conditional formatting on the first row to apply a grayed backgound if the value of the call is less than 15. When I do this, the DAY() function subtracts 1 from the value. So if cell A4 = 28/12/09 then cell I4 is at first 28. But after conditional formatting it is 27. This is very strange. However, it does nothing to the cells for which the conditional formatting is false. --------------------------------------------------------------------- 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]
