CoinMP Solver not Available, option requires coinmp to be promoted

Bug #1905422 reported by Rafael Lima
18
This bug affects 2 people
Affects Status Importance Assigned to Milestone
coinmp (Ubuntu)
New
Undecided
Unassigned
libreoffice (Ubuntu)
Confirmed
Medium
Heather Ellsworth

Bug Description

Hi! LibreOffice Calc supports the CoinMP Linear Solver, which is an excellent solver to be used in spreadsheets and makes LO Calc superior to other office suites in that regard.

However, the build provided by this PPA does not come with CoinMP Solver enabled (see Tools > Solver > Options). I posted a question at Ask LibreOffice and I was informed that CoinMP is enabled by default during build and maybe the PPA maintainers chose to disable it.

https://ask.libreoffice.org/en/question/240836/coinmp-solver-on-libreoffice-calc/

In fact, I built LibreOffice from source and CoinMP was there. However, building from source is not convenient and I'd like to use the PPA.

Is it possible that CoinMP Solver be included in future builds of LibreOffice provided by this PPA?

I am currently using LibreOffice 7.0.3.1 on Ubuntu 20.04.

Revision history for this message
Olivier Tilloy (osomon) wrote : Re: CoinMP Solver not Available

I see that CoinMP support was disabled in Ubuntu (it is enabled in Debian) 5 years ago¹, because of dependency issues. This could/should probably be revisited.

¹ https://git.launchpad.net/~libreoffice/ubuntu/+source/libreoffice/commit/?h=ubuntu-groovy-7.0&id=3d9c888b38a35b39f282e6aedfd4ad6d447faf0b

summary: - CoinMP Solver not Available in the PPA build
+ CoinMP Solver not Available
Changed in libreoffice (Ubuntu):
status: New → Confirmed
importance: Undecided → Medium
tags: added: rls-hh-incoming
Revision history for this message
Heather Ellsworth (hellsworth) wrote :

Ok so looks like CoinMP was disabled in 2015 but then Rene re-eneabled it only a few months ago:

https://git.launchpad.net/~libreoffice/ubuntu/+source/libreoffice/commit/?h=ubuntu-groovy-7.0&id=8a5d2a1162dbacd05a656eea7ce6b4769ab568bb

However, this is for groovy - the only series for which we've published _in the archive_ a 7.X version of Libreoffice. Rafael, are you using the snap or perhaps you can point to the PPA that is providing your Libreoffice debs?

Revision history for this message
Olivier Tilloy (osomon) wrote :

Heather, this is not groovy-specific. It was re-enabled recently in Debian, but the Ubuntu packages have additional logic that override this, and force-disable it. See the commit I linked to in comment #1, which is inside a [ifeq "$(DEB_VENDOR)" "Ubuntu"] conditional.

Revision history for this message
Heather Ellsworth (hellsworth) wrote :

> which is inside a [ifeq "$(DEB_VENDOR)" "Ubuntu"] conditional.

Ah yes darn I missed this. Thanks for that :)

summary: - CoinMP Solver not Available
+ CoinMP Solver not Available, option requires coinmp to be promoted
Revision history for this message
Heather Ellsworth (hellsworth) wrote :

Without a reason of why CoinMP was disabled in 2015, I don't have a basis to go off on to re-evaluate enabling it. We could revert the patch Olivier mentioned in comment 1 to close this bug but could be reintroducing an old issue. Olivier/Seb, your suggestions?

Revision history for this message
Sebastien Bacher (seb128) wrote :

The usual reason is 'the package is in universe so we can't use it yet, the MIR process takes time and we don't want to be blocked so let's disable so we can get things rolling' but I don't have more background information on whether there was a specific reason, I will let Olivier comment

Revision history for this message
Olivier Tilloy (osomon) wrote :

Unfortunately, the commit I linked to in comment #1 doesn't explain why coinmp support was disabled. The most likely reason is what Séb wrote, that a package in main cannot depend on a package in universe, and promoting a dependency from universe to main can be a tedious and time-consuming process.

Before going ahead with the MIR, I suggest listing all of coinmp's direct and indirect dependencies, and checking whether there are known bugs affecting these packages (in Ubuntu and Debian).

