[BPO] libreoffice 7.4.6 for bionic, focal and jammy

[Rico Tzschichholz]

[Impact]

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

 * This source packages matches the proposed SRU for kinetic handled at
     https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/2009354
   and its backport is currently provided by the LibreOffice Still PPA at
     https://launchpad.net/~libreoffice/+archive/ubuntu/libreoffice-still/+packages

 * LibreOffice 7.3.7 (EOL since November 30, 2022) is currently released in bionic-/focal-backports

[Scope]

 * Backport of https://launchpad.net/ubuntu/+source/libreoffice/1:7.4.6-0ubuntu0.22.10.1

 * Backport targets are the Bionic/18.04, Focal/20.04 and Jammy/22.04 LTS releases to provide an official build of a more recent upstream version of LibreOffice

[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_74/1717/

  * 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.

   Bionic/18.04 build at https://launchpad.net/~libreoffice/+archive/ubuntu/libreoffice-still/+sourcepub/14541804/+listing-archive-extra
    * [amd64] https://autopkgtest.ubuntu.com/results/autopkgtest-bionic-libreoffice-experimental/bionic/amd64/libr/libreoffice/20230311_021721_5528d@/log.gz
    * [arm64] https://autopkgtest.ubuntu.com/results/autopkgtest-bionic-libreoffice-experimental/bionic/arm64/libr/libreoffice/20230311_022133_e8482@/log.gz
    * [armhf] https://autopkgtest.ubuntu.com/results/autopkgtest-bionic-libreoffice-experimental/bionic/armhf/libr/libreoffice/20230311_034543_5547f@/log.gz
    * [i386l] https://autopkgtest.ubuntu.com/results/autopkgtest-bionic-libreoffice-experimental/bionic/i386/libr/libreoffice/20230311_024716_6fc50@/log.gz
    * [ppc64el] https://autopkgtest.ubuntu.com/results/autopkgtest-bionic-libreoffice-experimental/bionic/ppc64el/libr/libreoffice/20230311_013201_6dbb2@/log.gz
    * [s390x] https://autopkgtest.ubuntu.com/results/autopkgtest-bionic-libreoffice-experimental/bionic/s390x/libr/libreoffice/20230311_013952_49140@/log.gz

   Focal/20.04 build at https://launchpad.net/~libreoffice/+archive/ubuntu/libreoffice-still/+sourcepub/14541807/+listing-archive-extra
    * [amd64] https://autopkgtest.ubuntu.com/results/autopkgtest-focal-libreoffice-libreoffice-still/focal/amd64/libr/libreoffice/20230311_001616_c1e3a@/log.gz
    * [arm64] https://autopkgtest.ubuntu.com/results/autopkgtest-focal-libreoffice-libreoffice-still/focal/arm64/libr/libreoffice/20230310_164346_4ac1d@/log.gz
    * [armhf] https://autopkgtest.ubuntu.com/results/autopkgtest-focal-libreoffice-libreoffice-still/focal/armhf/libr/libreoffice/20230311_052748_8b7c3@/log.gz
    * [ppc64el] https://autopkgtest.ubuntu.com/results/autopkgtest-focal-libreoffice-libreoffice-still/focal/ppc64el/libr/libreoffice/20230310_151809_05c21@/log.gz
    * [s390x] https://autopkgtest.ubuntu.com/results/autopkgtest-focal-libreoffice-libreoffice-still/focal/s390x/libr/libreoffice/20230310_190707_a5b67@/log.gz

   Jammy/22.04 build at https://launchpad.net/~libreoffice/+archive/ubuntu/libreoffice-still/+sourcepub/14541810/+listing-archive-extra
    * [amd64] https://autopkgtest.ubuntu.com/results/autopkgtest-jammy-libreoffice-libreoffice-still/jammy/amd64/libr/libreoffice/20230310_160612_6f011@/log.gz
    * [arm64] https://autopkgtest.ubuntu.com/results/autopkgtest-jammy-libreoffice-libreoffice-still/jammy/arm64/libr/libreoffice/20230310_162731_bffe0@/log.gz
    * [armhf] https://autopkgtest.ubuntu.com/results/autopkgtest-jammy-libreoffice-libreoffice-still/jammy/armhf/libr/libreoffice/20230310_184457_436f8@/log.gz
    * [ppc64el] https://autopkgtest.ubuntu.com/results/autopkgtest-jammy-libreoffice-libreoffice-still/jammy/ppc64el/libr/libreoffice/20230310_154240_ed781@/log.gz
    * [s390x] https://autopkgtest.ubuntu.com/results/autopkgtest-jammy-libreoffice-libreoffice-still/jammy/s390x/libr/libreoffice/20230310_163514_74228@/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 combination of autopkgtests and careful smoke testing as described above should provide reasonable confidence that no regressions sneaked in.

[Dan Streetman (ddstreet)]

Wow someone got crazy with the epoch, jumping from 1 to 4! Wonder what happened there... (not relevant to this backport, just surprising ;-)

It LGTM, but the backport-from is still in kinetic-proposed (from lp: 2009354), so we need to wait for that to migrate into kinetic-updates first.

Also for the backport to bionic, just keep in mind that after the bionic repo closes (in a month-ish), we won't be able to backport to it, so this might be the last version in bionic-backports.

[Rico Tzschichholz (ricotz)]

Yeah the epoch bump for 7.5 came from debian. There is not much of the choice but to follow it.

7.4.6 is in kinetic-updates now and these backports can be accepted :-)

