https://bugs.documentfoundation.org/show_bug.cgi?id=89433
Bug ID: 89433
Summary: LibreOffice Calc Goal Seek Fail
Product: Document Liberation Project
Version: unspecified
Hardware: Other
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: General
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: aes...@gmail.com
Created attachment 113462
--> https://bugs.documentfoundation.org/attachment.cgi?id=113462&action=edit
Formula showing Goal Seek cannot solve for the solution
Hi,
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
