https://bugs.documentfoundation.org/show_bug.cgi?id=141196
Bug ID: 141196
Summary: Non-linear solver ignores conditions
Product: LibreOffice
Version: 6.4.6.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 170656
--> https://bugs.documentfoundation.org/attachment.cgi?id=170656&action=edit
File showing entered values in the spreadsheet.
I created a very simple non-linear problem (file is attached).
Having a few values
16
10
11
10
1
20
1
the goal is to maximize the sum of above values to the power of 2:
=SUMPRODUCT(B2:B8,B2:B8)
on the condition the sum of those values is not greater than 69 and these are
non-negative integers.
Linear solver can't do it. Both given NL solvers (Swarm Differential Evolution
and Particle Swarm) ignore the condition and the solutions are very large
10^+18 values.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