Regarding bionic, afaik it will be open for uploads until May 31st. Therefore 7.4.7 should be possible as final update.

[Mattia Rizzolo (mapreri)]

Yes, it seems that René didn't follow the latest rules about epochs, and used it to revent accidental uploads (multiple!) of 7.5 to unstable instead of experimental.

The current policy states that in those cases he should have used the +really notation, but I reckon he wouldn't have liked to release bookworm with a +really in the version string of libreoffice…

(I'm leaving the approval to Dan since he is on this task already)

[Mantas Kriaučiūnas (mantas)]

@ricotz , I don't understand why you use internal graphite and harfbuzz in jammy-backports, while the same graphite2 and harfbuzz version is in Kinetic and Jammy? See

https://launchpad.net/ubuntu/+source/graphite2
https://launchpad.net/ubuntu/+source/harfbuzz

libreoffice (1:7.4.6-0ubuntu0.22.10.1~bpo22.04.1) jammy-backports; urgency=medium

  * Backport from kinetic (LP: #2009944)
  * Use internal graphite and harfbuzz to meat upstream requirements

 -- Rico Tzschichholz <email address hidden> Thu, 09 Mar 2023 14:07:05 +0100

[Rico Tzschichholz (ricotz)]

@mantas: Libreoffice provides conditional paths to work with older harfbuzz versions. Unfortunately this can lead to bugs like [1] [2]. While bionic and focal doesn't provide the required versions after all, I decided to have a consistent base for all backports.

[1] https://bugs.documentfoundation.org/show_bug.cgi?id=153048
[2] https://bugs.documentfoundation.org/show_bug.cgi?id=153470

[Mantas Kriaučiūnas (mantas)]

@ricotz, thanks, but I still don't understand why you use external graphite in Kinetic and Lunar and internal in Jammy and Bionic,
when the same graphite2 1.3.14-1build2 released at 2022-03-28 is in Lunar, Kinetic and Jammy, also in Bionic is almost the same - 1.3.13-11build1 version, see

https://launchpad.net/ubuntu/+source/graphite2

> ricotz) wrote: @mantas: Libreoffice provides conditional paths to work with older harfbuzz versions. Unfortunately this can lead to bugs like [1] [2.

[Rico Tzschichholz (ricotz)]

@mantas: The use of internal hartfbuzz implies/requires internal graphite. [1]

[1] https://cgit.freedesktop.org/libreoffice/core/tree/configure.ac?h=libreoffice-7-4#n10839