To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107626
------- Additional comments from [email protected] Sat Dec 12 14:56:08 +0000 2009 ------- As far as I can see, it's not conditional formatting, or the DAY function, causing the wrong day to be displayed, it's your cell format. E.g. I4: you're applying a custom number format of "D" to the result of DAY(2009-12-28), which is 28. Serial date 28 is 1900-01-27 and the day ("D") of that date is 27, so your cell format displays the 28 from DAY() as 27. Changing the number format in style "Grayed" to Number/General gives correct day numbers in the grayed cells. You can discuss problems like this on the users mailing list or the community forum: http://www.openoffice.org/mail_list.html [email protected] http://user.services.openoffice.org --------------------------------------------------------------------- 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]
