To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93495 Issue #|93495 Summary|DataPilot is disturbed by user defined number format Component|Spreadsheet Version|OOO300m2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|sweigel
------- Additional comments from [EMAIL PROTECTED] Thu Sep 4 19:06:27 +0000 2008 ------- Data pilot screws up data, when some user defined number format is used for displaying dates. For example see the attached spreadsheet: Test Case A (left) is fine. The DataPilot is basing upon a list of dates and values. The cells, that contain the dates, have been set to the number format: MMM D, YYY Test Case B (right) shows the defect. The only difference in the list is, that the cells, that contain the dates, have been set to the user defined number format: DDD, MM D The categories of the DataPilot´s result on the right (B) are no longer dates, but text. The data type has been changed from date to text. The big problem becomes obvious, when you try to group the DataPilots by date: (1) Select cell A22 (2) Press F12 (3) You are able to group by date (days, months, quarters, years, ...) (1) Select cell D22 (2) Press F12 (3) You are *not* able to group by date, because there are no dates but texts. --------------------------------------------------------------------- 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]
