OpenOffice.org - Testcase specifications


Name	Test purpose	Status	No. of testcases	Owner

Collaboration and User rights	Verify that the collaboration feature works with different User rights as designed	Preliminary	2	Thomas Klarhoefer

Sheetnames	Verify that all characters in sheetnames are allowed	Standard	1	Oliver Craemer

ODF 1.2	Verify that the ODF 1.2 fileformat is used correctly	Standard	3	Oliver Craemer

Collaboration	Verify that the collaboration feature works as designed	Standard	2	Oliver Craemer

Functions: SUMIF	The return value for calculation with the SUMIF function should be tested	Standard	1	Oliver Craemer

Functions: ISERROR(undefinedname) results in TRUE	Verify that the ISERROR function works correctly	Standard	5	Oliver Craemer

Functions: Infix Operator Reference Range	The return value for calculation with an infix range operator (":") should be tested	Standard	1	Oliver Craemer

Functions: MIN/MAX return 0 if no value at all	The return value for calculation with empty cells should be tested	Standard	1	Oliver Craemer

Functions: Reference to empty cell not forced to type	Ther return value for calculation with empty cells should be tested	Standard	1	Oliver Craemer

Functions: Infix Operator Reference Concatenation (aka Union)	Concatenation of two references via ~ has to be tested	Standard	3	Oliver Craemer

Selection Visualization	The new selection visualization should be tested	Standard	2	Oliver Craemer

Calc Solver	Test the new Solver feature for Calc	Standard	2	Frank Stecher

Zoom factor per Sheet	test the functionality of different Zoom levels for each sheet	Standard	1	Frank Stecher

Calc Print Dialog	Check the functionallity of the Calc Print Dialog	Standard	5	Frank Stecher

Datapilot	Check the Datapilot functionality	Standard	6	Frank Stecher

Calc Data Input	Check the new data input feature using TAB to travel and RETURN to go to the first column and next row	Standard	1	Frank Stecher

Enhanced Formula Input	Make sure the new enhanced formula input works as specified	Standard	3	Frank Stecher

Autofiltertest	Test the Autofilter	Standard	5	Frank Stecher

Text to Columns	Copy text from a single column to multiple columns with just two clicks	Standard	10	Frank Stecher

Drag & Drop functionality	Drag & Drop functionality (move/copy/insert)	Standard	5	Frank Stecher

Toogle Formula View	Check the functionality of the toogle Formula view functionality	Standard	2	Frank Stecher

Toolbars in Spreadsheet	Availability of toolbars in Spreadsheet	Standard	2	Oliver Craemer

Macro support for graphic and autoshapes	Checkig functionality of assigning macros to graphics and verifiing the im/export	Standard	2	Oliver Craemer

JIS and ASC function	Check the JIS and ASC function to be compatible to Japanese Excel	Standard	1	Frank Stecher

Validity	Check the functionality of the Validity feature	Standard	10	Frank Stecher

New function: getpivotdata	This test verifies the function getpivotdata with all parameters including im/export to XLS	Standard	2	Oliver Craemer

Anti Flickering test	Test that excessive flickering does not occur	Standard	2	Frank Stecher

Autosums	test the functionality of autosummation within the Spreadsheet application.	Standard	14	Frank Stecher

Array constants	Test for verifiing the support of inline matrix/array constants in formulas	Standard	2	Oliver Craemer

Web Preview for Calcdocuments	Check that Calc documents are exported to a temp HTML file, the default browser is started and the temp file is shown in the browser.	Standard	1	Frank Stecher

Functions and formulas	Check the functions available for calculations	Standard	11	Frank Stecher

Fill/Autofill handle test	Testing the Fill/Autofill functionality for cells	Standard	1	Frank Stecher

Excel Pivotcache Import	Test the Import of Datapilots in Excel documents based on external files	Standard	1	Frank Stecher

Clipboardtest	Test the clipboard functionality in it's entirety	Standard	9	Frank Stecher

Notes in Calc	Test the Notes functionality for Spreadsheet documents	Standard	4	Frank Stecher

Delete Rows/Columns/Content	Test the Delete options from Keyboard, Edit Menu and Context Menu	Standard	4	Frank Stecher

DBase Import/Export	Test the dbase filter	Standard	2	Frank Stecher

Importing sheet from text files with uppercase file extension letters	Inserting sheets from text files	Standard	1	Jogi Sievers

Localedata	Availability of different localedata	Standard	3	Oliver Craemer

Open / Import / Paste Behaviour of HTML and RTF Data	Check that English formatted numbers are imported	Standard	8	Frank Stecher

INFO Spreadsheet Function	Verify that OpenOffice.org use it right.	Standard	2	Oliver Craemer

06.11.09 12:11:17

The Free and Open Productivity Suite

OpenOffice.org - Testcase specifications