This is a scenario for an expense sheet.

Disclaimer: You are free to reuse it “as-is”, on your own responsibility and without any guarantee whatsoever. No rights can be derived from, successfully or unsuccessfully, completing the steps outlined below.

1. Create document:

• Open the application
• Create a new empty text document
• Add a document-level metadata keyword “expense sheet”

Checks:

1. Keyword correct

2. Format first page

• Set page size to A4, portrait
• Apply 2 cm margins
• Add a 1 cm header (no spacing between header and page body)
• Add a 1 cm footer (no spacing between footer and page body)
• Add a document-level metadata keyword “expense sheet”

Checks:

1. Page margins correct
2. Header and footer correct

3. Header image:

• Add this in the header
• Center it horizontally and vertically
• Add the alternate text “Logo of OpenDoc Society” to this picture

Checks:

1. PNG image visible
2. Image centered horizontally
3. Image centered vertically
4. Alternate text present

4. Title:

• Add the text “Expense sheet” on top of the page
• Set the text alignment to align to center
• Set the font to Arial 14 point, Bold, black [ Help ]
• Set the top, bottom, left and right border type to 3 point solid, black
• Add a bottom margin of 1 cm
• Set the background to 10% gray

Checks:

1. Text visible
2. Aligned to center
3. Font is Arial 14pt, Bold, black
4. Borders are 3pt solid, black
5. Bottom margin is 1 cm
6. Background 10% gray

5. Subtitle:

• Add the text “Description” on a new line
• Set the font to Arial 13 point, single underline
• Add a top margin of 0,4cm

Checks:

1. Text visible
2. Underline is visible
3. Top margin is 0.4cm

6. General text:

• Add the text “This is an example of an expense sheet. Fill out the paperwork and get reimbursed.” on a new line
• Set the font to Arial 12 point

7. Fields:

• Add the text “General info” on a new line
• Match the style of (5.) permanently [ Help ]
• Add the text “From: ” on a new line
• Match the style of (6.) permanently
• Add a (non-fixed) “current user” field on the same line
• Format the field value as “Firstname Lastname”
• Press tab twice
• Add the text “Date: ” on the same line
• Match the style of (6.) permanently
• Add a “current date” field on the same line
• Format the field as “DD Month YYYY”

Checks:

1. Author field present
2. User name displayed
3. Two tabs between field and “Date”
4. Date field present
5. Date format DD Month YYYY

8. Expense table:

• Add the text “Expenses” on a new line
• Match the style of (5.) permanently
• Add a 4-row x 2 column table with support for formulas [ Help ]
• Make the columns 10 cm and 2 cm wide

Checks:

1. Table with 4 rows and 2 columns
2. Columns are 10cm and 2cm wide

9. Table header:

• Add the text “Description” to cell A1
• Add the text “Amount” to cell B1
• Set the font to Arial 11 point, bold, single underline

Checks:

1. Text visible
2. Font is Arial 11pt bold
3. Single underline

10. Table contents:

• Add the text “Hotel expenses” to cell A2
• Add the value “150.25” to cell B2
• Add the text “Restaurant expenses” to cell A3
• Add the value “65.75” to cell B3
• Set the font to Arial 10 point

Checks:

1. Values are correct

11. Table formula:

• Add the text “Total” to cell A4
• Set the font to Arial 10 point, bold
• Set the number style to currency, format ”#,00 €”
• Add a formula to cell B4, calculating B2+B3 (216,00 €)

Checks:

1. Format is #,00
2. Numbers are currency
3. Sum is correct

12. Additional general text:

• Add the text “Signature” on a new line
• Match the style of (5.) permanently

13. Field in footer:

• Add a “current file name” field in the footer, format “file.extension” (without path)
• Align it to the center

Checks:

1. Filename field present
2. Format is file.extension
3. Aligned to center

14. Save the document as ODF 1.2

• Save the document as “Expense sheet.odt”

Checks:

1. File name possible
2. Document validates against ODF 1.2
3. ODF contains PNG thumbnail
4. ODF contains mimetype stream
5. ODF contains meta:generator

• OpenOffice.org 3.1 on Windows XP
• created by Lotus Symphony 1.3

• OOo -> Symphony 1.3

Here is a section for loading the PDF representations of documents generated in other applications.

A list of known issues. Implementations not listed here may or may not work as expected. Results may vary depending on user settings and computer environment. Use at your own risk.

Report attach found issues report expense_sheet_test_report.odt

Symphony has fewer fixed fields than OO3.1, but one can use user-defined fields as work around.