[SRU] libreoffice 7.6.6 for mantic

[Rico Tzschichholz]

[Impact]

 * LibreOffice 7.6.6 is in its sixth bugfix release of the 7.6 line:
     https://wiki.documentfoundation.org/ReleasePlan/7.6#7.6.6_release

 * Version 7.6.5 is currently released in mantic. For a list of fixed bugs compared to 7.6.5 see the list of bugs fixed in the release candidates of 7.6.6 (that's a total of 39 bugs):
     https://wiki.documentfoundation.org/Releases/7.6.6/RC1#List_of_fixed_bugs
     https://wiki.documentfoundation.org/Releases/7.6.6/RC3#List_of_fixed_bugs

     7.6.6 RC3 is identical to the 7.6.6 release

 * Given the nature of the project, the complexity of the codebase and the high level of quality assurance upstream, it is preferable to SRU a minor release rather than cherry-pick selected bug fixes.

[Testing]

 * Upstream testing. Bugs fixed upstream typically include unit/regression tests, and the release itself is extensively exercised (both in an automated manner and manually).

  * A recent set of upstream's automated jenkins testing can be found here:
    https://ci.libreoffice.org/job/gerrit_76/1898/

  * More information about the upstream QA testing can be found here:
    * Automated tests
      https://wiki.documentfoundation.org/QA/Testing/Automated_Tests
    * Automated UI tests
      https://wiki.documentfoundation.org/Development/UITests
    * Regression tests
      https://wiki.documentfoundation.org/QA/Testing/Regression_Tests
    * Feature tests
      https://wiki.documentfoundation.org/QA/Testing/Feature_Tests

 * Launchpad testing. The libreoffice packages include autopkgtests that were run and verified as passing.
    Tested build can be found at https://launchpad.net/~ricotz/+archive/ubuntu/ppa/+sourcepub/15869507/+listing-archive-extra
    * [amd64] https://autopkgtest.ubuntu.com/results/autopkgtest-mantic-ricotz-ppa/mantic/amd64/libr/libreoffice/20240323_001335_50e00@/log.gz
    * [arm64] https://autopkgtest.ubuntu.com/results/autopkgtest-mantic-ricotz-ppa/mantic/arm64/libr/libreoffice/20240324_215819_0b108@/log.gz
    * [armhf] https://autopkgtest.ubuntu.com/results/autopkgtest-mantic-ricotz-ppa/mantic/armhf/libr/libreoffice/20240322_202324_f628d@/log.gz
    * [ppc64el] https://autopkgtest.ubuntu.com/results/autopkgtest-mantic-ricotz-ppa/mantic/ppc64el/libr/libreoffice/20240322_145135_f3904@/log.gz
    * [riscv64] not available
    * [s390x] https://autopkgtest.ubuntu.com/results/autopkgtest-mantic-ricotz-ppa/mantic/s390x/libr/libreoffice/20240322_140411_ca6c5@/log.gz
 * General smoke testing of all the applications in the office suite were carried out by going through the manual testplan as documented by: https://wiki.ubuntu.com/Process/Merges/TestPlans/libreoffice

[Regression Potential]

 * A minor release with a total of 39 bug fixes always carries the potential for introducing regressions, even though it is a bugfix-only release, meaning that no new features were added, and no existing features were removed.

 * A combination of autopkgtests and careful smoke testing as described above should provide reasonable confidence that no regressions sneaked in.

[Rico Tzschichholz (ricotz)]

Packaging changes are staged at https://git.launchpad.net/~libreoffice/ubuntu/+source/libreoffice/log/?h=wip/mantic-7.6

[Rico Tzschichholz (ricotz)]

This is blocking https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/2062140

[Andreas Hasenack (ahasenack)]

I downloaded the original tarballs from https://download.documentfoundation.org/libreoffice/src/7.6.6/ and:
- verified their signatures
- matched 7.6.6.orig.tar.xz to upstream's 7.6.6.3 (it's a versioning quirk to call 7.6.6rc3 7.6.6.3 in the end):
$ sha256sum libreoffice_7.6.6.orig.tar.xz upstream/libreoffice-7.6.6.3.tar.xz
41a83a7f09c539e22c873107d5d4088ac7cdf1a299ad9e9de15e30600fe521b6 libreoffice_7.6.6.orig.tar.xz
41a83a7f09c539e22c873107d5d4088ac7cdf1a299ad9e9de15e30600fe521b6 upstream/libreoffice-7.6.6.3.tar.xz

