Your message dated Thu, 15 Mar 2007 12:47:33 +0100 with message-id <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>.
(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 ---[ please keep [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> [...] Regards, Rene ----- Forwarded message from Chris Mortimore <[EMAIL PROTECTED]> ----- Subject: Bug#414970: openoffice.org-calc: solver doesn't follow constraints Reply-To: Chris Mortimore <[EMAIL PROTECTED]>, [EMAIL PROTECTED] From: Chris Mortimore <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] ----- End forwarded message ----- -- .''`. Ren� Engelhard -- Debian GNU/Linux Developer : :' : http://www.debian.org | http://people.debian.org/~rene/ `. `' [EMAIL PROTECTED] | GnuPG-Key ID: 248AEB73 `- Fingerprint: 41FA F208 28D4 7CA5 19BB 7AD9 F859 90B0 248A EB73
--- End Message ---