Changed in libreoffice (Ubuntu):
assignee: nobody → Heather Ellsworth (hellsworth)
Revision history for this message
Sebastien Bacher (seb128) wrote :

Would be nice to provide but it doesn't seem important enough for rls tracking at this point

tags: added: rls-hh-notfixing
removed: rls-hh-incoming
Revision history for this message
Olivier Tilloy (osomon) wrote :

I think it'd be worth testing whether libreoffice-calc can be built with coinmp support (build dependencies don't have to be in main) and still function without the dependency installed (i.e. runtime detection).

Revision history for this message
Heather Ellsworth (hellsworth) wrote :

Well I removed the "ENABLE_COINMP := n" from the "ifeq "$(DEB_VENDOR)" "Ubuntu"" block and launched an amd64 build and it failed with:

dpkg-shlibdeps: error: no dependency information found for /<<PKGBUILDDIR>>/debian/libreoffice-core/usr/lib/libreoffice/program/libCoinMP.so.1 (used by debian/libreoffice-calc/usr/lib/libreoffice/program/libsolverlo.so)

The PPA where this built:
https://launchpad.net/~hellsworth/+archive/ubuntu/lo-coinmp

The full PPA build log is here:
https://launchpadlibrarian.net/509651435/buildlog_ubuntu-hirsute-amd64.libreoffice_1%3A7.0.3-0ubuntu3_BUILDING.txt.gz

It looks like this libCoinMP.so.1 is provided by the coinor-libcoinmp1v5 package. I can try to add this as a depends, rebuild, and see if we get further.

Revision history for this message
Heather Ellsworth (hellsworth) wrote :

I've built Libreoffice with coinmp support and all of the Libreoffice applications seem to run just fine.

@Rafael, would you mind trying to use the CoinMP linear solver as you'd like and provide feedback? The patched packages are in this ppa:

https://launchpad.net/~hellsworth/+archive/ubuntu/lo-coinmp/

Revision history for this message
Rafael Lima (rafael-palma-lima) wrote :

Hi Heather! I was not able to install LibreOffice using this PPA. When I enter:

sudo add-apt-repository ppa:hellsworth/lo-coinmp

I get the following error:

Err:22 http://ppa.launchpad.net/hellsworth/lo-coinmp/ubuntu groovy Release
  404 Not Found [IP: 91.189.95.83 80]
Hit:23 http://security.ubuntu.com/ubuntu groovy-security InRelease
Reading package lists... Done
E: The repository 'http://ppa.launchpad.net/hellsworth/lo-coinmp/ubuntu groovy Release' does not have a Release file.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.

Maybe this is because I'm running Ubuntu 20.10 Groovy and you built LibreOffice for 21.04 Hirsuite. Will I need to install a 21.04 daily build to test the new LibreOffice package? Or is there another way for me to download and test it?

Revision history for this message
Rico Tzschichholz (ricotz) wrote :

MIR required for binary packages of the following source packages:
  coinmp, coinor-cbc, coinor-cgl, coinor-osi, coinutils, clp

libreoffice in hirsute-proposed built with coinmp support
  https://launchpad.net/ubuntu/+source/libreoffice/1:7.0.4~rc2-0ubuntu1

The PPA builds for bionic, focal and hirsute in https://launchpad.net/~libreoffice/+archive/ubuntu/libreoffice-prereleases are built with enabled coinmp support now.

Changed in libreoffice (Ubuntu):
status: Confirmed → Triaged
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package libreoffice - 1:7.0.4~rc2-0ubuntu2

---------------
libreoffice (1:7.0.4~rc2-0ubuntu2) hirsute; urgency=medium

  * Revert "Re-enable coinmp (LP: #1905422)" until MIR is sorted out

 -- Rico Tzschichholz <email address hidden> Mon, 14 Dec 2020 10:05:19 +0100

Changed in libreoffice (Ubuntu):
status: Triaged → Fix Released
Changed in libreoffice (Ubuntu):
status: Fix Released → Confirmed
Revision history for this message
Rafael Lima (rafael-palma-lima) wrote :

So I've been using LO from the fresh PPA (https://launchpad.net/~libreoffice/+archive/ubuntu/ppa) and it does not come with CoinMP enabled.

Is there any particular package that I need to install to make CoinMP work with LibreOffice on Ubuntu?

Or is this a bug and we should reopen the ticket?

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.