We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

NLPSolver not showing in LO Calc snap version (Ubuntu 18.04)

asked 2020-06-21 09:58:23 +0200

johnnycomelately gravatar image

I read this question (https://ask.libreoffice.org/en/questi...) and used the following command to install the non-linear solver for calc:

sudo apt-get install libreoffice-nlpsolver

I have two versions of Calc installed on Ubuntu 18.04, a "normal" version ( and a "snap" version ( After running the command, I do see two new solvers (DEPS and SCO) in the normal version of calc but not in the snap version.

Is there a way to get the evolutionary solvers to show up in the snap version of Calc? Do I need to manually move a file somewhere?

edit retag flag offensive close merge delete


Versions installed in parallel have their different user profiles. Since extensions are installed to the user profile (afaik), you need to do it for your Dev version a second time.
BTW: 7.0.0 coming soon.

Lupp gravatar imageLupp ( 2020-06-21 11:14:26 +0200 )edit

Thanks for this but when I run the same sudo command again, it says I already the newest version. I still do not understand what to do. Any insights would be greatly welcomed.

johnnycomelately gravatar imagejohnnycomelately ( 2020-06-21 11:16:31 +0200 )edit

sudo apt-get install libreoffice-nlpsolver

This is wrong here since snap is a different thing than apt and you installed a snap 6.4.4 LibreOffice version, hence you would need a snap-based procedure to install the solver extension. But snap release doesn't provide the extension - unlike apt/deb installs - by default. In fact couldn't find an extension in snap repositories using snap search ... command. Finally, downloading nlpsolver.oxt and trying to install the extension manually in snap version of LibreOffice failed due to some missing java support, and at that point my dislike of snap got confirmed enough to stop all further efforts ...

Opaque gravatar imageOpaque ( 2020-06-21 13:56:19 +0200 )edit

DEPS and SCO solvers depend on Java. Do you have Java configured and usable in your Snap version (no idea if it may use the same Java as the version from apt repo).

Mike Kaganski gravatar imageMike Kaganski ( 2020-06-21 14:03:43 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-06-23 06:06:29 +0200

johnnycomelately gravatar image

Thanks to all the comments, I found the solution and wanted to document it here for future generations.

Thanks to @Opaque who reminded me that apt is not used for snaps.

  1. Download nlpsolver.oxtfrom https://extensions.openoffice.org/pro...
  2. Open Calc 6.4 (my version as a snap), go to Tools->Extension Manager, click Add
  3. Browse to nlpsolver.oxt and add it, it should be signed by Sun
  4. Restart Calc

Now it should work.

@Opaque commented about the need for Java but I already had that installed (needed to get Zotero to integrate with Writer).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-06-21 09:58:23 +0200

Seen: 134 times

Last updated: Jun 23 '20