Solver- how to get non linear options available again?

[ra-loffice]

I had Solver working fine in L calc 7.2.
I installed L calc 7.3 and can't get non linear options- I use DEPS Evolutionary Algorithm a lot.
How do I fix this?

Thanks, RA
Ubuntu 18.04

[Villeroy]

The non-linear solver is an add-on that is shipped with the office suite. It is installed by default. It should be listed in the extensions manager.

[ra-loffice]

>The non-linear solver is an add-on that is shipped with the office suite. It is installed by default. It should be listed in the extensions manager.<

My Lcalc 7.3 extensions manager has nothing in it. I've searched for extensions and found nothing applicable.

[Villeroy]

If your LO 6.0 is the native office suite of your distribution:

Code: Select all

sudo apt install libreoffice-nlpsolver

[ra-loffice]

sudo apt install libreoffice-nlpsolver
That worked, the extension is now in the extension manager, but it's *locked* and the option of running it is still gone.
I can't find anything telling me how to unlock it.

[Villeroy]

The lock icon indicates that this extension is installed in the installation directory with no write access to the user. You have to remove it as root just like you installed it as root.

It should be availlable after restarting the office suite.

[ra-loffice]

I am root. I've tried numerous things to get this thing working. NLP is still not available.
Is there a quick way of fixing this?
All this time consuming problem started after installing l office 7.3.

[Villeroy]

1. You must not use LO as root! This is pointless and dangerous.
Well, then remove 7.3 and restore the old user profile from backup dating back to the day before you added 7.3.
If everything is back and working with LO 6, do the following:
Create a profile folder ~/.config/libreoffice/7
Install 7.3.
Edit /opt/libreoffice7.3/program/bootstrap (as root)
Change the profile folder to ~/.config/libreoffice/7

Now you can use both office suites with independent user profiles.

Or install a more recent Linux distribution.

Or remove LO6, rename the profile folder ~/.config/libreoffice/7 and install LO7. This will start with a new profile folder and you may restore some parts from the renamed backup.

[Steph22]

Bonjour,

I had exactly the same problem ! With LibreOffice 7.3, DEPS solver is not available in the list anymore, and NLP stays " locked" in the Extension Manager...
The only way I have found is to downgrade LibreOffice from 7.3 to 7.2. My solution is little "radical", but DEPS is available again