Skip to content

You are not logged in. Register orLog In

start:

OpenOffice.org - Testcase specification

Testname: New function: getpivotdata

Document Owner:

Oliver Craemer

Last document change:

21.11.2007

Status of document:

Standard

Valid for version: 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

Test purpose:

This test verifies the function getpivotdata with all parameters including im/export to XLS

Known issues:

Preconditions of test:

As functionnames are localedependant the testcases in these TCS describes the english version only.

Test documents:

http://www.openoffice.org/nonav/issues/showattachment.cgi/46178/datapilot.ods
http://www.openoffice.org/nonav/issues/showattachment.cgi/34486/getpivotdata2.xls

Testcases:

Function wizardStatus: Standard
Load testdocument datapilot.ods
Select cell I8 and open function wizard by INSERT FUNCTION
Select category SPREADSHEET
Verify that the function GETPIVOTDATA is visible in the now filtered function list
Select function GETPIVOTDATA
Press NEXT button
Enter "SUM - 2000" for parameter Data Field
Enter C29 for parameter DataPilot
Enter C3 for parameter Field Name / Item 1
Enter C16 for parameter Field Name / Item 2
Enter C26 for parameter Field Name / Item 3
Enter F27 for parameter Field Name / Item 4
Press OK
Verify that the function result is 100000
Save document locally
Close document
Load locally saved  document
Verify that cell I8 still shows 100000
Verify that the function in cell I8 is still =GETPIVOTDATA("SUM - 2000";C29;C3;C16;C26;F27)
Close document
XLS Import/Export of GETPIVOTDATAStatus: Standard
Load testdocument getpivotdata2.xls
Select cell G12
Verify that Cell G12 shows 2.5
Verify that the function is =GETPIVOTDATA("val";$F$5;"col1";"a";"col2";"x")
Select cell G27
Verify that Cell G27 shows 0.05
Verify that the function is =GETPIVOTDATA("val";$F$19;"col1";"a";"col2";"y")
Select cell G43
Verify that Cell G43 shows 3
Verify that the function is =GETPIVOTDATA("val";$F$33;"col1";"a";"col2";"z";"col3";"p"))
Save document back to xls
Close document
Load Document
Select cell G12
Verify that Cell G12 shows 2.5
Verify that the function is =GETPIVOTDATA("val";$F$5;"col1";"a";"col2";"x")
Select cell G27
Verify that Cell G27 shows 0.05
Verify that the function is =GETPIVOTDATA("val";$F$19;"col1";"a";"col2";"y")
Select cell G43
Verify that Cell G43 shows 3
Verify that the function is =GETPIVOTDATA("val";$F$33;"col1";"a";"col2";"z";"col3";"p"))
Close document

References:

-

Acronyms:

-

testcase specification history

New function: getpivotdata

DateChangeUser
21.11.2007 (15:29:42)status updatedFrank Stecher
21.11.2007 (15:29:34)testcase :XLS Import/Export of GETPIVOTDATA updatedFrank Stecher
21.11.2007 (15:29:06)status updatedFrank Stecher
21.11.2007 (15:28:58)testcase :Function wizard updatedFrank Stecher
22.06.2007 (12:10:42)status updatedOliver Craemer
22.06.2007 (12:10:25)status updatedOliver Craemer
22.06.2007 (12:10:11)testcase details updatedOliver Craemer
22.06.2007 (12:09:10)header updatedOliver Craemer
22.06.2007Testcase specification createdOliver Craemer


13.11.09 12:11:08