To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115752 Issue #|115752 Summary|Data pilot doesn't recognize alternative data format Component|Spreadsheet Version|OOo 3.2 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|thereallifeboy
------- Additional comments from [email protected] Tue Nov 23 20:51:34 +0000 2010 ------- When using data pilot and then grouping date columns, calc doesn't recognize the date format 'dd-mm-yyyy'. Pressing <F12> does not pop up a dialog to allow a user to select grouping and doesn't group either. How to reproduce: Format data in rows that contain dates in the above format. Create a data pilot view of the data. Select a date field in the data pilot view. Press <F12>. Nothing happens. Now change the data format to 'yyyy/mm/dd' in the original sheet. Refresh the data pilot view. Press <F12> on the date field. The dialog now appears as it is supposed to do. Note: Once the grouping has been done, the data format can be changed back to 'dd-mmm-yyyy' and the data pilot table still works correctly. So it seems that it is only the initial creation of a grouping dialog that is affected by this. --------------------------------------------------------------------- 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]
