Valid for version: StarOffice8, StarOffice8 PP1, StarOffice8 PP2,
StarOffice8 PP3, StarOffice8 PP4
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.
|