Created attachment 113462 [details]
Formula showing Goal Seek cannot solve for the solution
Mathematician, not programmer here, but LibreOffice Calc didn't seem to iterate through 20 integers on this latest problem. I was trying to solve for Pythagorean triples with the same area -- I used the INT command to plug in for the nearest integer automatically, used the pythagorean theorem for the length of the hypotenuse, subtracted the calculated hypotenuse length from the INT output of that length, and set Goal Seek to set that cell to zero. Goal Seek didn't give any valuable solutions, sets the target variable to zero and doesn't find the solution. The solution is not that difficult - any number near 12, 20, 21 or 35 should solve the equation. File attached.
(In reply to aesche from comment #0)
> The solution is not that difficult - any number near 12, 20, 21 or 35 should
> solve the equation.
So, if I understand right, that means that the problem is not linear (use of INT() function and exponentiation) and has multiple solutions.
Please, could you explain step by step what to do to reproduce the problem with your file?
Set status to NEEDINFO. Please set it back to UNCONFIRMED once you have provided requested information.
Best regards. JBF
Dear Bug Submitter,
This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INVALID
due to lack of needed information.
For more information about our NEEDINFO policy please read the
wiki located here:
If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.
Thank you for helping us make LibreOffice even better for everyone!
Closing as INVALID.
Please feel free to reopen and set as UNCONFIRMED if you are willing providing requested information.
Best regards. JBF