I also verified the packaging changes in debian/* via debdiff.

The extra repacked tarballs from the source package are a bit harder to verify, I'm trying to do that next.

[Andreas Hasenack (ahasenack)]

translations tarball verified
help tarball verified
tarballs tarball:
@@ -14,12 +14,13 @@
 tiff-4.6.0.tar.xz
 libepubgen-0.1.1.tar.xz
 a39f6c07ddb20d7dd2ff1f95fa21e2cd-raptor2-2.0.15.tar.gz
+libxslt-1.1.39.tar.xz
 freetype-2.13.0.tar.xz
 beeca87be45ec87d241ddd0e1bad80c1-bsh-2.0b6-src.zip
 openldap-2.6.6.tgz
 gpgme-1.18.0.tar.bz2
 libodfgen-0.1.8.tar.xz
-liblangtag-0.6.3.tar.bz2
+liblangtag-0.6.7.tar.bz2
 libatomic_ops-7.6.8.tar.gz
 xmlsec1-1.2.37.tar.gz
 breakpad-b324760c7f53667af128a6b77b790323da04fcb9.tar.xz
@@ -30,12 +31,10 @@
 Firebird-3.0.7.33374-0.tar.bz2
 frozen-1.1.1.tar.gz
 3404ab6b1792ae5f16bbd603bd1e1d03-libformula-1.1.7.zip
-zlib-1.3.tar.xz
 1f5def51ca0026cd192958ef07228b52-rasqal-0.9.33.tar.gz
 lxml-4.1.1.tgz
 odfvalidator-0.9.0-RC2-SNAPSHOT-jar-with-dependencies-2726ab578664434a545f8379a01a9faffac0ae73.jar
 5ade6ae2a99bc1e9e57031ca88d36dad-hyphen-2.8.8.tar.gz
-libxslt-1.1.38.tar.xz
 libmwaw-0.3.21.tar.xz
 libmspub-0.1.4.tar.xz
 mDNSResponder-878.200.35.tar.gz
@@ -59,12 +58,12 @@
 libwps-0.4.14.tar.xz
 3ade8cfe7e59ca8e65052644fed9fca4-epm-3.7.tar.gz
 poppler-23.09.0.tar.xz
+zlib-1.3.1.tar.xz
 libetonyek-0.1.10.tar.xz
 17410483b5b5f267aa18b7e00b65e6e0-hsqldb_1_8_0.zip
 d8bd5eed178db6e2b18eeed243f85aa8-flute-1.1.6.zip
 ba2930200c9f019c2d93a8c88c651a0f-flow-engine-0.9.4.zip
 glm-0.9.9.8.zip
-libxml2-2.11.4.tar.xz
 1725634df4bb3dcb1b2c91a6175f8789-GentiumBasic_1102.zip
 a7983f859eafb2677d7ff386a023bc40-xsltml_2.1.2.zip
 libabw-0.1.3.tar.xz
@@ -75,6 +74,7 @@
 dragonbox-1.1.3.tar.gz
 pixman-0.42.2.tar.gz
 libexttextcat-3.4.6.tar.xz
+libxml2-2.12.5.tar.xz
 libpng-1.6.40.tar.xz
 f543e6e2d7275557a839a164941c0a86e5f2c3f2a0042bfc434c88c6dde9e140-opens___.ttf
 libffi-3.4.4.tar.gz

So the changes are:
libxslt 1.1.38 -> 1.1.39: verified
liblangtag: 0.6.3 -> 0.6.7: verified
zlib 1.3 -> 1.3.1: verified
libxml2 2.11.4 -> 2.12.5: verified

Tarballs of the same version didn't change.

[Andreas Hasenack (ahasenack)]

Hello Rico, or anyone else affected,

Accepted libreoffice into mantic-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/libreoffice/4:7.6.6-0ubuntu0.23.10.1 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, what testing has been performed on the package and change the tag from verification-needed-mantic to verification-done-mantic. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed-mantic. In either case, without details of your testing we will not be able to proceed.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance for helping!

N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days.

[Ubuntu SRU Bot (ubuntu-sru-bot)]

All autopkgtests for the newly accepted libreoffice (4:7.6.6-0ubuntu0.23.10.1) for mantic have finished running.
The following regressions have been reported in tests triggered by the package:

libreoffice/4:7.6.6-0ubuntu0.23.10.1 (armhf)

Please visit the excuses page listed below and investigate the failures, proceeding afterwards as per the StableReleaseUpdates policy regarding autopkgtest regressions [1].

https://people.canonical.com/~ubuntu-archive/proposed-migration/mantic/update_excuses.html#libreoffice

[1] https://wiki.ubuntu.com/StableReleaseUpdates#Autopkgtest_Regressions

Thank you!

[Rico Tzschichholz (ricotz)]

Upgraded libreoffice from 4:7.6.5-0ubuntu0.23.10.1 to 4:7.6.6-0ubuntu0.23.10.1 from mantic-proposed in a clean and up-to-date mantic amd64 VM, and successfully ran test plan at https://wiki.ubuntu.com/Process/Merges/TestPlans/libreoffice.