[Libreoffice-bugs] [Bug 141196] New: Non-linear solver ignores conditions

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: piotr at kod.com.pl

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210323/2b828672/attachment-0001.htm>