• Test plan for component: libreoffice

• Upstream project: https://www.libreoffice.org/

• Ubuntu package URL (LP): https://launchpad.net/ubuntu/+source/libreoffice

• Ubuntu packaging team (LP): https://launchpad.net/~libreoffice

• Ubuntu packaging repository: https://code.launchpad.net/~libreoffice/ubuntu/+source/libreoffice/+git/libreoffice-debian-pkg

Description

This is a test plan for libreoffice as used by Ubuntu Desktop.

Initial set up

• Install latest Ubuntu Desktop development release

• Install libreoffice from -proposed

• Be sure to test the upgrade paths:

  • current release (os) -> new libreoffice

  • upgrade prev release (os) -> current release (os) -> new libreoffice

  • uninstall libreoffice* and install new version from blank slate

Autopkgtests

Verify that autopkgtests all pass.

Manual Tests

General

• apparmor profiles are either in complain mode (distro-patch) or disabled (symlinks in /etc/apparmor.d/disable):

  • sudo apparmor_status

• startcenter and math don't show up in gnome shell when searching for "libre", only writer, calc, impress, draw (bug #1696250, currently fixed only in 6.0 in bionic, 6.1 in cosmic and 6.2 in disco)

• UI fully localized in the user's preferred locale
  • make sure F1 opens the online help

Start Center

• "about libreoffice" from startcenter, version number as expected, VCL: gtk3
• math can be launched from startcenter

• startcenter, tools > options

  • libreoffice > advanced : no JRE installed by default, installing libreoffice-base pulls in the JVM and finds it

  • language settings > writing aids : aids listed for the current language

Writer

• ubuntu fonts listed
• load/save document works, even outside home (create /home2/foobar and save/open from there)
• load/save with UTF-8 characters in filename
• export to PDF works (can open with evince)
• print (to file)
• ctrl+click on hyperlink in document opens link in default browser
• inserting video clip in document, can be played back
• inserting date field in document works
• send as e-mail attachment (from file menu, have evolution configured as default e-mail client)

• save to google drive works (when bug #1754400 is fixed)

Calc

• launch calc while writer is running, getting two separate icons in the launcher, one for each application (Known issue with snap: bug #1749590)

• basic formula (=A1+A2) works, editing colours each cell in a different colour
• sum formula works
• apply currency formatting works
• load/save document works
• export to PDF works (can open with evince)
• print (to file)

• webservice formula works for http://example.org/

• webservice formula returns value error for /etc/passwd

• tools > solver > options : non-linear solver (experimental) is available

Draw

• load/save document works
• draw a few shapes and text, change fonts
• export to PDF works (can open with evince)
• print (to file)

• insert draw odg file into writer document (insert > object > OLE)

• double-clicking the embedded odg opens a Draw edit window

Impress

• create and edit a presentation from template works
• F5 to start presentation fullscreen works, spacebar to go through slides
• an embedded video clip can be played back in both edit and presentation mode
• load/save document works
• export to PDF works (can open with evince)
• print (to file)

Base

• create a new Firebird Embedded database from wizard
• load/save document works
• add table
• insert data into table
• create query, execute it
• create report (requires the libreoffice-report-builder package, not installed by default)

Math

• create formula
• load/save document works
• export to PDF works (can open with evince)
• print (to file)

• insert a formula into a writer document (insert > object > formula)