Bug#414970: openoffice.org-calc: solver doesn't follow constraints

[Chris Mortimore <chris.mortimore@googlemail.com>]

Package: openoffice.org-calc
Version: 2.0.4.dfsg.2-5
Severity: important

When using the solver to do linear programming, it always (at least when I've 
used it) gives answers outwith the constraints set.  For example, for a 3 day 
weighted average forecast, the formula is:
Ft = A*Dt-1 + B*Dt-2 + C*Dt-3
where A, B and C need to be between 0 and 1, and A+B+C=1.
Putting this into the solver, it was bringing up the optimum values to be 
things like 1.1...., -0.8...., and A+B+C was always bigger than 1, clearly 
outwith the constraints set.

I can provide the spreadsheet if you cannot reproduce the problem at your end.

On a side note, this is when I have "assume linear model" set.  If I unset 
assume linear model, the solver always says "Iteration time out" and doesn't 
give a solution.

Regards,

Chris Mortimore

-- System Information:
Debian Release: 4.0
  APT prefers testing
  APT policy: (500, 'testing'), (100, 'testing')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-4-686
Locale: LANG=en_GB.utf8, LC_CTYPE=en_GB.utf8 (charmap=UTF-8)

Versions of packages openoffice.org-calc depends on:
ii  libc6                     2.3.6.ds1-13   GNU C Library: Shared libraries
ii  libgcc1                   1:4.1.1-21     GCC support library
ii  libstdc++6                4.1.1-21       The GNU Standard C++ Library v3
ii  libstlport4.6c2           4.6.2-3        STLport C++ class library
ii  libufsparse               1.2-7          collection of libraries for 
comput
ii  openoffice.org-core       2.0.4.dfsg.2-5 OpenOffice.org office suite 
archit

openoffice.org-calc recommends no packages.

-- no debconf information