| ||||
Valid for version: StarOffice8 PP8 |
Function wizard | Status: 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 GETPIVOTDATA | Status: 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 |
|