Bug#414970: marked as forwarded (openoffice.org-calc: solver doesn't follow constraints)

[owner@bugs.debian.org (Debian Bug Tracking System)]

Your message dated Thu, 15 Mar 2007 12:47:33 +0100
with message-id <20070315114733.GK5377@rene-engelhard.de>
has caused the Debian Bug report #414970,
regarding openoffice.org-calc: solver doesn't follow constraints
to be marked as having been forwarded to the upstream software
author(s) Kohei Yoshida <kohei.yoshida@gmail.com>.

(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere.  Please contact me immediately.)

Debian bug tracking system administrator
(administrator, Debian Bugs database)

--- Begin Message ---

• To: Kohei Yoshida <kohei.yoshida@gmail.com>
• Cc: 414970-forwarded@bugs.debian.org
• Subject: [chris.mortimore@googlemail.com: Bug#414970: openoffice.org-calc: solver doesn't follow constraints]
• From: Rene Engelhard <rene@debian.org>
• Date: Thu, 15 Mar 2007 12:47:33 +0100
• Message-id: <20070315114733.GK5377@rene-engelhard.de>

[ please keep nnnn-forwarded@bugs.debian.org in Cc ]

Hi Kohei,

any idea? Is that fixed in newer scsolver patches? (2.0.4.dfsg.2-5
contains an older set, the last item in scsolver/ChangeLog is
2006-08-19  Kohei Yoshida  <kohei.yoshida@gmail.com>
[...]

Regards,

Rene

----- Forwarded message from Chris Mortimore <chris.mortimore@googlemail.com> -----

Subject: Bug#414970: openoffice.org-calc: solver doesn't follow constraints
Reply-To: Chris Mortimore <chris.mortimore@googlemail.com>,
	414970@bugs.debian.org
From: Chris Mortimore <chris.mortimore@googlemail.com>
To: submit@bugs.debian.org
Date: Thu, 15 Mar 2007 08:06:45 +0000
User-Agent: KMail/1.9.5

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


-- 
To UNSUBSCRIBE, email to debian-openoffice-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

----- End forwarded message -----
-- 
 .''`.  Ren�ngelhard -- Debian GNU/Linux Developer
 : :' : http://www.debian.org | http://people.debian.org/~rene/
 `. `'  rene@debian.org | GnuPG-Key ID: 248AEB73
   `-   Fingerprint: 41FA F208 28D4 7CA5 19BB  7AD9 F859 90B0 248A EB73

--- End Message ---