Bug 148259 - Non-Linear Solver not correct
Summary: Non-Linear Solver not correct
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.7.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Solver
  Show dependency tree / graph
 
Reported: 2022-03-30 02:01 UTC by Dave Dixon
Modified: 2023-01-05 12:57 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
MWE of bug (63.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-03-30 02:01 UTC, Dave Dixon 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Dave Dixon 2022-03-30 02:01:51 UTC 
Created attachment 179198 [details]
MWE of bug

The attached spreadsheet is for a problem in a textbook in Resource Economics by Jon Conrad. The Solver settings are displayed on the spreadsheet, along with the solution by Excell for exactly the same problem and constraints.

Ubuntu 20.0.4
Comment 1 Dave Dixon 2022-04-18 22:10:51 UTC 
The LibreOffice Calc solver does not converge. The Excel one does.
Comment 2 Buovjaga 2023-01-05 12:57:25 UTC 
I guess I can reproduce as the results are different from the ones gotten from Excel.
In the limiting conditions I adjusted the decimal separator to my locale.

Arch Linux 64-bit, X11
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: ed259e5efe432386b54c553cbc644b3b64976852
CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded Jumbo
Built on 5 January 2023