Document Owner:

Frank Stecher

Last document change:

19.11.2007

Status of document:

Standard

Valid for version: OpenOffice.org_2.2, OpenOffice.org_2.2.1, OpenOffice.org_2.3, OpenOffice.org_2.3.1, OpenOffice.org_2.4, OpenOffice.org_3.0, OpenOffice.org_3.1, OO, OpenOffice.org_3.2

• Open the test document target_Datapilot.xls
  
• A Sheet with the name DPCache must exist there
  
• It is the sheet name of the underlying external Excel file
• Place the cell cursor on the first sheet on cell C12
• Open the context menu
  
• Select refresh in the menu
  
• This should make datapilot fields visible.
• Place the cell cursor to B31
  
• Select refresh from the context menu
• Open the context menu
  
• Select Start
  
• The datapilot wizard should come up.
  
• Close the wizard
• Save the file to a new name as Excel file
  
• Close and reload it.
  
• The datapilots must be functional (open Context menu with cell cursor placed in the datapilot boundaries and check for the menu opotions Refresh and Start)
  
• Save the same file to OpenDocument Format (*.ods)
  
• Close it
  
• Reload it
• The datapilots must be functional (open Context menu with cell cursor placed in the datapilot boundaries and check for the menu opotions Refresh and Start)