Solver bug

users
#1

Hello Everybody

We are using LibreOffice 4.2.8.2 on Windows 7

We are writing some macros that use NLP solver
("com.sun.star.comp.Calc.NLPSolver.DEPSSolverImpl") and we found a "bug"
that is already reported

https://www.libreoffice.org/bugzilla/show_bug.cgi?id=87074#c3

Any suggestion or alternatives to run non linear equation solver?

Thanks a lot

Paolo

#2

Hi Paolo,

Thanks for your interest. This issue is recorded in the bug tracker Bug
87074 - If called NLP Solver macro is interrupted by an error on the line
where the set ObjectiveCell.
<https://bugs.documentfoundation.org/show_bug.cgi?id=87074>
Patch submitted -- https://gerrit.libreoffice.org/14499

Not sure if there is an immediate fix possible. It might be possible
because the repair is in the AddIn java code, external to the LibreOffice
compiled code. However...
The corrected AddIn won't install (interface is already there) and
the built-in NLPsolver can't be removed (doesn't appear in Ext Mgr).

#3

Hi :slight_smile:
If you are able to write Python or C++ code then the fastest way might be
to write an "Extension"/Add-on/Plugin to fix the immediate problem.

For the longer-term you could then upload that Extension to the LibreOffice
Extensions page and let the devs know. Probably best if you use an
OpenSource license such as LGPL or MPL so that other people can move it
into main branch after testing and maybe editing it.

A slightly longer, but more direct, route might be to join the devs and
maybe ask for a Mentor or for guidance and then work on that bug directly.

If you are more like most of us here then maybe try using Gnumeric
spreadsheet program instead. It's much smaller and lighter and faster
because it's a dedicated spreadsheet program and doesn't have to worry
about fitting in with other programs/modules such as word-processors or
anything.

Regards from
Tom :slight_smile:

#4

@John LeMoyne Castle

John LeMoyne Castle wrote

Patch submitted -- https://gerrit.libreoffice.org/14499

Thanks for the patch!

Your 14499 patch has already been picked up and applied to master,
4.5.0alpha0+
http://cgit.freedesktop.org/libreoffice/core/commit/?id=c290998df667bd2a8a12379642f79d09eca471c3

So folks should test against one of the daily builds of master to verify
correct function (using a parallel install is sufficient).

When it proves functional, possible the correction could also be backported
for use on the 4.4.2 and possibly the 4.3.7 patch cycle releases -- a
separate patch submission for each.

Not sure if there is an immediate fix possible. It might be possible
because the repair is in the AddIn java code, external to the LibreOffice
compiled code.

Agree, direct patching of the 4.2.8.2 build JARs would be dodgy at best,
but the 4.2.8 was the last LO build in that branch--its build infrastructure
has been removed.

#5

Hi :slight_smile:
WOW!!! That is utterly incredible! Fantastic!! :)))

Does anyone have a link to show how to apply patches or anyone here able to
just see if it works on their system?
Regards from
Tom :slight_smile:

#6

Hi Tom,

Hi :slight_smile:
WOW!!! That is utterly incredible! Fantastic!! :)))

Does anyone have a link to show how to apply patches or anyone here able to
just see if it works on their system?

Downloading one of the daily builds after the patch has been applied here
http://dev-builds.libreoffice.org/daily/master/
should work.

Kind regards
Sophie

#7

sophi wrote

Does anyone have a link to show how to apply patches or anyone here able
to
just see if it works on their system?

Downloading one of the daily builds after the patch has been applied here
http://dev-builds.libreoffice.org/daily/master/
should work.

Also, when testing features/function of development builds, most folks
probably would not want to disrupt their "daily driver" build of LO, and so
should install in parallel.

Instructions linked from here by OS.
https://wiki.documentfoundation.org/Installing_in_parallel

#8

On my Fedora system the daily build is libreofficedev. A separate menu item to libreoffice.

Similarly I get a different config file.

Cheers

#9

Hi all,

Because the NLP Solver is already an extension project within LibreOffice,
there was a new nlpsolver.oxt file produced after I made the simple changes.
I would post the oxt as an attachment, but I could not get the new one to
install because I couldn't get the 'built-in' version uninstalled. Seems it
is nailed in there pretty well and can't be swapped out without other [C++,
rsc] patches that definitely won't be delivered before the next release
date.

So... setting the NLP Solver's Objective cell (so it has a goal to work on)
is available in daily builds of the development master. It should also work
well if you patch your own LibreOffice build, but that takes a 'little' bit
of space and time to set up (15 to 25GB and loooong first build).

Echoing the links above...
Daily Build >> http://dev-builds.libreoffice.org/daily/master/ should
work.

Noting -- If you don't want to disrupt your tuned up copy of LO,
you should install in parallel.

Instructions linked from here by OS. --
https://wiki.documentfoundation.org/Installing_in_parallel

If you do test the NLP solver please note your success or failure here or on
Bug#87074 .
Thanks!