||<>|| * '''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 [[https://wiki.ubuntu.com/Testing/EnableProposed|-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 [[http://autopkgtest.ubuntu.com/packages/libreoffice|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 ([[https://launchpad.net/bugs/1696250|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 [[https://launchpad.net/bugs/1754400|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: [[https://launchpad.net/bugs/1749590|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)