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.