Testname: Clipboardtest

Document Owner:

Frank Stecher

Last document change:

10.10.2006

Status of document:

Standard

Valid for version: StarOffice8, StarOffice8 PP1, StarOffice8 PP2, StarOffice8 PP3, StarOffice8 PP4

Test purpose:

Test the clipboard functionality in it's entirety


Known issues:


Preconditions of test:


Test documents:

-


Testcases:

Clipboardtest

Status: Standard

-

Create a new Calc document with some data. It should have all kind of possible formats. Strings, Dates, Times, Numbers. Copy at least one cell into the clipboard

All the following has to be done after a paste operation:

Check that there is a messagebox which warns for overwiting if you paste to a cell which contain data.
Check that the overwriting warning could be turned off in the dialog and that this could be un-done in TOOLS-OPTIONS-SPREADSHEET-GENERAL
Check that the numberformat of a cell can be copied
Check that the Font attributes of a cell can be copied
Check that the Alignment settings of a cell can be copied
Check that the Border attributes of a cell can be copied
Check that the Background attributes of a cell can be copied
Check that the Cell protection attributes of a cell can be copied
Check that the clipboard can be used in the Edit mode of a cell
Check that the clipboard can be used to copy between Edit mode and Sheet
Check that the clipboard can be used to copy between Sheet and Edit mode
Check that the clipboard can be used with drawing objects
Check that the clipboard can be used to copy Pixel graphics (Bitmap, *.BMP)
Check that the clipboard can be used to copy Vector graphics (Metafile, *.WMF)

Edit / Paste Special

Status: Standard

-

Create a data range with Strings, Numbers, Dates, Times, Formulas (e.g. =A1-B1), Notes and Formats
Copy this Range to the Clipboard
Paste Special 'Paste All': Correct content ?
Paste Special 'Strings': Correct content ?
Paste Special 'Numbers': Correct content ?
Paste Special 'Date': Correct content ?
Paste Special 'Time': Correct content ?
Paste Special 'Formulas': Correct content ?
Paste Special 'Notes': Correct content ?
Paste Special 'Formats': Correct content ?
Paste Special 'Objects': Correct content ?

Calculation Operations

Status: Standard

-

Create a Range with Numbers (10Columns. x 8 Rows)
place another range with numbers into the clipboard (3Columns. x 2 Rows)
Select the first range and choose Edit / Paste Special / Operations :
-None
-Add
-Subtract
-Multiply
-Divide

After every Paste Special you have to check the results !!!

Skip empty cells

Status: Standard

-

Copy a range of Cells containing numbers and empty cells into the clipboard.
Paste Special into a range which is filled with characters with 'Skip empty cells' tagged. ( For comprehension : With this feature it's possible to place contents as mask over existing cells.)
Check that the characters are still present at the places there the empty cell in the pasted area are.

Transpose

Status: Standard

-

(after each step check the results !!!)
Create two ranges containing Numbers, copy one of them into the Clipboard.
Do a Paste Special on the second Number range and tag the transpose Option, select also an Operation.
Also check that relative and absolute references are treated in the correct way.

Insert as Link

Status: Standard

-

Open an existing Calcdocument and select a range. Copy it to the clipboard.
Open a new Calc document.
Select Paste Special from the Edit or the context menu.
Tag the Link Checkbox and click Ok.
Save the new document and reopen it for checking the correct function of the Link.

Insert with Shifting Cell's

Status: Standard

-

if a cell range contains data are the cells shifted in the correct way after selecting Shift down or Shift right ?
What about relative and absolute cell references, are they working in the correct way ?
Is UNDO / REDO working properly ?

Insert into a range

Status: Standard

-

Do you get an Messagebox if the range you have selected to paste the clipboard to is smaller than the one you have placed in the clipboard ?

Paste Special with Content from other Applications

Status: Standard

-

(you get a different dialog)
Check it with HTML, RTF, SYLK, DIF, unformatted Text, OLE

Biff5 (Excel5/95 Sheet contents that are going through the filters) and check DDE
Place some data from MS Access or Excel5 into the clipboard.
Paste the clipboard via Paste Special into Calc. Compare source and destination.

RTF - Export
Format a cell range with all possible attributes (each cell a different attribute). Copy this range into the clipboard and paste it into a writer document as RTF using Edit – Paste Special.

The following must be converted:
The cell content including the Numberformat.
Font Attributes bold / italic / underline if they are used for the whole cell.
Horizontal alignment of the cell content left / right / center / justified.
Vertical alignment of the cell content top / center / bottom.
Horizontal merged cells (vertical is not possible in RTF!).
Column width and Row height

Paste unformatted but structured text :

Open a writer document and type a line of  five single characters each separated by a TAB Stop. Press Return and do the same with 5 numbers.
Select these rows and copy them to the clipboard.
Change to Calc and Paste Special Unformatted Text.
The Text-CSV Import dialog should open. Select TAB as delimiter and press Ok. You should get a structured range containing the data in separate cells.
Do the same for comma and semicolon separated ranges

Place some strings and numbers in more than one row in a writer document, copy these lines to the clipboard and Paste Special unformatted text.
The Text-CSV Import dialog should open. Press Ok. You should get a structured range containing the data in separate cells, one per row.