Testname: Autosums

Document Owner:

Frank Stecher

Last document change:

20.06.2007

Status of document:

Preliminary

Valid for version: StarOffice8 PP8

Test purpose:

test the functionality of autosummation within the Spreadsheet application.

Known issues:

Preconditions of test:

Test documents:

autosum.ods

Testcases:

Sum on range and Sum on Sum's

Status: Preliminary

-

  • Download and open the testdocument

  • Place the cell cursor on the gray cells located under Point 1. (Multiselection is not possible at this place) and press the Sum Icon in the formula bar. Now hit the enter key and the result should be shown. Do so for each gray cell in this part of the document.

  • Compare the formula entered with the one found next to each summation field

  • Compare the formula result for all gray cells with the values found in the 'Should be' Column

  • All findings correct ? No ? File an Issue.

Sum on Row and Column

Status: Preliminary

-

  • Download and open the testdocument

  • Place the cell cursor on the gray cells located under Point 2. (Multiselection is not possible at this place) and press the Sum Icon in the formula bar. Now hit the enter key and the result should be shown. Do so for each gray cell in this part of the document.

  • Compare the formula entered with the one found next to each summation field

  • Compare the formula result for all gray cells with the values found in the 'Should be' Column

  • All findings correct ? No ? File an Issue.

Subtotals on Autosum

Status: Preliminary

-

  • Download and open the testdocument

  • Place the cell cursor on the gray cell located under Point 3. and press the Sum Icon in the formula bar. Now hit the enter key and the result should be shown.

  • Compare the formula entered with the one found next to the summation field

  • Compare the formula result with the one found in the 'Should be' Column

  • All findings correct ? No ? File an Issue.

Autosum on column with selected empty cell for result

Status: Preliminary

-

  • Download and open the testdocument

  • Select the gray cells located under Point 4. and press the Sum Icon in the formula bar. 

  • Compare the formula entered with the one found next to the summation field

  • Compare the formula result with the value found in the 'Should be' Column

  • All findings correct ? No ? File an Issue.

Autosum on rows with selected empty cell for result

Status: Preliminary

-

  • Download and open the testdocument

  • Select the gray cells located under Point 5. and press the Sum Icon in the formula bar.

  • Compare the formulas entered with the ones found next to the summation fields

  • Compare the formula results with the values found in the 'Should be' Column

  • All findings correct ? No ? File an Issue.

Subtotal on column with selected empty cell for result

Status: Preliminary

-

  • Download and open the testdocument

  • Select the gray cells located under Point 6. and press the Sum Icon in the formula bar.

  • Compare the formula entered with the one found next to the summation field

  • Compare the formula result with the value found in the 'Should be' Column

  • All findings correct ? No ? File an Issue.

Autosum on column without selected empty cell for result

Status: Preliminary

-

  • Download and open the testdocument

  • Select the gray cells located under Point 7. and press the Sum Icon in the formula bar.

  • Compare the formula entered with the one found next to the summation field

  • Compare the formula result with the value found in the 'Should be' Column

  • All findings correct ? No ? File an Issue.

Autosum on rows without selected empty cell for result

Status: Preliminary

-

  • Download and open the testdocument

  • Select the gray cells located under Point 8. (you may use Multiselection with the CTRL key) and press the Sum Icon in the formula bar.

  • Compare the formulas entered with the ones found next to the summation fields

  • Compare the formula results with the values found in the 'Should be' Column

  • All findings correct ? No ? File an Issue.

Subtotal on column without selected empty cell for result

Status: Preliminary

-

  • Download and open the testdocument

  • Select the gray cells located under Point 9. and press the Sum Icon in the formula bar.

  • Compare the formula entered with the one found next to the summation field

  • Compare the formula result with the value found in the 'Should be' Column

  • All findings correct ? No ? File an Issue.

Autosum on multiselected columns without selected empty cell for result

Status: Preliminary

-

  • Download and open the testdocument

  • Select the gray cells located under Point 10. and press the Sum Icon in the formula bar.

  • Compare the formulas entered with the ones found next to the summation fields (a '/' is used as a delimiter to show that this is for the first second or third column)

  • Compare the formula results with the values found in the 'Should be' Column

  • All findings correct ? No ? File an Issue.

Autosum on columns with formula results without selected empty cell for result

Status: Preliminary

-

  • Download and open the testdocument

  • Select the gray cells located under Point 11. and press the Sum Icon in the formula bar.

  • Compare the formulas entered with the ones found next to the summation fields (a '/' is used as a delimiter to show that this is for the first second or third column)

  • Compare the formula results with the values found in the 'Should be' Column

  • All findings correct ? No ? File an Issue.

Autosum on column with filled cell under selected area

Status: Preliminary

-

  • Download and open the testdocument

  • Select the gray cells located under Point 12. and press the Sum Icon in the formula bar.

  • Compare the formulas entered with the ones found next to the summation fields (a '/' is used as a delimiter to show that this is for the first second or third column)

  • Compare the formula results with the values found in the 'Should be' Column

  • All findings correct ? No ? File an Issue.

Autosum on column and rows with empty cells selected for row and column

Status: Preliminary

-

  • Download and open the testdocument

  • Select the gray cells located under Point 13. and press the Sum Icon in the formula bar.

  • Compare the formulas entered with the ones found next to the summation fields (a '/' is used as a delimiter to show that this is for the first second or third column)

  • Compare the formula results with the values found in the 'Should be' Column

  • All findings correct ? No ? File an Issue.