https://bugs.documentfoundation.org/show_bug.cgi?id=170333
Bug ID: 170333
Summary: Solver refuses to work, displays the unchanged value
as solution if there are 40 variables.
Product: LibreOffice
Version: 24.8.4.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Using Solver, I created a file with a column all prime numbers until 40, to the
left of the column I added numbers and to the right a product of left column
times center column. What I essentially wanted to do is make a primitive
version of prime factorization.
I found out that Solver did not even attempt to change the value, and I have
tried that multiple times. I even put a simpler version with addition instead
of multiplication and the same happened. I tried various configurations, but
nothing took me towards the right solution.
I have added the exact test file.
I have found out that if I have only three variables, it works as intended. I
am now unsure of whether to submit this as a bug or not, or to submit a feature
addition for some limitation
Steps to Reproduce:
1.Open the test file, or a similar one
2.Try using solver, setting
3.
Actual Results:
The solver displays (most of the times) the beginning state as a solution.
Sometimes it reverts to it (for example if I try setting all the zeroes in
front to 0)
Expected Results:
The solver would take a bit of time to solve the problem, but it would do it.
Or there would be a warning that 40 variables is too many.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 25.8.4.2 (X86_64) / LibreOffice Community
Build ID: 290daaa01b999472f0c7a3890eb6a550fd74c6df
CPU threads: 4; OS: Linux 6.14; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: cs-CZ
Flatpak
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
