Testname: Excel Pivotcache Import

Document Owner:

Frank Stecher

Last document change:

08.11.2006

Status of document:

Standard

Valid for version: StarOffice8 PP6

Test purpose:

test the Import of Datapilots in Excel documents based on external files

Known issues:

Preconditions of test:

Test documents:

target_Datapilot.xls

Testcases:

Excel Pivotcache Import	Status: Standard	-
Download and open the bugdoc. A Sheet with the name DPCache_* must exist there * is the Sheet name of the underlying external Excelfile. Place the cell cursor on the first sheet on cell C12, open the context menu and select refresh. This should make the typical datapilot fields visible. Place the cell cursor to B31 and select refresh from the context menu. Open the context menu and select Start. The Datapilot wizard should come up. Close the wizard. Save the file to a new name as Excelfile Close and reload it. The datapilots must be functional again. Save the file to ODS format and reload it after closing. The functionaklity of the datapilot must be given.