To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94695 Issue #|94695 Summary|Filter on date unintentionally use time values Component|Spreadsheet Version|DEV300m32 Platform|Unknown URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|PATCH Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|kohei
------- Additional comments from [EMAIL PROTECTED] Mon Oct 6 15:32:16 +0000 2008 ------- When filtering rows based on date values, the selection list displays duplicate entries of identical dates & the filtering result is not what the users would expect when the data values include time elements. This is because Calc internally evaluates numerical values of dates, which also include time. So, if the time element is not zero, it can create multiple entries of the same date & the filtering result may not filter out entries that should be filtered out. My proposed fix is to strip out the time element from each entry when the number format type is of date type. --------------------------------------------------------------------- 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]