[Libreoffice-bugs] [Bug 123030] New: Calc crash when solver makes variables integer

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Jan 29 08:03:14 UTC 2019


https://bugs.documentfoundation.org/show_bug.cgi?id=123030

            Bug ID: 123030
           Summary: Calc crash when solver makes variables integer
           Product: LibreOffice
           Version: 5.2.7.2 release
          Hardware: x86 (IA32)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice.org at wongs.net

Description:
With a simple spreadsheet, I can crash Calc by using Data -> Solver and three
constraints.

Steps to Reproduce:
1. Create this 3x3 spreadsheet:

          0          0          0
=A1+B1+C1           80
=1/2*A1    =2/3*B1+1/4


2. Use Tools → Solver with these values:

Target: C3
By changing: A1:C1
Limiting conditions:
    A1:C1  Integer
    A2  =  B2
    A3  =  B3
    A1:C1  >=  0
    A1:C1  <=  80

3.Click on "Solve"

Actual Results:
Crash

Expected Results:
Solve the system of linear equations


Reproducible: Always


User Profile Reset: No



Additional Info:
Order of constraints matters. Setting the inequalities first makes the solver
work. Also, setting only two of the three variables to be integers makes the
solver work. Likewise, using "Options -> Assume Variables as Integer" does not
trigger this bug.

Version: 5.2.7.2
Build ID: 1:5.2.7-1+deb9u4
CPU Threads: 2; OS Version: Linux 4.9; UI Render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); Calc: group

-- 
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/20190129/6740e001/attachment.html>


More information about the Libreoffice-bugs mailing list